Follow Our FB Page << >> 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?



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.


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.


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.


2 1897

how to we delete a row using varray


3 2310

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


2 2355

difference between bind variable and variable


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


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


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.



Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to convert characters to numbers in oracle?


How to establish administrator authentication to the server?


Where is the export dump file located?


How to speed up webrick?


List the various oracle database objects?


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


How do I escape a reserved word in oracle?


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


Explain constraining triggers.


How to define a procedure inside another procedure?


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


What is an anonymous block?


Explain integrity constraints?


What is difference between truncate and delete?


How to start an oracle instance?