How to select oracle sequence from different schema and
How to select oracle sequence from different Databases.
Explain with example
Answer Posted / harikanth
How to select oracle sequence from different schema
ANS:
a. SCHEMANAME.SEQUENCENAME.CURRVAL.
b. SCHEMANAME.SEQUENCENAME.NEXTVAL
How to select oracle sequence from different Databases
ANS:
a. SCHEMANAME.SEQUENCENAME.CURRVAL@DBLINK
b. SCHEMANAME.SEQUENCENAME.NEXTVAL@DBLINIK
Thanks,
Hari
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does sharding mean?
Which is better Oracle or MS SQL? Why?
Is insert autocommit in oracle?
What is format trigger?
How to create a table index in oracle?
What is the dynamic sql in oracle?
How can we force the database to use the user specified rollback segment?
Point out the difference between user tables and data dictionary?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What happens to the current transaction if the session is killed?
How many types of auditing in Oracle?
When do we use group by clause in a sql query?
What is connection pool in oracle?
How to change system global area (sga) in oracle?
What are the varoius components of physical database structure of oracle database?