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

Not known yet

ankurlibra

 Profile Answers by ankurlibra Questions by ankurlibra

• Sep 26th, 2010

We are misunderstanding the question and I assume that Abhishek want to say that "How we can hide a table info from user?".To hide table info or as per question make it invisible to other user. A tabl...

pravelu

 Profile Answers by pravelu Questions by pravelu

• Apr 23rd, 2010

It can be done using role grants. Grant view or debug privileges to only the set of users who can see these tables. The other users who are not granted the privilege cannot view this table. Every single user is a Schema in Oracle.It is by default, that the table cannot be seen by others.

Answer Question  Select Best Answer

Sahaja Mallarapu

• Aug 26th, 2011

A Ref Cursor is a variable that points to cursor.A ref cursor allows you to store the result of a "bulk collect" from a table (or any PL/SQL cursor return set) into a PL/SQL table and then reference ...

Sadashiv

• Aug 8th, 2011

REF Cursor OR Dynamic Cursors: Query associated with cursor is not known at the time of compilation. The select statement associated with cursor is changing at the time of running the program Syntax...

Answer Question  Select Best Answer

priya dharan raj

 Profile Answers by priya dharan raj Questions by priya dharan raj

• Nov 14th, 2011

Code
 

Nitesh Srivastava TechM

• Nov 10th, 2011

See the code below

Code
span style="color: #ff0000;">'EMP''EMP'

Answer Question  Select Best Answer

aak

• Sep 15th, 2016

No, You can add the proc in body and not declare it in the spec.. this is ok as it would mean that that proc is a private procedure but visa versa is not possible. It would give compilation error.

Sudhanshu

• Jul 26th, 2016

"oracle8 Create or replace package Test_pkg as 2 procedure Proc1; 3 end; 4 / Package created create or replace package body Test_pkg as 2 3 procedure proc1 is...

Answer Question  Select Best Answer

vnraos

 Profile Answers by vnraos Questions by vnraos

• Sep 5th, 2008

First, let us understand why these errors cropup.1) NO_DATA_FOUND - is raised only for "select into" statements when? the where clause of the query does not match any rows.2)TOO_MANY_rows - is raised...

binurajnair

 Profile Answers by binurajnair Questions by binurajnair

• Jul 30th, 2008

If you don't want an excpetion to be raised on a SELECT statement, you can avoid executing the statement by having a count just before the SELECT as shown belowSELECT count(rowid)into v_count from...

Answer Question  Select Best Answer

sandeshshinde000

 Profile Answers by sandeshshinde000 Questions by sandeshshinde000

• Jun 4th, 2011

begin  DML 1  '  '  '  '  '  DML 10exceptionwhen others thandbms_output('error at location '||dbms_utility.format_error_backtrace);e...

BakulPatel

 Profile Answers by BakulPatel Questions by BakulPatel

• May 7th, 2011

To simplify  Remove exception block. Oracle will show line number with error thrownOther method:beginlocation :=1; dml1 location :=2; dml2exception    when others than&nb...

Answer Question  Select Best Answer

RAVI KUMAR BURRI

• Jan 19th, 2020

SET AUTOTRACE ON EXPLAIN

machomanic

 Profile Answers by machomanic Questions by machomanic

• Jul 8th, 2010

You can use the command SQL> SET TIMING ON;This will show how much time your query took for the execution.

Answer Question  Select Best Answer

pankti

• Apr 6th, 2012

Nested table Unbounded ...

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 6th, 2008

A Table is a basic unit of storage in oracle.A nested table is a collection type. The main advantage of collections is instead of processing data sequentially, we may process all the date&nb...

Answer Question  Select Best Answer

How to delete duplicate Keys through PL-SQL in single query.

anonymous

• Sep 27th, 2011

Code
 

Art11

 Profile Answers by Art11 Questions by Art11

• Sep 21st, 2011

Assuming that ename and job is the same or First and Last name...

SELECT * FROM (SELECT empno, ename, job ,RANK() OVER (PARTITION BY ename, job ORDER BY empno) AS SeqNo FROM emp1) WHERE SeqNo > 1

Answer Question  Select Best Answer