How to select oracle sequence from different schema and
How to select oracle sequence from different Databases.
Explain with example
- 1 Answers
- 4849 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 suggestions do you have to reduce the network traffic?
Please explain drop constraint oracle?
What privilege is needed for a user to delete rows from tables in another schema?
How many types of segments in Oracle?
What privilege is needed for a user to create tables in oracle?
What exactly do quotation marks around the table name do?
How to use subqueries with the in operator using oracle?
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
what is the difference between UNION AND UNIONALL
How to connect to the server with user account: sys?
What are the ways tablespaces can be managed and how do they differ?
Oracle General 
