what is outer join? what is selef join? what is difference between them? what is cartecion join?
1 10481If 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 6318Hi 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 7017If 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?
9 13447
How do I run pl sql in sql developer?
What are sql functions? Describe in brief different types of sql functions?
What are the different parts of a package?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
Why do we create views in sql?
What does pl sql stand for?
Do ddl statements need commit?
What is blind sql injection?
How to return multiple rows from the stored procedure?
Name the different types of indexes in sql and define them.
What is sorting in sql?
Why does sql need a server?
How does index help in query performance?
Can we alter stored procedure?
how to dump a table to a file with 'mysqldump'? : Sql dba