Sign Up Login


  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

How to select oracle sequence from different schema and

How to select oracle sequence from different Databases.

Explain with example

Question Posted / harikanth

Answer Posted / harikanth

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens to the current transaction if a ddl statement is executed?

767

How to drop an index in oracle?

802

What are the differences between number and binary_float in oracle?

823

How to delete all rows a table in oracle?

807

What is a package ? What are the advantages of package ?

825

What is an oracle database?

789

what are the default admin accounts in Oracle 10g ?

750

What is oracle sid?

684

can anyody please send me the dump for Oracle 10g certifications for DBA path?

1912

What is an oracle transaction?

788

Difference between inner join vs where ?

787

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2793

How to resolve the ORA-39133 error in Oracle?

793

Does facebook use oracle?

788

Explain the use of record option in exp command.

745