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

Can we have exception part in trigger ?

1 6602

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

HCL, JPMorgan Chase,

5 12836

what is meant by databases

 4 4813

How many levels can subqueries be nested in a FROM clause?

 7 23626

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 4390

How to get employee name from employee table which is the fiveth highest salary of the table

Infosys, Rolta,

20 23312

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

 8 31629

what is difference b/w pravite procedures and public procedures?

Steria, Wipro, Zensar,

3 18457

cursor types? explain with example programs?

HP,

1 5074

<> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

ITC Infotech,

1 4155

what is the use of HASH, LIST partitions?

ITC Infotech,

1 4441

what is SCALAR Queries?

ITC Infotech,

2 6583

what is HASH join?

Genpact, HCL,

2 11447

what is overloading procedure or overloading function ?

Genpact,

3 6718

how to create table with in the procedure or function?

Genpact, HCL,

2 13599

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is sql a scripting language?

503

Are sql database names case sensitive?

488

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

5005

What is the difference between jpql and sql?

540

Define join and name different types of joins?

507




What is primary and foreign key?

583

Is natural join and inner join same?

479

Explain constraints in sql?

560

How to call a javascript function from pl sql?

553

Is left join same as join?

504

What is the difference between pl and sql?

534

How do I use google cloud in sql?

525

What is a temporal table?

480

What is embedded sql what are its advantages?

492

What is difference between sql and mysql?

517

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