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

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

How can we overcome recursive triggers in SQL?


1 7803

how to create user in sql and how to set password for that?

3 7955

what eliminate duplicate without using roenum and not


5 7099

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?


3 8623

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 17133

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.


5 8200

What is a REF CURSOR? Compare strong and week ref cursor types.

6 23943

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS


7 13180

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?



write a qurey for finding the length of the sting.

Infosys, TCS,

5 9108

how to create a database in oracle?

3 4687

In a package if we have 10 procedures or functions,How to know which will execute first?

Sollet Soft,

1 5748

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.

Oracle, TCS,

13 14717

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).


2 6363

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is sql between inclusive?


What is the difference between an inner join and an outer join?


What is sql lookup?


When you have to use a default "rollback to" savepoint of plvlog?


Does sql require a server?


how many sql ddl commands are supported by 'mysql'? : Sql dba


Can we create view in stored procedure?


What are the different types of database management systems?


State few characteristics of pl/sql?


What is trigger in pl sql?


What is exception? What are the types of exceptions?


what are all the common sql function? : Sql dba


Why do we use procedures in pl sql?


What is self-join and what is the requirement of self-join?


What are inner and outer joins examples of both?