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
- 5305 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 the purpose of save points in oracle database?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What is the quickest way to fetch the data from a table?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is tns entry?
Explain the use of parfile option in exp command.
What are temporal data types in oracle?
List the various oracle database objects?
How to use values from other tables in update statements using oracle?
What are the uses of a database trigger?
How to retrieve values from data fields in record variables?
Oracle General 
