jagadeesh9

 Profile Answers by jagadeesh9 Questions by jagadeesh9

• Feb 22nd, 2008

Lexical P.M is used to pass string& is there it is Lexical P.M.we can use in FROM clausewe can't use in PL/SQL

devenar

 Profile Answers by devenar Questions by devenar

• Nov 19th, 2007

You can create a lexical parameter(references) by entering an ampersand (&) followed immediately by the column or parameter name.Lexical parameter are placeholders for text that you embed in a SEL...

Answer Question  Select Best Answer

saleem

• Nov 21st, 2011

1) On-Check-Delete-Master Fires when Oracle Forms attempts to delete a record in a block that is Master block in a master-detail relation 2)On-Clear-Details Fires when Oracle Forms needs to clear rec...

shahnirav86

 Profile Answers by shahnirav86 Questions by shahnirav86

• Jul 2nd, 2008

1) Which trigger are created when master -detail rela?1) master delete property *  NON-ISOLATED (default) a) on check delete masterb) on clear detailsc) on populate details  *...

Answer Question  Select Best Answer

 There are two types of cursors, Implicit  Cursor and Explicit Cursor.PL/SQL uses Implicit Cursors for queries.User  defined cursors are called Explicit Cursors. They can be declared and used.

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 6th, 2008

Cursors are of two types1. Implicit Cursors: -  Whenever we execute sql statements oracle server assigns a work area called private sql area to store precessed infomation. The most recently used ...

Lavanya Chowdary

 Profile Answers by Lavanya Chowdary Questions by Lavanya Chowdary

• May 6th, 2007

There r two types of cursors in the pl/sql1.Implici 2.explicit For the select stmt which is retrieving single record or all the dml operations in the pl/sql program system automatically allocates...

Answer Question  Select Best Answer

 %  TYPE  provides  the data type of a variable or a database column to that variable. % ROWTYPE  provides the record type that represents a entire row of a table or view or columns selected in the cursor. The advantages are : I. Need not  know about variable's data typeii.  If  the  database  definition of a column in a table changes, the...

PRADEEP

• Oct 16th, 2012

%rowtype is associated entire table(if we want to declare all columns then we need to declare %rowtype).

%type is associated with one column .(if we want to declare entire column then we need to declare %type).

Yaseen

• Aug 9th, 2012

If using %type and %rowtype , no need to know the the data type of the table column . and once the development is finished , the type of column is changed it will not effect the coding.

Answer Question  Select Best Answer