praveen.pinisetti

 Profile Answers by praveen.pinisetti Questions by praveen.pinisetti

• Apr 6th, 2006

After compiling procedures,functions and triggers(in new versions only),Those will be stored in the form of p-code(after parsing) in SGA(System Global Area).The advantage of p-code is Since it wa...

Answer Question  Select Best Answer

Navin

• Mar 2nd, 2006

A ref cursor is a type that you can define in the declare section of your PL/SQL program. You can then open this cursor for any SQL statement that you construct dynamically in your program.For your ot...

Answer Question  Select Best Answer

Rajesh Ramanan

• Mar 2nd, 2006

SELECT dbms_rowid.rowid_block_number(rowid)FROM bowie_stuff;SELECT dbms_rowid.rowid_object(rowid)FROM bowie_stuff; 

Answer Question  Select Best Answer

MANI

• May 31st, 2006

send an inout parameter to pl/sql procedure 

Answer Question  Select Best Answer

Guna Sagar Challa

• Mar 27th, 2006

Hi,Use the V$OPEN_CURSOR view to know how many cursors are currently open in the database.Guna Sagar Challa 

Answer Question  Select Best Answer

SADANAND

• Apr 14th, 2006

First create a Trigger and with Procedure you insert records.The :new will take the new values.So use Triggers in Procedures.

Answer Question  Select Best Answer

manoj bajaj

• Apr 25th, 2006

Yes we can relate two tables from 2 diff usersE.g. if user A has table Ta  and User B has Table Tb  and Table Tb is child table and needs foreign key on A.Ta  then we need to grant "references" object privillege to User B on table Ta.1

Answer Question  Select Best Answer

Murali Krishna

• Jun 4th, 2006

hi ,U can use the PRAGMA Function.I.e Autonomous Function to come back to normal stage in Mutating table.

Answer Question  Select Best Answer

Gupta

• Aug 7th, 2006

A table function is a function that returns an entire set of rows, and can be queried directly from the within a SQL statement, as if it were true database table. Whereas pipeline function is similar,...

Answer Question  Select Best Answer

praveen

• Jul 3rd, 2006

Hi all,let first conver it into to_date and thenm to_char and then concate with .23.59.59.999999this way to_char(to_date('column name','ccyymmd') ,'ccyy-mm-dd')||.28.59.59.9999999try for thisregardspraveen

Answer Question  Select Best Answer

Lingaraj RH

• Jul 12th, 2006

Internally the Oracle database supports two procedural languages, namely PL/SQL and Java. This leads to questions like "Which of the two is the best?" and "Will Oracle ever desupport PL/SQL in favour ...

Answer Question  Select Best Answer

Yerra Rama Krishna,TCS

• Aug 9th, 2006

Hi Friend!         If you deal with better performance You have to refer REF CURSOR and its more advantage and effecient of Exeqution.Thanks&RegdsRamki

Answer Question  Select Best Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Oct 20th, 2006

You should put your question here.  This forum is not a library.  Please take care.

Answer Question  Select Best Answer

youranjani

 Profile Answers by youranjani Questions by youranjani

• Oct 26th, 2006

Hi.. We can change the elements of listitems at runtime with the help of Record Group

Answer Question  Select Best Answer

Please explain How to set locktime out in Oracle.

NareshAB

 Profile Answers by NareshAB Questions by NareshAB

• Apr 24th, 2011

Set Lock_Timeout Time (in ms)Thanks

Answer Question  Select Best Answer

Which exception is used in UTL_FILE package in PL/SQL?

dinesh.smhdr

 Profile Answers by dinesh.smhdr Questions by dinesh.smhdr

• May 19th, 2011

The package specification of UTL_FILE defines seven exceptions.INVALID_PATHINVALID_MODEINVALID_FILEHANDLEINVALID_OPERATIONREAD_ERRORWRITE_ERRORINTERNAL_ERRORNO_DATA_FOUNDVALUE_ERRORINVALID_MAXLINESIZE

Answer Question  Select Best Answer

Innila

 Profile Answers by Innila Questions by Innila

• Mar 2nd, 2007

LOB datatypes can be used to store blocks of unstructured data like graphic images, video, audio, etc

Answer Question  Select Best Answer

ajeeteng

 Profile Answers by ajeeteng Questions by ajeeteng

• May 5th, 2010

The DBMS_TTS package checks if the transportable set is self-contained. TRANSPORT_SET_CHECK Procedure This procedure checks if a set of tablespaces (to be transported) is self-contained. After calling this procedure, the user may select from a view to see a list of violations, if there are any.

Answer Question  Select Best Answer

Kamal Mohapatra

• Jul 23rd, 2007

You must be speaking about PLS_INTEGER.? PLS_INTEGER, uses machine-arithmetic unlike BINARY_INTEGER which uses library arithmetic. As such PLS_INTEGER is somewhat faster than BINARY_INTEGER. Also BINARY_INTEGER has subtypes. I don't think PLS_INTEGER has subtypes

Answer Question  Select Best Answer

RoulRaj

• May 11th, 2007

There should be atleast one statement in between Begin and End.The Statement may be Null statement also.Syntax:declarebeginnull;end;RegardsR.K.Roul

Answer Question  Select Best Answer