1-WHAT IS THE MAX LENGHT OF VARCHAR2 DATATYPE IN PL/SQL?2-WHAT IS THE USE OF UROWID?3-WHAT ARE THE SUBTYPES?GIVE ANY 2 EXAMPLE?4- WHAT IS THE GENERAL STANDARD FOR DECLARATION?

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Dec 27th, 2010

1... max length is 327672 rowid means row plus id actuall its psedocolmn that store the value of each rowwith the help of rowid>>>  we can remove duplicate value>>> we can dispa...

muraligrandhi

 Profile Answers by muraligrandhi Questions by muraligrandhi

• Nov 9th, 2010

1. Maximum length of a varible in PL/SQL is 32767 bytes2. The UROWID or Universal Rowid is useful for storing logical addresses of all the rows of Index-organized tables. It can store both the logical...

Answer Question  Select Best Answer

How do you populate tables or data in Oracle 11g step by step?

Jose George

• Oct 17th, 2012

We can use SQL Loader too

Jose George

• Oct 16th, 2012

Depending on the situation one can use
external tables
or
UTL_FILE package

Answer Question  Select Best Answer

Explain the real-time situation where would you use Oracle Hits

Abhijit Musale

• Mar 23rd, 2015

To override the flow of execution and priority of the execution we can use oracle optimizer hints.(e.g. PARALLEL,APPEND,etc.)

kalpana

• Oct 28th, 2014

Optimizer hints are used with SQL statements to alter execution plans.We are suggesting oracle how the statement should be executed.
syntax : /*+RULE */

Answer Question  Select Best Answer

In the exception part,what will happen if u don’t give (when others) where will it show error compile time or run time

NAND

• Feb 27th, 2012

It will give the error at run time if it is not able to find the type of exception thrown in the current PL/SQL block or the outer block.
It will not throw the compile time error.

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Feb 27th, 2012

Now, to clarify, I am taking the following statement; "in the exception part, what will happen if you don't give the (when others) statement" to mean an exception block with no other when statements a...

Answer Question  Select Best Answer

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