How to insert data into mulitple tables in a single statement

In one of my projects, i had a requirement to insert data into more than one table, as i dint get a chance to get more experience in pl/sql, so i asked some of my colleagues "can we insert data into more than one table" everybody said we cannot.
I just don't want to write a procedure for this and i want to insert data into more than one tables. so i cannot use the below example as well because, with this you can insert into a single table only
insert into table_name values (select * from table_name)
I just thought googling to get some answer, i luckily found some forums which was explaining the "INSERT ALL " concept, with this concept you can insert into more than one table.
The below example will give you clear idea about the "INSERT ALL" concept.
Example:
1. Create a table A and B
2. Insert data into A and B in a single statement
create table tablea (sno number, name varchar2(20));
create table tableb (sno number, name varchar2(20));
3. insert all
into tablea(name) values ('THIS IS TABLE A')
into tableb(sno, name) values ('1','THIS IS TABLE B')
select 1 from dual;
4. select * from tablea;
Name
----------
THIS IS TABLE A
5. select * from tableb;
sno Name
----------------
1 THIS IS TABLE B
This is a new concept comes up with the 10g (10.1.2) feature. Make use and Enjoy.
I got the above information from a forum answered by Nicolas.Gasparotto.
Thanks Nicolas.

Self Appraisal

I got the below story from my friend last week, thanks Sakthi
A little boy went into a drug store, reached for a soda carton and pulled it over to the telephone. He climbed onto the carton so that he could reach the buttons on the phone and proceeded to punch in eight digits (phone numbers).
The store-owner observed and listened to the conversation:
Boy: 'Lady, Can you give me the job of cutting your lawn?
Woman: (at the other end of the phone line): 'I already have someone to cut my lawn.'
Boy: 'Lady, I will cut your lawn for half the price of the person who cuts your lawn now.'
Woman: I'm very satisfied with the person who is presently cutting my lawn.
Boy: (with more perseverance): Lady, I'll even sweep our curb and your sidewalk, so on Sunday you will have the prettiest lawn in all of Palm beach, Florida.'
Woman: No, thank you.With a smile on his face, the little boy replaced the receiver.

The store-owner, who was listening to all this, walked over to the boy.
Store Owner: 'Son... I like your attitude; I like that positive spirit and would like to offer you a job.'
Boy: 'No thanks,
Store Owner: But you were really pleading for one.
Boy: No Sir, I was just checking my performance at the job I already have.
I am the one who is working for that lady, I was talking to, and I was doing my 'Self Appraisal'

How to setup SVN in your Desktop / Laptop

How to setup SVN in your Desktop / Laptop

How to configure the SVN set up to your laptop / Desktop
1. Download and install the TortoiseCVS-1.8.1.exe, wincvs - setup.exe
2. Download and install TortoiseSVN-1.4.4.9706-win32-svn-1.4.4.msi
3. After installation, create a folder in your local directory and right click and click on the network link
4. Configure the proxy setting
Host Name: oracle proxy Port Number: 80
No need of username and password.
5. After configuration right click on the folder and select checkout module, enter the url where you want to check out. It will prompt you with, username and password for SVN access. https://hostname/svn/foldername/
6. Once you enter the username/password then you can get the entire folder and all the required documents.
If you have any doubts, update this post with your error messages, wll resolve it

How to get the port numbers after installing SOA 10g Suite and How to make connection using JDeveloper to the SOA Suite 10g

To know the port numbers after installation, refer to the following file in the below locations.
1. Home\bpel\utilities\ant-orabpel.properties file
2. Make note of the ports being used by the following properties.
· http.port
· opmn.requestport
These port values are required, while making connection to the application server and integration servers.
3. Run the below command in the /opmn/bin folder
opmnctl status -port
To get the other port numbers
opmnctl status -l output
by running the above commands you can get the opmn ports.
How to make connection to the SOA Suite using JDeveloper
While creating connection to the application server, you will be asked to check the deploy password check box. Please check the deploy password check box, otherwise whenever you deploy the process, you will be asked to enter the password again and again.
While creating connection to the application server, these are the parameters used for the connection.
In the Jdev click on the Connection Navigator tab, click on the Application Server connection and create new connection.
1. Provide a new name for the connection, ex: SOASuiteAppConn
2. Enter the following information.
a.UserName: oc4jadmin
b. Password: password
c. HostName: hostname or ipaddress
d. Single instance / Group : select accroding to your requirement
e. Oc4jInstanceName : Key-in the oc4j container name.
f. opmn port : opmn port number
3. Click next and check your connection using the test button.

Integration Connection:
Click on the integration connection in the same connection navigator window.
1. Provide a name for the integration server connection, ex: SOASuiteIntegConn.
2. In the connection tab, use the application server connection here (SOASuiteAppConn)
Provide the HostName or ip address.
Enter the port number.
3. Click next, here test your connection. You should be able to see the following connection with out fail.
Application Server: OK
BPEL Process Manager Server: OK
ESB Server: OK
If you still not able to make connection, please update this post with your comments.

Oracle ESB - Enterprise Service Bus

What is Inbound and Outbound in ESB : Oracle Enterprise Service Bus Server enables you to define inbound and outbound adapter services. An inbound adapter service receives data from an external data source and transforms it into an XML message. An outbound adapter service sends data to a target application by transforming an XML message into the native format of the target application.

Oracle AIA

I have attended Oracle AIA Deep Dive from 10-14 March 2008. Oracle AIA stands for Oracle Application Integration Architecture, a new integration architecture from Oracle, using Oracle SOA components.

CAVS in AIA
CAVS expanded as Composite Application Validation System. This is used to test your integration points of the applications. If you want to test your integration scenaios you can test individual end points with your really integrate. TEST is used to test your live endpoints. To TEST you end points you have send the request soap messages, the webservice will send you the response. To

BPEL Tips

1. Whenever you use a custom xsd file, drop the file under the bpel folder inside the project folder. So that you can avoid some compilation errors. After copying the xsd and you have defined the request and response according to that, and if you are not able to see those values in structure window under the variables. Even after you did couple of time refresh, restart the JDeveloper. I hope this issue is fixed in Jdev 11g, i havent tried. If you have tried this, please update me with your comments.

2. Whenever you are using the EMAIL functionality of the BPEL process, dont forget to mention the from account, if you are using the from account as "Default" make sure the first letter in CAPS, otherwise the the bpel process will not throw any error message, but the mail will not be sent.

Difference between BPEL and ESB

What is the difference between BPEL and ESB
Adv BPEL
Bpel is used for orchestration of processes.
Bpel is deployed to the server.
Bpel maintains the version control for the process deployed.

Adv ESB
ESB is mainly used for virtualization of endpoints, routing and transformation.
ESB is a light weight component.
ESB is registered to the server.
ESB doesn't maintain the version control. whenever you register it will delete the old version and register with new code.

How many ways you can call a BPEL Process

A BPEL Process deployed on the Process Manager can be invoked in 3 different ways as mentioned below.

a. Using the BPEL Console's Initiate tab, this is where you will mention about the xml data to be passed into the bpel process. You can define the input in 2 ways either in XML format or HTML format.
b. Using the Java API published by Oracle BPEL Process Manager
c. Using the Web service/Soap Interface using endpoint of the process.
d. Creating the web service client using the WSDL file of the process.