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

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

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

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

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

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

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

       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

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

prakash

• Nov 15th, 2006

Hi,        I would suggest not to pass all the records to you next procedure. You should look to redesign your next procedure so that it accepts one record and proce...

prasanna

• Nov 14th, 2006

hi friend       of course no need of sending 2lakh records but some records whatever i required

Answer Question  Select Best Answer

Raghavendra

• Nov 19th, 2006

Alter table disable all trigger;

Brijesh Mishra

• Oct 9th, 2006

SQL> Spool c:tempdisable_all_triggerSQL> Select 'ALTER TRIGGER '|| trigger_name ||' disable;' from user_triggers;SQL> spool offafter that open file disable_all_trigger.lst and remove header part and save file.SQL>@c:tempdisable_all_trigger.lst

Answer Question  Select Best Answer

Pawan Ahuja

• Dec 3rd, 2006

 In forms eigth types of trigger.1) Block_Processing Triggers, 2) Interface event triggers, 3) master/Detail Triggers, 4) navigational Triggers, 5) Query_time triggers, 6) Transactional Triggers ...

Anusha

• Nov 23rd, 2006

1) Block_Processing Triggers, 2) Interface event triggers, 3) master/Detail Triggers, 4) navigational Triggers, 5) Query_time triggers, 6) Transactional Triggers 7) Validational Triggers 8) Message_handling Triggers 9)When_New_Instance Triggers

Answer Question  Select Best Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 9th, 2006

create table new_employeesas (select e.employee_id, e.first_name, e.last_name, d.department_name, d.department_id,c.location_id, c.city from employees e, departments d, locations cwhere e.department_id = d.department_idand d.location_id = c.location_id);

Shree

• Oct 12th, 2006

Create table table_name as( select tab1.column1,tab1.column2,tab2.column3 from table_name tab1,table_name2 tab2 where tab1.colum1=tab2.column4);

Answer Question  Select Best Answer

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Dec 12th, 2006

There is no "update cascade" functionality in oracle. But you can develop your own code to achieve this. The source code is also available in this urlhttp://asktom.oracle.com/tkyte/update_cascade/index.html

Answer Question  Select Best Answer

Guest

• Dec 12th, 2006

Actually your question is not clear. Do u want to change column name or values in the column?to change a values it is quite simple.select replace('replace_underscores_with_spaces','_',' ') from dual;

Gupteshwar

• Dec 9th, 2006

You can use REPLACE function in order to replace a digit or character in a column.SELECT REPLACE(col1, '_', ' ') FROM table_1.This function can also be used to update column's records.Try this function. Hope it would work.

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

Manikandan

• Dec 24th, 2006

Use execute immediate to write DDL statements.but you should have create  system previlege on the schema.

Answer Question  Select Best Answer

gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Jan 5th, 2007

Hi,  It is very good query u asked.The work around is, it is not advisable to use a COMMIT inside the loop as it invalidates the cursor which is declared for update.If u want to use commit then d...

Answer Question  Select Best Answer

gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Jan 6th, 2007

hi,  when u do so the view gets error and synonym becomes invalid. If u create a table again with same name but with different cols the synonym will work but view wont.bcz view is the stored...

raghgu

• Nov 16th, 2006

Hi friend, As per RDBMS rule we cannot have invalid synoym, but we can have a invalid view.

Answer Question  Select Best Answer

gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Jan 6th, 2007

Hi,  write a control file to dump the data from file to table using SQL*LOADER or use UTL_FILE to do the same.

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Dec 12th, 2006

Use "sql loader" to limport flat file data to database tables.

Answer Question  Select Best Answer