How to select oracle sequence from different schema and
How to select oracle sequence from different Databases.
Explain with example
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 |
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
What happens to the current transaction if the session is killed?
Explain table?
how many columns can a plsql table have
What is a public synonym?
primary key is foreign key for the same table?
What is a Shared SQL pool ?
How to retrieve values from data fields in record variables?
How to use null as conditions in oracle?
Define oracle database
Explain the use of rows option in imp command.
What are the different types of trigger and explain its various uses and functions?