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

Can we have exception part in trigger ?

1 5977

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 10565

what is meant by databases

4 3611

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

7 20934

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 3673

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

Infosys, Rolta,

20 16243

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 27996

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

Steria, Wipro, Zensar,

3 16181

cursor types? explain with example programs?

HP,

1 4338

<> 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 3309

what is the use of HASH, LIST partitions?

ITC Infotech,

1 3608

what is SCALAR Queries?

ITC Infotech,

2 5474

what is HASH join?

Genpact, HCL,

2 10355

what is overloading procedure or overloading function ?

Genpact,

3 5551

how to create table with in the procedure or function?

Genpact, HCL,

2 12409


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

Can function return multiple values in sql?

144


Explain some predefined exceptions.

189


what is the difference between sql and t-sql? : Transact sql

197


How to raise user-defined exception with custom sqlerrm ?

184


Can we rollback truncate?

145






What is sequence in sql?

141


How many types of cursors supported in pl/sql?

187


What is sharding in sql?

140


i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

477


Is sql between inclusive?

153


What is difference between function and trigger?

136


What is a nested table in word?

150


What are the two types of cursors in pl sql?

137


What are types of joins?

142


what is commit? : Sql dba

171