Explain about achiever in sql?
How to call a stored procedure inside a trigger? Give an example.
How to execute a stored program unit?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
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
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
interview questions with answer for cts
What is an Oracle view?
Explain the use of file option in exp command.
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
What is a dead lock in oracle?
Explain a segment?
How to assign a tablespace to a users in oracle?