Dear All,
I have two schema in my network.Let say one is AMS and Another is AMSDATA.
Both contains same table.Let say both the schema have employee table.
But the schema of AMSDATA's employee table data will reflect in AMS
schema of Emplyee table.
Means when i execute the procedure the schema of AMSDATA's employee table data will always updated in schema of AMS's employee table data.
Sir i am java/j2ee programmer.I am having bit idea in pl/sql.I am using pl/sql program in my
j2ee project.
Could please guide me for my requiremnts query of simple example so that i can implement in my project.
Else could please tell like Javaranch in j2ee which site is best site for
posting any oracle related query.
Thanks in Advance.
Regards
Sumanta Panda
----------------------------------------------------------
AMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.106.87)(PORT = 1521)
)
)
(CONNECT_DATA = (SERVICE_NAME = AMS)
)
)
AMSDATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.106.88)(PORT = 1521)
)
)
(CONNECT_DATA = (SERVICE_NAME = AMSDATA)
)
)
