What is the differences between it.

norman

 Profile Answers by norman Questions by norman

• May 8th, 2007

Rule Based Optimization is an older technique which is used for optimization of queries but follows a fixed rule or strategy for achieving the same. But in contrast cost Based Optimization is a later ...

Answer Question  Select Best Answer

Hi, can any body give me the sample program for avoiding the mutating error. we can avoid the mutating through the statement level trigger instead of using the statement leve trigger, i need one sample program to avoid the mutating error by using pl/sql table.Thanks Saravanan.P

KiranKW

 Profile Answers by KiranKW Questions by KiranKW

• May 3rd, 2007

A mutating error comes when u r trying to do some DML operation on a table that owns the trigger.... there are a lot of options to avoid mutation .. eg, Making it autonomous transaction...

Answer Question  Select Best Answer

Hi all I wrote a procedure to send email via plsql procedure, It was compiled successfully but not working ....

here is the code (actuly i added the dbms output like step1 ,step 2 to see in which step the control is going on )

PL/SQLcreate or replace PROCEDURE send_test_message
IS
mailhost VARCHAR2(64) := 'mail.cmcltd.com';
sender VARCHAR2(64) := 'akash.sharma@cmcltd.com';

KiranKW

 Profile Answers by KiranKW Questions by KiranKW

• May 3rd, 2007

Hi,   I dont see any problem with your code ... try to capture the return code for each of the calls ... that will help to identify the exact problem

Answer Question  Select Best Answer

ramnath123

 Profile Answers by ramnath123 Questions by ramnath123

• Oct 21st, 2011

Code + decode

Code
code + decode

Answer Question  Select Best Answer

mohan

• Apr 9th, 2007

CREATE OR REPLACE TRIGGER t_trigger AFTER INSERT ON t1 FOR EACH ROW DECLARE   PRAGMA AUTONOMOUS_TRANSACTION;  i PLS_INTEGER; BEGIN   SELECT COU...

mohan kumar

• Apr 9th, 2007

Yes We can use commit statement in triggers with 10G.Here is example :CREATE OR REPLACE TRIGGER t_trigger AFTER INSERT ON t1 FOR EACH ROW DECLARE   PRAGMA AUTONOMOUS_TRANSA...

Answer Question  Select Best Answer

Suppose if i have 8 triggers declared for a table..how to disable a single trigger from a table...i don't want to disable all triggers for a table. I know we can disable all triggers by using "alter table disable all triggers;". just i want to know how to disable single trigger from a table.

Pavan

• Apr 3rd, 2007

Thanks parweej, alter trigger <trigger-name> disable worked for me..

subbaraovangalli

 Profile Answers by subbaraovangalli Questions by subbaraovangalli

• Mar 27th, 2007

To disable a perticular trigger on a table             alter table disable trigger

Answer Question  Select Best Answer

subbaraovangalli

 Profile Answers by subbaraovangalli Questions by subbaraovangalli

• Mar 26th, 2007

 by using            show_errors we can  see the errors in the prev created procedure.      dbms_output.put_li...

deep_paudel

 Profile Answers by deep_paudel Questions by deep_paudel

• Mar 12th, 2007

DBMS_OUTPUT.put_line

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

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

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 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

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

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

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

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

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

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

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

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

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