when others then *ERROR at line 6:ORA-06550: line 6, column 2:PLS-00370: OTHERS handler must be last among the exception handlers of a blockORA-06550: line 0, column 0:PL/SQL: Compilation unit analysis terminated

kiran_marla

 Profile Answers by kiran_marla Questions by kiran_marla

• Jul 7th, 2010

Error occurs, why because "when others" must and should be placed at last in exception block

neerajalatha

 Profile Answers by neerajalatha Questions by neerajalatha

• Jul 5th, 2010

when others then*ERROR at line 6:ORA-06550: line 6, column 2:PLS-00370: OTHERS handler must be last among the exception handlers of a blockORA-06550: line 0, column 0:PL/SQL: Compilation unit analysis terminatedThis is right answer

Answer Question  Select Best Answer

rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Aug 12th, 2008

CREATE OR REPLACE TRIGGER SHOW_BEFORE_DMLBEFORE INSERT OR DELETE OR UPDATE ON SERVICE_ORDER_STATUS? --(TABLE NAME)FOR EACH ROW BEGIN?DBMS_OUTPUT.PUT_LINE('NON-UPDATABLE TABLE');?ROLLBACK;END;ThanksRajiv GuptaYogik Technologies Pvt. Ltd.

SonuYadav

 Profile Answers by SonuYadav Questions by SonuYadav

• Aug 11th, 2008

You can user sql%rowcount to check whether the dml does something or notegbegindelete from tbl_xxxwhere col_yyy = 'ASDF';dbms_output.put_line (sql%rowcount);end;this way it will return the no of rows deleted

Answer Question  Select Best Answer

muraligrandhi

 Profile Answers by muraligrandhi Questions by muraligrandhi

• Jun 23rd, 2011

A forward declaration means that modules (procedures and functions) are declared in advance of their actual body definition. For example, if program A calls program B and program B calls program A,&nb...

KD09714

 Profile Answers by KD09714 Questions by KD09714

• Jun 26th, 2008

Example of forward declaration in package : CREATE OR REPLACE PACKAGE pkg_CBRef_Seq AS PROCEDURE sp_CBRCreateDropSeq_scd ( p_cod_CountryCode IN country.country_code%TYPE, ...

Answer Question  Select Best Answer

utham

• Sep 4th, 2007

Identity is a?SQL Server concept The better way to do is use the alter command

Sandip Bhattacharjee

• May 12th, 2007

SQL> ALTER TABLE EMP ADD SR_NO INT IDENTITY(1,1) 2 ;ALTER TABLE EMP ADD SR_NO INT IDENTITY(1,1)*ERROR at line 1:ORA-01735: invalid ALTER TABLE optionThe above commands is not working. Pls specity what do you mean by identity(1,1)

Answer Question  Select Best Answer

sankar

• Nov 14th, 2007

We have prdefined table 'col'. from this table we can find the column names dynamically. For ex. select cname from col where col=1 and tname='emp' then you will get first clomun name of emp table...

Naresh Dantu

• Nov 13th, 2006

You Can. Below is the example.DECLARECURSOR cr_dataISSELECT ROWID, a.*FROM fnd_user a where rownum < 10;l_table_name VARCHAR2(2000) := 'FND_USER';-- IMP--This table name should be same as your from...

Answer Question  Select Best Answer

SURESHMALLIPEDDI

 Profile Answers by SURESHMALLIPEDDI Questions by SURESHMALLIPEDDI

• Aug 9th, 2011

Select '('||substr(phone,1,3)||')'||substr(phone,4) "formated phone number",phone from phone

paresh Borad

• Aug 1st, 2011

Use this query

create table newphone as (select '(' || substr(phnumber, 1,3) || ')' || substr(phnumber,4,10) "phonenumber" from oldphone)

Answer Question  Select Best Answer

PraGop

 Profile Answers by PraGop Questions by PraGop

• Jul 21st, 2008

Can u please give more explanation on this NOCOPY parameter

raghav_sy

 Profile Answers by raghav_sy Questions by raghav_sy

• Jan 15th, 2007

hi one more thing i wan to add abt NOCOPY, it is that its a hint to compiler, so its compiler wish whether to follow this thing or not, so before using this just go through the conditions when this th...

Answer Question  Select Best Answer

Suresh kumar patra

• Sep 10th, 2013

SQL>ed

Then Window Will Open,You Can Change Your Code.

Vinod Tuteja

• Jun 18th, 2013

Simply Write

SQL>ed

Then Window Will Open,You Can Change Your Code .

Answer Question  Select Best Answer

Nikhil_4_Oracle

• Mar 12th, 2007

Hey,Above?Soln is not working with tables where data is like,COL1?----------1511 *708111 *5511 *78--Here 11 Repeats 3 times fine...--Check d rowidselect rowid,col1 from nodup;ROWID?????????...

suni123

 Profile Answers by suni123 Questions by suni123

• Mar 5th, 2007

Hi,To delete duplicate rows from table EMPDELETE FROM EMP WHERE ROWID NOT IN                   (SELECT MAX(ROW...

Answer Question  Select Best Answer

rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Aug 12th, 2008

By using SQL LOAER, TOAD we can insert?EXCEL file data into respective Table & we can also create or upload ORACLE table data to?.xls file from that.ThanksRajiv GuptaYogik Technologies Pvt. Ltd.

rudhra97

 Profile Answers by rudhra97 Questions by rudhra97

• Jul 25th, 2008

By using sql*loader tool,we can convert flat files into oracle tables

Answer Question  Select Best Answer

What is the difference between an explicit cursor and select into statement?

neerajalatha

 Profile Answers by neerajalatha Questions by neerajalatha

• Jul 5th, 2010

Select statement can return multiples rows at a time and there exists only one network round trip.Explicit cursors are memory areas which acts as a handle or pointer to context area and allows to fetc...

rashlikesu

 Profile Answers by rashlikesu Questions by rashlikesu

• May 12th, 2010

When select into query returns just one row, Oracle uses implicit cursor to execute and fetch the results for the query.But if the select statement returns more than one row, an Explicit cursor is created to fetch the data.

Answer Question  Select Best Answer

If a procedure is referring a table and if the structure of the table is changed, lets say data type of the any column is changed, then is it possible that the status of the procedure remains valid? Explain

Read Best Answer

Editorial / Best Answer

tar.goyal  

 Profile Answers by tar.goyal Questions by tar.goyal

• Member Since Aug-2010 | Aug 4th, 2010

---

It is possible that a procedure remain valid even when the data type of columns of a table on which it is operating change.

This can be achieved by using Anchor declaration i.e. %TYPE and %ROWTYPE while defining reference to such table columns and rows respectively in the procedure.

tar.goyal

 Profile Answers by tar.goyal Questions by tar.goyal

• Aug 4th, 2010

It is possible that a procedure remain valid even when the data type of columns of a table on which it is operating change.This can be achieved by using Anchor declaration i.e. %TYPE and %ROWTYPE while defining reference to such table columns and rows respectively in the procedure.

anironic

 Profile Answers by anironic Questions by anironic

• Jul 21st, 2010

If PL/SQL stored SP %type and does not explicity declare a datatype, then it is quite possible that Stored procedure remains valid, even after changing the datatype in the table. Ex, you have a declar...

Improve Answer

1. How to load excel data into oracle database by using sql loader?
2. What are the ways to load data from excel file in oracle database ?

Naresh Bandla

• Dec 1st, 2015

You can upload the Excel file into tables by many approaches, I will explain here in two methods. 1. Loading data using Loader programs: Convert your excel file into CSV file and create control as pe...

ashay

• Nov 13th, 2015

Best and most easy way is to use an external table. Keep the file in designated location and file will automatically loaded into table every time you put a new file or update the file. Create trigger on the given table to load the data into respective tables.

Answer Question  Select Best Answer

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 7th, 2008

A warning or error condition is called an exception. An exception may raise in a pl/sql block due to designing faults, coding mistakes or hardware failure. If an exception raises in a block ...

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Jan 31st, 2008

You can handle exception in two ways:– Trap it with a handler : If the exception is raised in the executable section of the block, processing branches to the corresponding exception handler...

Answer Question  Select Best Answer

mohan

• Apr 9th, 2007

CREATE OR REPLACE TRIGGER t_trigger AFTER INSERT ON t1 FOR EACH ROW DECLARE   PRAGMA AUTONOMOUS_TRANSACTION;  i PLS_INTEGER; BEGIN   SELECT COU...

mohan kumar

• Apr 9th, 2007

Yes We can use commit statement in triggers with 10G.Here is example :CREATE OR REPLACE TRIGGER t_trigger AFTER INSERT ON t1 FOR EACH ROW DECLARE   PRAGMA AUTONOMOUS_TRANSA...

Answer Question  Select Best Answer

jabir.mkk

 Profile Answers by jabir.mkk Questions by jabir.mkk

• Oct 16th, 2009

The maximum parsed/compiled size of a PL/SQL block is 64K and the maximum code size is 100K. You can run the following select statement to query the size of an existing package or procedure. SQL> select * from dba_object_size where name = 'procedure_name'

malik.aman

 Profile Answers by malik.aman Questions by malik.aman

• Dec 1st, 2007

Select * from dba_object_size where name = 'procedure_name';

Answer Question  Select Best Answer

deepakonroll

 Profile Answers by deepakonroll Questions by deepakonroll

• Dec 7th, 2007

DECLARECURSOR CUR_TABLES ISSELECT table_name from user_tables;V_TABLE NUMBER(5);v_table_name varchar2(100);BEGINFOR I IN CUR_TABLESLOOPSELECT COUNT(1)INTO V_TABLEFROM (SELECT table_name from user_tabl...

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 21st, 2007

Hi all plz understand the question.........Hi Ramki try this!SELECT COUNT (COLUMN_NAME) FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'TABLENAME';FOR example;SQL> SELECT COUNT(COLUMN_NAME) FROM ...

Answer Question  Select Best Answer

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 8th, 2008

Please remove the commit from the begin statement and the it will execute properly.Thanks,

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 8th, 2008

DeclareCursor c1 is select * from emp FORUPDATE;Z c1%rowtype;BeginOpen C1;Fetch c1 into Z;Commit;Fetch c1 in to Z;end; SQL> start e1 Declare * ERROR at line 1: ORA-01002: fetch out of sequence...

Answer Question  Select Best Answer

psiva_oracle

 Profile Answers by psiva_oracle Questions by psiva_oracle

• Feb 12th, 2008

Hi,Database Server:It's contains the collection of objects (Table,procedure,trigger,sequence,index,etc)it's also contains the Schema and user detailswe can view the details which are in t...

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 4th, 2008

Database Server: A computer in a LAN dedicated to database storage and retrieval. The database server is a key component in a client/server environment. It holds the database management system (DBMS) ...

Answer Question  Select Best Answer

We can create a column with' not null+unique' with out using primary key

PRADEEP

• Oct 17th, 2012

Primary key: set of columns is uniquely identified a rows of a table. It does not allow both nulls and duplicate values. If we use null values it will allow duplicate values but it does not allow n...

Radha

• Jul 14th, 2011

We can create NOTNULL and UNIQUE constraints on single column. Which indirectly means a Primary Key. But only a Primary Key column can be used as Foreign key column. Primary key provides a default...

Answer Question  Select Best Answer