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 ?
- 0 Answers
- 536 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What does the sign mean in sql?
What does the argument [or replace] do?
how to use myisamchk to check or repair myisam tables? : Sql dba
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
what is the difernece between named and anonymous pl/sql blocks??
Can we use joins in subquery?
Which sorts rows in sql?
How to install oracle sql developer?
What is the difference between nvl function, ifnull function, and isnull function?
we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?
How does rowid help in running a query faster?
Why truncate is faster than delete?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
