what is outer join? what is selef join? what is difference between them? what is cartecion join?
1 10123If 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 5959Hi 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 6262If 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 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?
