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 are the ways tablespaces can be managed and how do they differ?
how to handle exceptions in post production
Explain rename?
What are the differences between blob and clob in oracle?
Explain oracle instance.
How do I start tns listener?
How many data types are supported?
What is an oracle wallet?
How to execute the package in oracle?
How many types of tables are there in oracle?
How to write a query with a right outer join in oracle?
How to run the anonymous block again?
What are the uses of a database trigger?
What is the dynamic sql in oracle?
How to drop an index in oracle?