How to assign query results to variables?
No Answer is Posted For this Question
Be the First to Post Answer
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
what is the output of select * from emp where null=null & select * from emp where 1=1
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
How view is different from a table?
ABOUT IDENTITY?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How can I create database in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is a trigger oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
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
How to create a temporary table in oracle?