How to call DDL statements from pl/sql?5 28778
How to maintain the history of code changes of pl/sql?2 11250
what are Dynamic SQL statements?9 18492
What is pl/sql and what is it used for?4 11837
what is constraining table?2 10762
How pl/sql source code can be protected?2 8164
What can be a size of a pl/sql block? Is there any limit?2 9980
HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?2 5410
What are the advantages of VIEW?5 29489
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 ?
Explain ttitle and btitle.
How to run sql commands in sql*plus?
what is the use of double ampersand (&&) in sql queries?
Why is nosql good?
How to read/write files from pl/sql?
What is write ahead logging in sql server?
What is an inner join sql?
Can we use ddl commands in pl sql?
What are %type and %rowtype for?
What is sql query optimization?
What is foreign key in sql with example?
what is a constraint? Tell me about its various levels. : Sql dba
What are packages in pl sql and also explain its advantages?
what is collation? : Sql dba