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

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

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

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

rsundararajan_in

• Jul 30th, 2007

By using wrapper class pl sql code can be protected.

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

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

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

 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

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

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

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

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

Ravindra Reddy

• Sep 5th, 2007

Cursor is a private SQL area.. its a temporary buffer used to hold the
transactional data on it n used to manipulate multiple rows through PL/SQL block
statements.
Temporary table can hold the records permanently and we can do DML operations
on this..
ok
Cheers
Rav'i'ndra Reddy

Answer Question  Select Best Answer

dearvandna

• Sep 21st, 2007

Normally use it as sql%type or sql%rowtype. But if you are using a cursor then use it cursorname%type or cursorname%rowtype.

Answer Question  Select Best Answer

dearvandna

• Sep 21st, 2007

No. but maybe associative arrays can help

Answer Question  Select Best Answer

Vaibhav Tyagi

• Sep 25th, 2007

You cannot move existing table into a cluster. You can create new tables though, including tables with the same contents as existing tables. In the second. form, query returns a set of rows which...

Answer Question  Select Best Answer

devi123

• Sep 25th, 2007

Declare the collection variable (varrys or PL/SQL tables)?as out parameter for the procedure and fetch the result set into collection variable.

Answer Question  Select Best Answer

Rushikesh

• Sep 25th, 2007

To be callable from SQL statements, a stored function must obey the following "purity" rules, which are meant to control side effects:1. When called from a SELECT statement or a paralle...

Answer Question  Select Best Answer

vaibhav Tyagi

• Sep 26th, 2007

FOR- Sql ServerCreate trigger TestTriggeron tableaNameinstead of insertasbegin transactiondeclare @aid intset @aid=0select @aid = max([columnName]) from tableNameif @aid 0--do operationcommit transaction

madhuk17

 Profile Answers by madhuk17 Questions by madhuk17

• Feb 18th, 2007

Create or replace trigger {Before/After} {Insert/Update/Delete} on [Referencing [ New as ] [ Old as ][For each row [When ]]

Answer Question  Select Best Answer