MURTHY

• Sep 7th, 2011

the question is very nice. yes we can have 2 triggers with same body but with different names. ex: create trigger trg1 .................... ............................... end; create tri...

Baji Shaik

 Profile Answers by Baji Shaik Questions by Baji Shaik

• Jun 5th, 2011

yes, we cant said upto 10g oracle server executes the triggers randomly,but 11g we are having a feature follows clause,by using this we have to control the execution of triggers explicitly by the deve...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

g_sidhu  

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 1st, 2008

---

Before a PL/SQL program can be executed, it must be compiled. The PL/SQL compiler resolves references to Oracle objects by looking up their definitions in the data dictionary. Then, the compiler assigns storage addresses to program variables that will hold Oracle data so that Oracle can look up the addresses at run time. This process is called binding.

How a database language implements binding affects runtime efficiency and flexibility. Binding at compile time, called static or early binding, increases efficiency because the definitions of database objects are looked up then, not at run time. On the other hand, binding at run time, called dynamic or late binding, increases flexibility because the definitions of database objects can remain unknown until then.

Art11

 Profile Answers by Art11 Questions by Art11

• Sep 25th, 2011

This is the best answer I found:

Early binding is checking for existence of objects referred in the program unit during the compilation phase. Late binding will not check the existence of objects till the runtime

pramodh holla

 Profile Answers by pramodh holla Questions by pramodh holla

• Sep 21st, 2010

It uses deferred binding...in the sense it uses both static and dynamic binding.

Improve Answer

Dharma

• Oct 14th, 2011

Code
 

mohan

• Oct 14th, 2011

SELECT * FROM TABLE_NAMEWHERE (ROWID, 0) IN (SELECT ROWID, MOD(ROWID, N) FROM TABLE_NAME);

Answer Question  Select Best Answer

What is Force View. Why Oracle Give Facility to create force view? What is the use of force View

sonam kanungo

• Oct 15th, 2011

As per my knowledge when view is created without base table.then the view is called as forced view.

in this type of view is created with compilation error.

mohan

• Oct 14th, 2011

If we create a view without having base table, that view called as forced view. it will create with compile error. it will be in invalid till base table create.

Answer Question  Select Best Answer

pankti

• Apr 6th, 2012

Nested table Unbounded ...

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 6th, 2008

A Table is a basic unit of storage in oracle.A nested table is a collection type. The main advantage of collections is instead of processing data sequentially, we may process all the date&nb...

Answer Question  Select Best Answer

Aniruddha Das

• Jun 11th, 2012

If you want to take care of performance tuning you need to take care of sub-queries as they takes a lot of time to executing in side the pl-sql blocks.

ptmich

 Profile Answers by ptmich Questions by ptmich

• May 28th, 2012

Ref cursor is used to declare a pointer variable. When you return a ref cursor, you are returning a pointer variable.

Answer Question  Select Best Answer

          Cursor C1 is          Select empno,          ename from emp;          Begin               open C1;           ...

Vivek

• Jun 29th, 2012

After committing first oracle will commit the transaction into redo log file and then Data file. The data block will remain into the memory until the logical reads are going on. Oracle use LRU algorit...

Art11

 Profile Answers by Art11 Questions by Art11

• Sep 27th, 2011

The data will be written from redo log buffer into redo log files.

Answer Question  Select Best Answer

ChevyBlazer

 Profile Answers by ChevyBlazer Questions by ChevyBlazer

• Jul 2nd, 2012

The answer will be between 11-14 . You have to consider two extreme cases where 1. 3 rows with a=10 and 11 rows with b=20 are all distinct rows - then the answer will be 14 2. Where there are 11 rows...

Venkat

• Jun 30th, 2012

The accurate answer is "The result can contain max of 14 records", but this not guaranteed. It can be less also. (Minimum is 10 rows and maximum is 14 rows). It is because there can be some overlpa in the same row between "a" and "b" column.

Answer Question  Select Best Answer

Vishal R Bhadange

• Aug 12th, 2012

Yes.
Yes we can truncate some of the rows from the table, But table should be partitioned & all the rows to be deleted should be present in one single partition...

leelakrishna302

 Profile Answers by leelakrishna302 Questions by leelakrishna302

• Jun 15th, 2012

We cannot

Answer Question  Select Best Answer

HI all
table contain some 1000 records, today I inserted 100 records into table, so I want first 10 records data from 100 records
how can I retrieve

kapil joshi

• Sep 15th, 2012

Select * from employees where rownum

Manoj Kumar

• Aug 28th, 2012

Code
 

Answer Question  Select Best Answer

PRADEEP

• Oct 16th, 2012

Ref cursor is having return type where as cursor does not have .
syntax of ref cursor:- type ref_type_name is ref cursor [return return_type].

syntax of cursor:- declare
cursor cursor name select statement..

pradeep

• Jan 8th, 2012

Normal cursors do have a return type. ex:

Code
 

Answer Question  Select Best Answer

rayavarapu

 Profile Answers by rayavarapu Questions by rayavarapu

• Jan 23rd, 2013

Null is not a value and not a string. It is unknown it is maximum in descending order and minimum value in ascending order.

Sandeep

• Mar 7th, 2012

Char(0)

Answer Question  Select Best Answer

Is it possible to use function inside a trigger.

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 16th, 2013

Code
span style="font-style: italic;">--referencing old as old and new as new

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 16th, 2013

Yes, by using CALL statement.

Answer Question  Select Best Answer

Varun Tiwari

• Jul 4th, 2013

Any data transaction control statement can not be used in triggers. As trigger invokes due to any DML event and the transaction may not be successfully commit later and may need to complete rollback.

Pragma_autonomous can be used as an alternate way to commit.

prashant mhatre

• Jun 13th, 2013

Can not used ...if we want to use it inside the trigger then use pragma_autonomous.

Answer Question  Select Best Answer

JILEY SINGH

 Profile Answers by JILEY SINGH Questions by JILEY SINGH

• Aug 4th, 2013

Function can be called in select statement but procedure cant be called in select statement. function has return keyword but procedure not

Varun Tiwari

• Jul 4th, 2013

Function Procedure 1. Can be used as column Cant used in select statement in select statement 2. Can be used in where Cant used in where condition c...

Answer Question  Select Best Answer

Procedure A calls procedure B. A updates table t1, t2. B updates table t3. If some error happens to B what happens to the updates in all those tables? Whether they will rollback or commit? If commits how far it will commit?

vishal.bhadange

 Profile Answers by vishal.bhadange Questions by vishal.bhadange

• Aug 24th, 2013

CASE 1 (If you are not handling exception in Procedure B, none of the table gets updated) "sql PROCEDURE A BEGIN UPDATE TABLE t1; UPDATE TABLE t2; CALL PROCEDURE ...

Answer Question  Select Best Answer

Malar somu

 Profile Answers by Malar somu Questions by Malar somu

• Sep 10th, 2013

Implicit Cursor:- It is Oracle implicit type.. when we fetch only one record then we need to use implicit cursor i.e when ever we performing select query or any dml operations termed as implicit curso...

hira

• Aug 8th, 2013

When ever any query execute by the server in database sever itself create a implicit cursor ,which can not any control to the programmer but in case explicit cursor the programmer has to create it.and used for the data manipulation by following some rule......

Answer Question  Select Best Answer

What are bind variables in sql? explain in detail?

pradipta

 Profile Answers by pradipta Questions by pradipta

• Feb 8th, 2014

The way to get Oracle to reuse the execution plans for "the statements having different hard coded value in where clause" there should use bind variables. Bind variables are ?substitution? variable...

Aarti

• Jan 15th, 2014

Bind variable is session specific variable. It is declared using variable keyword. Bind variable cant be used in named block. It cant have default value.

Answer Question  Select Best Answer

Pixie

• Feb 18th, 2014

PL/SQL tables are PL/SQLs way of providing arrays. They are temporary tables in memory and thus are processed very quickly. They are not database tables, and DML statements cannot be issued against...

sbagai2001

 Profile Answers by sbagai2001 Questions by sbagai2001

• May 30th, 2006

DECLARE   TYPE EmpCurTyp IS REF CURSOR;   // Reference Cursor - weak    TYPE NumList IS TABLE OF NUMBER;  // Table of Number   TYPE NameList IS TABLE OF VA...

Answer Question  Select Best Answer

What is the main purpose of RETURN in functions when we can calculate a value and pass it through using OUT mode in procedure or functions?

Deepika S Verma

• Mar 14th, 2014

Its a myth that function returns value whereas procedure does not, actually procedure also return value (i.e. 0 or 1 ) at the time of exiting which indicates the success or error. Whereas Function ret...

shivigupta

 Profile Answers by shivigupta Questions by shivigupta

• Oct 9th, 2012

create or replace procedure proc1 as begin dbms_output.put_line(Before Return Clause); return; dbms_output.put_line(After Return Clause); end; set serveroutput on; begin proc1; dbms_output.put_line(I...

Answer Question  Select Best Answer