Ravindra Reddy

• Sep 5th, 2007

The PL/SQL Blocks are 2 types1. Ananymous Block2. Named Block1. Ananymous Block means with out any name.Ex:- Declare<variables>Begin<Exec Statmts>ExceptionEnd.2. Names Block are ...

Sanjay Bharti

• Jun 13th, 2007

Hi All,I am new to this community. It seems the question is related to Begin End block of PL/SQL. See if you do not want to write any procedure and you want to do some sequence of operation that inclu...

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

archie123

• Aug 28th, 2007

Yes you can use commit or rollback in exception block;select * from test123;A----------51 Declare s varchar2(2); Begin update test123 set a = a+10; select a into s from test123 where a=20; exception...

Answer Question  Select Best Answer

jiten

• Aug 27th, 2007

%type will use for to define at column level.%rowtype is used to define for one or more than one columns ( like row or record or tuple?) means its user define type which hold one or more than one columns along with it. and generally it used?with Cursor.

srikanthvijay8

• Jul 2nd, 2007

If you use a cursor, you can return cursor values only by rowtype only.

Answer Question  Select Best Answer

 DECLARE  CURSOR  cursor  name,  OPEN  cursor  name,  FETCH cursor name INTO  or Record types, CLOSE cursor name.

fancyoracle

• Aug 15th, 2007

There are two ways of processing a cursor output. These mainly depend on the type of cursor used. Cursors can be1) Static      : Declared in declarations section with a defina...

geetha24

 Profile Answers by geetha24 Questions by geetha24

• Feb 13th, 2007

FOR record_index IN [cursor_name | (SELECT statement)]LOOP executable_statement(s)END LOOP;

Answer Question  Select Best Answer

askvenki

 Profile Answers by askvenki Questions by askvenki

• Aug 13th, 2007

By using cursor parameters we can pass the value dynamically. So that cursor can fetch data as per parameter

gopal

• Jan 11th, 2006

Dear sir,      declare       dep_num number;         cursor c(x number) is select * from emp where deptno...

Answer Question  Select Best Answer

lieni

• Jul 30th, 2007

You add the psedocolumn rowid to the selected fields of the cursors body.This rowid identifies the selected record uniquely so that you can update with it, like with the primary key (just faster).Update tab where rowid=cur_rec.rowid;

nagurtilak

• Mar 15th, 2007

It can be used in cursorsIf we want to update the current record (i.e cursor holding the current? record) we can use WHERE CURRENT clauseEg. UPDATE empSET sal=sal*10FROM emp WHERE CURRENT of "cursor name"

Answer Question  Select Best Answer

lieni

• Jul 30th, 2007

Yes you can pass the whole select statement of the cursor dynamicaly, see ref_cursors.There is also a system package sys.dbms_sql which allows everything to make dynamically.

CHINMAY

• Jun 28th, 2007

Yes,You are right we can only pass the value for where clause in paramterised cursor

Answer Question  Select Best Answer

rsundararajan_in

• Jul 30th, 2007

By using wrapper class pl sql code can be protected.

Answer Question  Select Best Answer

Srinivasa Bhargava

• Jul 27th, 2007

You have to index the columns properly and make sure that driving columns of the composite indexes are used in the query .You may as well wish to rebuild indexes as the number of records is increased.

Syed Jawahar

• May 31st, 2006

HIYOU CAN SPEED UP THE QUERY BY USING THE ROWID IN THE SELECT STATEMENT.

Answer Question  Select Best Answer

Kamal Mohapatra

• Jul 23rd, 2007

You must be speaking about PLS_INTEGER.? PLS_INTEGER, uses machine-arithmetic unlike BINARY_INTEGER which uses library arithmetic. As such PLS_INTEGER is somewhat faster than BINARY_INTEGER. Also BINARY_INTEGER has subtypes. I don't think PLS_INTEGER has subtypes

Answer Question  Select Best Answer

askvenki

 Profile Answers by askvenki Questions by askvenki

• Jul 20th, 2007

rowchaining works for varchar2 datatype which will allocate memory dynamicallysuppose thier is column name varchar2(20);first value-- venki which is 5changed to venki12? which is 7then? oracle will cr...

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Oct 13th, 2006

Hi Shashank,Can you explain instead off trigger, DML Trigger and views..

Answer Question  Select Best Answer

askvenki

 Profile Answers by askvenki Questions by askvenki

• Jul 19th, 2007

The force view can be created before base table is created .when the table is createdit is automatically activated.we can create base table with any structure

Mohamed Irfan

• Dec 26th, 2006

Hi,    Force views are created in real time environment as per the business needs because of two specific reasons1. If the structure of the base table is not completely known (ie) ...

Answer Question  Select Best Answer

vinit

• Jul 12th, 2007

tkproof is a oracle utility. it gives information  about following parameters.********************************************************************************count    = number of t...

madhug56

 Profile Answers by madhug56 Questions by madhug56

• Jun 12th, 2007

Can you tell me something more about tk proof?? I mean how do we give input and what is the output?

Answer Question  Select Best Answer

chakraborty_sarkar

 Profile Answers by chakraborty_sarkar Questions by chakraborty_sarkar

• Jul 10th, 2007

SELECT LEV FROM (SELECT LEVEL LEV FROM dual CONNECT BY LEVEL < 10) WHERE LEV NOT IN (SELECT COLUMN1 FROM TEMP);

Amit

• Jun 14th, 2007

If I have Emp Table and id column
1
2
4
5
7
SELECT 10-id FROM Emp WHERE id in (SELECT id FROM Emp WHERE id 5)

Answer Question  Select Best Answer

 Mutation of table occurs.

rudra pratap

• Jul 5th, 2007

In order to avoid mutation table error we need to have a row level as well as a statment level trigger.

Sunil Yadav

• Oct 26th, 2005

To avoid the mutation table error ,the procedure should be declared as an AUTONOMOUS TRANSACTION.By this the procedure will be treated as an separate identity.

Answer Question  Select Best Answer

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Jul 5th, 2007

You can use SYSDATE oracle.lv_today := sysdate;or select sysdate into lv_today from dual;both the statements assign sysdate to lv_today

Answer Question  Select Best Answer

Meera

• Jul 4th, 2007

The internal table is a table which is getting filled during the run time of the program...and after that there wont exist any value in that internal table whereas table is the one which contains data permanently

Answer Question  Select Best Answer

visitor

• Jul 4th, 2007

If you do not want any executable statement within the begin-end block, you can include a null statment.eg:begin     null;end;

Chiranjit Dutta

• Feb 27th, 2007

We cant havedeclarebeginendwe must have something between the begin and the end keywordsotherwise a compilation error will be raised.

Answer Question  Select Best Answer

Chinmay

• Jun 28th, 2007

Yes,you can do by using like with orlike select * from tab1where col1 like '%back%' or col2 like '%back%'or col3 like '%back%'or col4 like '%back%'

RoulRaj

• May 11th, 2007

Hello Guna Sagar,

Please give one example i.e without knowing the column name one can write a query.

Regards
Roul

Answer Question  Select Best Answer