on 04-17-2009 6:14 AM
Hi All,
I doing a scenario JDBC to IDOC I need to read 3 tables of ORACLE. how JDBC sender adapter will retrieve data from more than 3 ORACLE tables and also i need to update control status fields of these tables.
Please provide me the syntax for the select and update.
Thanks in Advance
Regards,
Nisha
Hi Nisha,
As you require Select & Update both in three different ORACLE Tables then you should
use Store procedures for Sender JDBC Adapter.
If you require only Selection of data from three table then in such a case even
JOIN Select Query on different tables cab be use.
Thanks
Regards,
Jagesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jagesh Lakdawala,
Please provide me the syntax for the select and update statement and also if i go for stored procedure then where can i use this. I know that we need to use select execute 'stored_procedure1name' statement. where we are writing and storing the stored procedure.
Thanks,
Nisha
Hi,
Select Syntax:- select Table1.Field1, Table1.Field2, Table2.Field3, Tabl2.Field4
From Table1 , Table2 where Table1.Field1 = Table2.Field3.
Similary use this Syntax for three Tables.
Update Syntax: -
In SP Check if Data Seletion is suceesful then Use the seperate Update statement for each table.
like Update Table1 set Field5 = 'Value'
where Field1 = 'Value'.
Also use the refernce link provided by Mr.Vinithra Iyangar.
Thanks
Regards
Jagesh
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.