Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is the difference between granting and creating a view?

2 4160

How to return multiple records from procedure?

2 6996

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

2 4780

Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 7538

How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

2 4786

If records are inserted into table without committing.How to refer to these values in a procedure?

2 5620

what is ref cursor in pl/sql?

3 19836

How to fetch the rows by dynamicaly passing table name through cursor?

3 7872

what is difference between "Primary key" and "Unique key"?

PreVator,

4 6445

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

Fujitsu,

2 11074

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?

PreVator,

7 15086

How the execution will be done in exceptions?

2 5066

What is the difference between sql/pl-sql/embeded sql?

3 10227

what is the forward decleration in packages?

1 4506

In packages the source code is compiled into p code ? how do we describe the p code

3 4621


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

What are the different datatypes available in PL/SQL?

167


What is the difference between mdf and ndf files?

124


How can check sql version from command line?

111


what are the performance and scalability characteristics of mysql? : Sql dba

133


what are all the common sql function? : Sql dba

138






Is sql better than excel?

107


Which data type is a composite type?

105


What is the difference between delete and truncate statement in sql?

128


How does cross join work?

120


What is a join?

163


What is sqlexception in java?

109


What are all different types of collation sensitivity?

150


What is on delete set null?

111


Explain sql data types?

153


How many tables can you join in sql?

112