what is outer join? what is selef join? what is difference between them? what is cartecion join?1 10123
i need department wise top 2 employees salary.which logic i will use17 26328
If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??3 5959
Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..8 6262
If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?8 11253
What is bulk collections?2 5939
what is difference between decode and case function?2 8656
what are all the common sql function? : Sql dba
How do I pipe the output of one isql to another?
What is the syntax to add a record to a table?
Explain the purpose of %type and %rowtype data types with the example?
how to do backup entire database? : Transact sql
How is a process of pl/sql compiled?
What is difference between cursor and trigger?
what is the difference between myisam static and myisam dynamic? : Sql dba
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
what is the difference between char_length and length? : Sql dba
What are the types of queries in sql?
How is a PL/SQL code compiled?
What does t sql mean?
Does sql use python?
How do temporal tables work?