Table A Table B
1 1
2 1
3
1. Union & union all --> A Union B , A Union all B
2. Minus , Intersect --> A minus B , B Minus A , A Intersect B
3. Joins A join B , A Left Join B A Right Join B , A full Join B
4. %Type - Uses & Benifit
5. Truncate & Delete
6. Pragma Autonomus Transaction
7. how to Perform DDL from function or procedure
8. Can we have DML inside Function
9. Rank & Dense Rank diffrence
10. Water Mark in Oracle
11. Index , Can we have index in all column of table if no then why ?
No Answer is Posted For this Question
Be the First to Post Answer
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
Wat is SGA ?
What is pl sql block structure?
Why do we need cursor in pl sql?
Difference between SUBSTR and INSTR?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What are the modes of parameters that can be passed to a procedure ?
Why we use pl sql?
How many tables can you join in sql?
Can we use pl sql in mysql?
Are stored procedures faster than queries?
Can a foreign key be null?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)