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 field delimiter?
what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
How many triggers can be applied on a table?
What do you mean by field in sql?
How is pl sql different from sql?
what is the difference between a having clause and a where clause? : Sql dba
what is the functionality of the function htmlentities? : Sql dba
What are the advantages of pl sql?
Why do we need sharding?
how to convert character strings to numeric values? : Sql dba
How to run pl/sql statements in sql*plus?
Can we rename a column in the output of sql query?
Oracle (3259)
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)