Interested to Buy Any Domain ? << Click Here >> for more details...
How to select oracle sequence from different schema and
How to select oracle sequence from different Databases.
Explain with example
- 1 Answers
- 5386 Views
- Polaris, I also Faced
- E-Mail Answers
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 |
What is truncate oracle?
What are cursor?where are they used?
How to create a new tablespace in oracle?
What are main difference between Stored Procedure and Functions.
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Explain what are the uses of rollback segment?
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
How many types of tables supported by oracle?
How to drop a tablespace?
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
Oracle General 
