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 |
How to declare a local variable?
12 RULES OF RDBMS
What is a parameter file in oracle?
How can you Enforce Referential Integrity in snapshots ?
Does oracle partitioning improve performance?
how many columns can a plsql table have
Why do you create or replace procedures rather that drop and recreate.
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
How to start an oracle instance?
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
What is tns entry?
What is the difference between I and G in Oracle?