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

       FUNCTION name (argument list .....) Return datatype is     local variable declarations     Begin          executable statements     Exception          execution handlers     End;

bavani

• Oct 23rd, 2006

create or replace function function_name(formal parameters list with only IN mode) return datatypeislocal variable declarationsbegin executable statments; return value;end function_name;

Answer Question  Select Best Answer

kamala kanta Parhi

• Oct 14th, 2006

select text from user_sourcewhere name='procedure_name';

D. Madhu

• Jun 29th, 2006

select * from user_objects where type='procedure' and name='function or procedure name'

Answer Question  Select Best Answer

rashid

• Sep 20th, 2006

define is use for predefine variable its depends on user. You can use char or number

Sachin

• Sep 5th, 2006

CHAR

Answer Question  Select Best Answer

developer

• Sep 14th, 2006

Hi,for example u have a sequence called s1 and table as student theninsert into student values(s1.nextval,field1,field2, ....);that's all

Divesh

• Apr 23rd, 2006

U can directly use insert into < table_name> select .currval/nextval from dual.Please free to contact me if any queries on dibansal@cisco.com

Answer Question  Select Best Answer

dineshchaini

 Profile Answers by dineshchaini Questions by dineshchaini

• Sep 9th, 2006

Dear Maria...   I traied with the DBA previlage but... again the same prob.. proc created but table is not thea... ok I tried u r proc and mail back to you...

tdas2004

 Profile Answers by tdas2004 Questions by tdas2004

• Sep 7th, 2006

You are right Maria Antony, but the question is, why is it not possible to create the table thru the procedure while you can create the sametable using create table SQL command.The answer is, to creat...

Answer Question  Select Best Answer

Sheetal

• Aug 24th, 2006

Hi,Your program will delete all rows from the table. If you print output after fetch from the cursor it will show all rows those where selected in the cursors.When the cursor was created u select...

Rama Krishna,Y

• Aug 21st, 2006

Hi Friend!! If you want to use the entire tale data from table in PL/SQL programing block,you have to store the entire data in a temp buffer variable .. to syntronize that operation Oracle supports...

Answer Question  Select Best Answer

mariashylaja

 Profile Answers by mariashylaja Questions by mariashylaja

• Aug 12th, 2006

During bulk collect you can save the exception and then you can process the exception.Look at the below given example:DECLARE TYPE NumList IS TABLE OF NUMBER; num_tab NumList := NumList(10,0,11,1...

mariashylaja

 Profile Answers by mariashylaja Questions by mariashylaja

• Aug 12th, 2006

DECLARE TYPE NumList IS TABLE OF NUMBER; num_tab NumList := NumList(10,0,11,12,30,0,20,199,2,0,9,1); errors NUMBER;BEGIN FORALL i IN num_tab.FIRST..num_tab.LAST SAVE EXCEPTIONS DELETE *...

Answer Question  Select Best Answer

Rama Krishna

• Aug 12th, 2006

Its Binary IntegerRamki,TCS,HYD9989018508

parleg

• Jul 16th, 2006

Is it number or binary integer?

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

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

D. Madhusudhana Rao ( 9885626575)

• Aug 1st, 2006

Its depend upon the query. If the two queries are firing on the table it is not possible. If the queries are firing on different different tables then it is possible.Thanks & RegardsMadhu D.

Manoj Kumar Verma

• Aug 1st, 2006

As Distributed database system based on 2 phase commit,one query is independent of 2 nd query so of course we can run.manoj

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

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

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

MANI

• May 31st, 2006

send an inout parameter to pl/sql procedure 

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

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

Data Concarency => Means that many users can access data at the same time.Data Consistency => Means that each user sees a consistent view of the data, including visible changes made by the user's own transactions and transactions of other users.

arvind kumar

• Apr 12th, 2006

types of triggers

tm1966_muthu

 Profile Answers by tm1966_muthu Questions by tm1966_muthu

• Feb 17th, 2006

ConcurrencyHow well can multiple sessions access the same data simultaneously ConsistencyHow consistent is the view of the data between and within multiple sessions, transactions or statements

Answer Question  Select Best Answer

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