How to select an oracle system id (sid)?
No Answer is Posted For this Question
Be the First to Post Answer
In the oracle version 9.3.0.5.0, what does each number shows?
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
What are the types of trigger in oracle?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
Is oracle an operator?
What is flashback in Oracle?
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
What is a server parameter file in oracle?
how to get the index id?
How do you tell what your machine name is and what is its IP address?
What is rich query?
Explain the difference between replace() and translate() functions in oracle?