1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
SQL PLSQL Interview Questions
Questions Answers Views Company eMail

How can we overcome recursive triggers in SQL?

iFlex,

1 8625

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

 3 8921

what eliminate duplicate without using roenum and not

Matrix,

5 8681

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

HCL,

3 9913

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

 4 18702

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

Polaris,

5 9965

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

 6 26528

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

Polaris,

7 15204

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

Virtusa,

2564

write a qurey for finding the length of the sting.

Infosys, TCS,

6 12907

how to create a database in oracle?

 3 5777

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

Sollet Soft,

1 6436

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 18465

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).

IBM,

2 7747

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

2000

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Does google use sql?

504

What is coalesce sql?

509

What is sqlservr exe?

474

Define SQL and state the differences between SQL and other conventional programming Languages?

672

How is data stored in sql?

544




What are sql injection vulnerabilities?

493

What is trigger with example?

555

Is sql injection illegal?

589

What are variables in pl sql?

554

Does mysql_real_escape_string prevent sql injection?

532

Can we rename a column in the output of sql query?

536

What are the two virtual tables available at the time of database trigger execution?

624

What are the different sql commands?

505

What is the need of a partition key?

527

What packages(if any) has oracle provided for use by developers?

5012

For More Un-Answered { SQL PLSQL } Questions Click Here