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 load a large xml file?
What is user managed backup in Oracle?
What is a trigger and what are its types in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What are nested tables?
What language does oracle use?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
Why we choose emp number as primarykey?
What is the difference between count (*), count (expression), count (distinct expression)?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
What is Database Buffers ?
what is the difference between dbms and rdbms?