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

For example: I have 100's of tables and I need to take the data from database and export as a xml file.

For each hour, list the number of called, total transactions' values, and total duration?if you have these tables:1- 'calls'columns: called_number, Customer_ID, call_date, call_time_started, Call_time_ended,transaction_no.2- 'tariff'columns: Tarriff_per_Sec, country_code, time_started, time_ended.

User Interface accepts the Employee information and this data needs to be compared with the existing data and the differences needs to be populated through a Pl/SQL table.Create a type (EMP_DATA) to populate the Employee table data.Create a type (ERR_TABLE) with the following attributes:ERR_NO NUMBER,ERR_COLUMN VARCHAR2(50),ERR_RESULT VARCHAR2(500)Create a package USER5_PKG1 with two procedures....