Rakesh057

 Profile Answers by Rakesh057 Questions by Rakesh057

• Jul 19th, 2014

NO.. triggers are auto commit no need of commit or rollback

Rpradeep

 Profile Answers by Rpradeep Questions by Rpradeep

• Jul 7th, 2014

Yes we can use commit or rollback statements in trigger by using AUTONOMOUS_TRANSACTION pragma.

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

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

Why we use cursor in plsql? in same case can we use cursor or procedure?? difference between cursor , procedure and package?? is any relation between 3??

parul priya

• Nov 20th, 2014

We use cursor when we need to handle multiple rows query in plsql.

Bhanuprasad

• Nov 15th, 2014

Cursor in Plsql: When we execute sql query. The records fetched from sql query, information about sql query is stored in context memory area in oracle. so in order to access each record row by row we ...

Answer Question  Select Best Answer

How many types of PL/SQL Triggers are there? What are they?

Chandra sekhar

• Jun 23rd, 2017

Two types
ROW LEVEL
STATEMENT LEVEL

Yogesh

• Jun 2nd, 2017

Basically the are 5 type of trigger on basis of triggering events
1. DML
2. DDL
3. System or schema level
4. Compound
5. Instead of

Answer Question  Select Best Answer

 Raise_application_error  is  a  procedure  of  package  DBMS_STANDARD which allows  to  issue an user_defined error messages from stored sub-program or database trigger.

Ashutosh

• Oct 8th, 2012

Their classes of errors and diff. errors are divided among these classes simply because of ease in classification, For defining errors and error message with raise_application_error procedure by users...

SARANYA

• Jul 25th, 2011

I know that the error no in raise_application_error are non standard but tell me on what basis we are giving those numbers? is that simply a number or it some implicit meaning ?

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Jan 31st, 2008

In addition to modularizing application development, stored procedures and functions have thefollowing benefits:1) Improved performanceAvoid reparsing for multiple users by exploiting the shared SQL a...

deviji2000

 Profile Answers by deviji2000 Questions by deviji2000

• Oct 16th, 2007

procedures and function hv many benefits in addition to modularizing application development.1)          easy maintenance  :  sub programs are lo...

Answer Question  Select Best Answer

     a. Stored procedure or anonymous block     b. an application program such a PRC *C, PRO* COBOL     c. SQL *PLUS      a. PACKAGE NAME.PROCEDURE NAME (parameters);        variable := PACKAGE NAME.FUNCTION NAME (arguments);        EXEC SQL EXECUTE    ...

shi_fu

 Profile Answers by shi_fu Questions by shi_fu

• Nov 30th, 2010

a. procedure is called by its name:pack_name.proc_name;function is called from a expression:a=b*(function(param));b.(same as above)procedure is called by its name:pack_name.proc_name;function is calle...

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 17th, 2008

a. PACKAGE NAME.PROCEDURE NAME (parameters);     variable := PACKAGE NAME.FUNCTION NAME (arguments);        b.     ...

Answer Question  Select Best Answer

Baji Shaik

 Profile Answers by Baji Shaik Questions by Baji Shaik

• Jun 5th, 2011

Strong ref cursor return value, but seek ref cursor it can't return any value

askvenki

 Profile Answers by askvenki Questions by askvenki

• Jul 20th, 2007

           A strong REF CURSOR type definition specifies a return type, but a weak definition does not.DECLARE   TYPE EmpCurTyp IS REF ...

Answer Question  Select Best Answer

Art11

 Profile Answers by Art11 Questions by Art11

• Sep 27th, 2011

A REF Cursor is a datatype that holds a cursor value in the same way that a VARCHAR2 variable will hold a string value. It is not a cursor, but a variable that points to a cursor. It is not limited t...

sunil

• Jul 26th, 2011

CURSOR A cursor is a variable that runs through the tuples of some relation. This relation can be a stored table, or it can be the answer to some query. A cursor can be used in realtime when u nee...

Answer Question  Select Best Answer

Guest

• Jan 16th, 2007

A forward declaration looks like the package definition part but is inside the bode.e.g.procedure A isbegin  B;end A;procedure B isbegin  null;end B;will not work, because during call to B B...

Donald H. Kirschman

• Dec 27th, 2006

Scalar data types store one single element of data, as opposed to composite data types.  This is not a concept that is unique to Oracle PL/SQL; rather, it is common to any programming language.&n...

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 1st, 2008

Cursor variables are like C or Pascal pointers, which hold the memory location (address) of some item instead of the item itself. Thus, declaring a cursor variable creates a pointer, not an item. In P...

nisha

• Aug 24th, 2006

ref cursor is a simple cursor but it is a datatype that allow developers to declare cursor variableref cursor has 2 types:-strong ref cursor where we mention the return type with rowtype.weak cursor w...

Answer Question  Select Best Answer

lieni

• Jul 30th, 2007

Yes you can pass the whole select statement of the cursor dynamicaly, see ref_cursors.There is also a system package sys.dbms_sql which allows everything to make dynamically.

CHINMAY

• Jun 28th, 2007

Yes,You are right we can only pass the value for where clause in paramterised cursor

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

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 3rd, 2008

You can use either of them . Both are same.

amahanit

 Profile Answers by amahanit Questions by amahanit

• Oct 13th, 2007

Both are same

Answer Question  Select Best Answer

Ashwini

• Dec 23rd, 2006

Cursor Variable RestrictionsCursor variables are subject to the following restrictions; Oracle may remove some of these in future releases. Cursor variables cannot be declared in a package since they ...

rashid

• Sep 20th, 2006

hi friend cursor variable can't use with dynamic sql.cursor variable can't use with in package because it is not having persistent state.nulls can't assinged to cursor variable.remote procedure can't accept cursor variable

Answer Question  Select Best Answer

gkbiswal

 Profile Answers by gkbiswal Questions by gkbiswal

• Oct 21st, 2007

It(autonomous transaction) will work but it'll not satisfy your business requirement. Mutating error is not actually an error but Oracle has provided this feauture to do away with any si...

trupti

• Feb 13th, 2007

Hi, you can use pragma autonomous_transaction for mutating trigger ie after declare, the first statement is pragma autonomous_transaction.
try it,
it really works!!

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 19th, 2008

Triggers on system events can be defined at the database or schema level. A trigger defined at the database level fires for all users, and A trigger defined at the schema or table level fires only when the triggering event involves that schema or table.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 5th, 2006

In database trigger:  Trigger for a table /view  is a database triggerlike ( before , insert  * update, delete, insert * row level, statement level)2 * 3 * 2 = 12  + instead off tr...

Answer Question  Select Best Answer

kool.bird9

 Profile Answers by kool.bird9 Questions by kool.bird9

• Jul 9th, 2011

Oracle ROWID uniquely identifies where a row resides on disk.  The information in a ROWID gives Oracle everything it needs to find your row, the disk number, the cylinder, block and offset ...

RajivPrasad

 Profile Answers by RajivPrasad Questions by RajivPrasad

• May 8th, 2007

Also as mentioned by our friend rowid is a unique hexadecimal format integer which takes up the representation as below      File: Block: Row One can retrieve rowid by using t...

Answer Question  Select Best Answer

What is Global temporary table? and what are the benefits of it?

Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Oct 24th, 2017

Global Temporary Table(GTT): --------------------------------------- --> GTT operation perform in-memory(RAM) so reading data from GTT is a "Logical Read" -> hence its faster. --> GTT are of 2 type...

vanishavadlya

 Profile Answers by vanishavadlya Questions by vanishavadlya

• Oct 24th, 2009

The data in a global temporary table is private, such that data inserted by a session can only be accessed by that session. The session-specific rows in a global temporary table can be preserved for t...

Answer Question  Select Best Answer