With what ways can we find out instance locks?

Jose George

• Oct 22nd, 2012

V$lock contains details of locks

Answer Question  Select Best Answer

How can we find out the dependencies on a table?

srikanth goduru

• Oct 10th, 2012

Check the table dba_dependencies and see what other tables are affected.

Answer Question  Select Best Answer

There are 2 tables, A and B having 3 rows each. What will be result on executing the following query? : SQL> select * from A,B

Raju TT

• Jun 11th, 2013

Cross join -cartesian product :Table a no. of rows (3) * Table b no.of rows (3)= cross join query returns 9 rows

Code
SELECT  * FROM a CROSS JOIN b ;

Arpit Agrawal

• May 24th, 2013

Here simply answer would be 6. Since a is having 2 rows and b is having 3 rows. And we go for Cartesian join, which means 3*2=6.

Answer Question  Select Best Answer

How can we debug stored procedures in PL/SQL?

prasadkrish

• Jun 10th, 2014

In procedure function can be able to use ?if yes means give example

ram

• Jul 31st, 2013

Can any one tell how to retrieve more than one table structure at a time?

Answer Question  Select Best Answer

What are the advantages of bulk binding in PL/SQL?

sachin rasal

• Nov 12th, 2015

A new feature called "bulk binds" was added to PL/SQL back in Oracle 8i. Bulk binds enable a PL/SQL program to fetch many rows from a cursor in one call instead of fetching one row at a time. Bulk bin...

amala

• Jun 24th, 2015

It retreives multiple rows with a single fetch...It increases the performance by reducing no.of context switches

Answer Question  Select Best Answer

Can we give COMMIT or ROLLBACK within a trigger?

Abhijit Musale

• Feb 19th, 2015

Using PRAGMA AUTONOMOUS_TRANSACTION we can treat the child transaction as a separate transaction, committing which wont affect the parent transaction.

Tushar

• Feb 17th, 2015

No we cant used it.because it affected on logical processing. It is possible using Pragma

Answer Question  Select Best Answer

Can a type body be dropped without dropping the type specification?

ramya

• Oct 31st, 2012

When you drop a type body, the object type specification still exists, and you can re-create the type body. Prior to re-creating the body, you can still use the object type, although you cannot call the member functions.

Answer Question  Select Best Answer

What are the types of collection in PL/SQL? What is the advantage of nested tables?

pawan

• Nov 6th, 2012

Varrays,nested tables,index by tables are oracle collection.Index by tables also known as associative array similar to hashtables in java. Varrays are like arrays in java static in nature need to d...

Answer Question  Select Best Answer

In what ways can data be copied from one table to another?

Neeraj Saxena

• Apr 12th, 2013

You can copy the data from one table to another with the help of below Query:

Suppose dummy is the main table and we need to copy the data from dummy_120413 table.

Create tabel dummy_120413 as Select * from dummy;

Answer Question  Select Best Answer

What is an autonomous transaction?

Sonal

• Nov 8th, 2012

The AUTONOMOUS_TRANSACTION pragma changes the way a subprogram works within a transaction. A subprogram marked with this pragma can do SQL operations and commit or roll back those operations, without ...

VASU

• Oct 20th, 2012

BY USING AUTONOMOUS TRANSACTION
WE GET THE FOLLOWING ADVANTAGES
WE PROCEDURE HAVING TRANSACTIONS STATEMENTS WE CALL PROCEDURE AUTOMATICALLY EFFECT THE ABOVE TRANSACTIONS ALSO TO OVERCOME THAT PROBLEM WE HAVE TO USE AUTONOMOUS TRANSACTION..

Answer Question  Select Best Answer

What is a global temporary table?

Aijaz

• Oct 14th, 2012

Global temporary tables are the permanently created tables for a timed session.
Only the data in the table is temporary but the table is permanent in the Oracle database.

Answer Question  Select Best Answer