Interested to Buy Any Domain ? << Click Here >> for more details...
How to select oracle sequence from different schema and
How to select oracle sequence from different Databases.
Explain with example
- 1 Answers
- 5215 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 |
Explain the use of log option in exp command.
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
Why should I use oracle database?
what are the things that you consider while creating indexes on partitioning tables?
What is the use of aggregate functions in oracle?
What is the usage of save points in oracle database?
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
Can we protect our pl/sql source code?
What is a Garbage Collection? and what is full recursive Garbage collection?
Explain the use of show option in imp command.
How to rename an index?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
Oracle General 
