1) Synonyms
2) Co-related Subquery
3) Different Jobs in Plsql
4) Explain Plan
5) Wrap
6) Query Optimization Technique
7) Bulk Collect
8) Types of index
9) IF primary key is created then the index created ?
10) Foreign Key
11) Exception Handling
12) Difference Between Delete and Trunc
13) Procedure Overloading
14) Grant Revoke
15) Procedure Argument types.
16) Functions.
17) Joins
No Answer is Posted For this Question
Be the First to Post Answer
What is varray in pl sql?
Cite the differences between execution of triggers and stored procedures?
Which one is better subquery or joins?
What is the difference between python and sql?
The select into statement is most often used to create backup copies of tables or for archiving records?
Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.
Do you understand the meaning of exception handling?
What are some emotional triggers?
How to write a query to show the details of a student from students table whose
What is difference between TRUNCATE & DELETE?
16 Answers Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,
Why is pl sql used?
What is normalization? dec 2009
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)