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

madhug56

 Profile Answers by madhug56 Questions by madhug56

• Jun 12th, 2007

SQL is a structured query language.Used to perform operations such as retrieval,updations,insertions etc. on database.PL/SQL is a Programming language which is an extension for SQL with control struct...

psom

• Jun 8th, 2006

  Embedded SQL - SQL statements are invoked from a host environment like C/C++, Java or any other programming languages.

Answer Question  Select Best Answer

 User_objects, User_Source and User_error. 

idonknowyou

 Profile Answers by idonknowyou Questions by idonknowyou

• May 22nd, 2007

The Data dictionary tables/ Views where the characteristics of subprograms and Packages are stored are mentioned belowa) USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTSb) USER_SOURCE, ALL_SOURCE, DBA_SOURCEc) USER_DEPENCENCIESd) USER_ERRORS, ALL_ERRORS, DBA_ERRORS

vinod kumar

• Nov 16th, 2005

User_source , user_object , user_errors

Answer Question  Select Best Answer

 Function is called as part of an expression.   sal := calculate_sal ('a822');   procedure is called as a PL/SQL statement   calculate_bonus ('A822');

idonknowyou

 Profile Answers by idonknowyou Questions by idonknowyou

• May 22nd, 2007

Procedure can be called in the following waysa) CALL <procedure name> direcb) EXCECUTE <procedure name> from calling environmentc) <Procedure name> from other procedures or functions...

M.KUMARAN

• Nov 13th, 2005

Function is called as part of an expression.   sal := calculate_sal ('a822');   procedure is called as a PL/SQL statement   calculate_bonus ('A822');KKK

Answer Question  Select Best Answer

gopichandv2002

• May 22nd, 2007

You should write returning in the blank place

Answer Question  Select Best Answer

RoulRaj

• May 11th, 2007

There should be atleast one statement in between Begin and End.The Statement may be Null statement also.Syntax:declarebeginnull;end;RegardsR.K.Roul

Answer Question  Select Best Answer

RoulRaj

• May 9th, 2007

Dear Rajeswaran,Please give one example(application) where one can use force view.Thanks & regards

Rajeshwaran

• Jun 3rd, 2006

usually the views are created from the basetable if only the basetable exists.The purpose of FORCE keyword is to create a view if the underlying base table doesnot exists.ex : create or replace FORCE ...

Answer Question  Select Best Answer