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

Oracle General Interview Questions
Questions Answers Views Company eMail

Can you use a commit statement within a database trigger?

4 2678

What WHERE CURRENT OF clause does in a cursor?

1 2242

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

Oracle,

1068

which institute and which faculty is providing best training for oracle sql, plsql in hyderabad

4 2683

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

MasterCard,

1 2311

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

MasterCard,

1 1808

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

MasterCard,

2 1897

how to we delete a row using varray

CTC,

3 2310

if i am using dml statement in function. then i am writing select statement what was the output

MasterCard,

2 2355

difference between bind variable and variable

Attra,

1 1707

how to i write the query 'NISHI' TO N I S H I

Attra, Metric Stream,

4 4591

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

TCS,

1 1832

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6

TCS,

2 2353

write a query that displays every Friday in a year with date?

Flipkart, HCL, TCS,

5 3361

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

TCS,

876


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

How to convert characters to numbers in oracle?

183


How to establish administrator authentication to the server?

166


Where is the export dump file located?

178


How to speed up webrick?

160


List the various oracle database objects?

177






How will you write a query to get a 5th rank student from a table student_report?

186


How do I escape a reserved word in oracle?

189


What is the purpose of tables, private synonyms and public synonyms in Oracle?

178


Explain constraining triggers.

164


How to define a procedure inside another procedure?

172


What are the components of logical database structure in oracle database?

167


What is an anonymous block?

173


Explain integrity constraints?

180


What is difference between truncate and delete?

175


How to start an oracle instance?

182