sankari

• Jan 9th, 2007

We can do as shown below... in the same way we can drop the table..

DECLARE
BEGIN

EXECUTE IMMEDIATE 'create table employee(empno number(3),ename varchar2(10))';

END;

gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Dec 26th, 2006

HI,  table can be created by using either dbms_sql or EXECUTE_IMMEDIATE in procedure or function.

Answer Question  Select Best Answer

Brajesh Singh Bhadoriya

 Profile Answers by Brajesh Singh Bhadoriya Questions by Brajesh Singh Bhadoriya

• Jan 15th, 2007

hi...actually the IN parameters are the read only parameters hence we can't assign any value to them but for out parameters its not true, as we can assign value to OUT parameters. so the procedur...

Answer Question  Select Best Answer

Guest

• Jan 16th, 2007

A forward declaration looks like the package definition part but is inside the bode.e.g.procedure A isbegin  B;end A;procedure B isbegin  null;end B;will not work, because during call to B B...

Donald H. Kirschman

• Dec 27th, 2006

Scalar data types store one single element of data, as opposed to composite data types.  This is not a concept that is unique to Oracle PL/SQL; rather, it is common to any programming language.&n...

Answer Question  Select Best Answer

saurabh kumar verma

• Jan 19th, 2007

Cursor is basically a pointer as it's like a address of virtual memory which is being used storage related to sql query & is made free after the values from this memory is being used.

Answer Question  Select Best Answer

Sagar Sai

• Feb 4th, 2007

Hi,There are 3 types of triggers available in the Database. They are 1.DML Triggers :- These are again 12 types like .. Before INSERT,UPDATE,DELETE and After INSERT...

Pawan Ahuja

• Dec 3rd, 2006

there are three types of triggers in pl/sql1.)DML triggers2.)instead of triggers3.)system event triggersRegardsPawan Ahuja

Answer Question  Select Best Answer

srini

• Feb 6th, 2007

Actually explicit cursor refers only one work area in memory,incase of ref cursor refers different work areas in memory.

ranjeetapegu

 Profile Answers by ranjeetapegu Questions by ranjeetapegu

• Jan 12th, 2007

Difference between Pl/sql tables and record is that in pl/sql tables we can store more than one row whereas in record we store only one row.TYPE rec_emp is RECORD( ename   varchar2(10), empn...

Answer Question  Select Best Answer

madhuk17

 Profile Answers by madhuk17 Questions by madhuk17

• Feb 8th, 2007

Hi,I think trigger is not called.The code in the trigger defines the action the database needs to perform whenever some database manipulation (INSERT, UPDATE, DELETE) takes place.I think maximum number of data strings that can be returned through DBMS_OUTPUT is 255 bytes.

gchandra_sekar

 Profile Answers by gchandra_sekar Questions by gchandra_sekar

• Feb 7th, 2007

Hi!) Trigger cannot be called as it automatically gets activated once u touch the table.2) Prior 10g user SQL> set serveroutput on size 1000000 or if it is 10gORA10GR2> set serveroutput on size unlimited

Answer Question  Select Best Answer

madhuk17

 Profile Answers by madhuk17 Questions by madhuk17

• Feb 9th, 2007

We can call a function from anonymous block as a part of sql statement written in that block.eg: create or replace function fn_emp(v_empno in number)return varchar2 isbeginselect ename into v_ename fr...

rajnish123

 Profile Answers by rajnish123 Questions by rajnish123

• Dec 30th, 2006

hi,suppose a function  add two number and you desire to call it from anonyms block.create or replace function f_add(a in number,b in number) return number asc number;beginc:= a+b;return (c);end;t...

Answer Question  Select Best Answer

geetha24

 Profile Answers by geetha24 Questions by geetha24

• Feb 9th, 2007

There is no limitation on the number of Subprograms in the package, but there is a limitation on the compiled file size in the database.

Answer Question  Select Best Answer

Vishakha

• Feb 17th, 2007

 declare cursor v_cursor is      select empno, empnm, empdept from emp where empdept = 10;begin      open v_cursor;     ...

geetha24

 Profile Answers by geetha24 Questions by geetha24

• Feb 13th, 2007

To display the cursorOPEN v_cursor FOR SELECT ename, empno, deptno FROM emp WHERE deptno = p_deptno ORDER BY ename;LOOP FETCH v_cursor INTO v_ename, v_empno,...

Answer Question  Select Best Answer

sunflower

• Feb 22nd, 2007

DBMS_TRACE package can be used to keep track of the calls between the subprograms and trace of execution by sub-program, procedures, functions or an exception. It gives a large amount of trace da...

Jian Zhang

• Oct 10th, 2006

When you want to see the execute plan of a SQL statement, you need to use TRACE function of Oracle.

Answer Question  Select Best Answer

Innila

 Profile Answers by Innila Questions by Innila

• Mar 2nd, 2007

LOB datatypes can be used to store blocks of unstructured data like graphic images, video, audio, etc

Answer Question  Select Best Answer

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Mar 7th, 2007

One thing nikhil handle sqlerrm with variables .that increases perfmance ok.

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Mar 6th, 2007

Thank you very mech nikhil

Answer Question  Select Best Answer

madhaviguthula

 Profile Answers by madhaviguthula Questions by madhaviguthula

• Mar 8th, 2007

Hi Hemant, Please go through the following code for better understanding.First, create and populate a test table with a concatenated index.CREATE TABLE test_objects ASSELECT * FROM all_objects;CREATE...

hemant.agarwal03

• Mar 8th, 2007

Hi Madhvi..How we will use that one special feature?Regards,Hemant

Answer Question  Select Best Answer

ravikumarzee@gmail.com

 Profile Answers by ravikumarzee@gmail.com Questions by ravikumarzee@gmail.com

• Mar 8th, 2007

begin for i in 1..10 loopif i 5 then -- do stuff.end if;end loop

madhu

• Feb 9th, 2007

I hope this will work..
declare
i number(2);
Begin
for i in 1.. 10
loop
if (i ==5) then

else
exit;
end loop;
end;

Answer Question  Select Best Answer

BASAVARAJ KOLUR

• Mar 9th, 2007

plsql supports mainly 3 types of collections    1> index by binary_integer    2> nested table    3>varrays index by binary_integer and nested...

Gupta

• Aug 7th, 2006

Types are Index -by- table, Nested Tables and Varray!

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

Instrument

 Profile Answers by Instrument Questions by Instrument

• Mar 18th, 2007

A nested loop is a loop within a lop, an inner loop within the body of an outer one. How this workds is that the first pass of the outer loop triggers the innter which executes to completion. Then the...

Answer Question  Select Best Answer

Nikhil_4_Oracle

• Mar 23rd, 2007

HI ALL,try this..,create or replace procedure ddl_proc(tabname in varchar2)asv_cursor INTEGER;ddl_exe INTEGER;beginv_cursor:=Dbms_sql.open_cursor;Dbms_sql.Parse(v_cursor,' Create Table '||tabn...

Anurag Puranik

• Mar 23rd, 2007

We can use DDL commands in Procedure & Functions through "EXECUTE IMMEDIATE " Command

Answer Question  Select Best Answer

Hi,1. Iam looking for sample program for ref cursor. ref cursor can be associated with many select statements and we can use the ref cursor to return the multiple value from the procedure or function. how to use the ref cursor in a program to associate with many select statements.2. we can't use the %rowtype attribut to return the multiple from the procedure or function instead of ref cursor. if we...

krishnamohan_geek

 Profile Answers by krishnamohan_geek Questions by krishnamohan_geek

• Mar 25th, 2007

Hi,Let me answer your second questin first. Why ref cursor instead of %ROWTYPE.%ROWTYPE is used for fetches record/row of a single table.OR in case of columns of different tables then you have to crea...

Answer Question  Select Best Answer