How to return top 5 rows in oracle?
What are the major difference between truncate and delete?
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
What is index in Oracle?
how to find find & delete duplicate rows from two different tables?
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 are the different editions of oracle?
What are the various oracle database objects?
Where do we use decode and case statements?
Explain the use of Merge statement in oracle 11g
How to retrieve the count of updated rows?
what diffrence between function and procedure?