DECLARE A EMP.ENAME%TYPE; B EMP.SAL%TYPE;BEGIN UPDATE EMP SET SAL=SAL*1.1 WHERE EMPNO=&EMPNO; __________ ENAME, SAL INTO A, B FROM EMP;END;What should I write in that blank to get the details of just updated record???
Latest Answer: 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 '||tabname||' (col1 number(2),col2 varchar2(5)) ',Dbms_sql.native);ddl_exe:=Dbms_sql.Execute(v_cursor);dbms_sql.close_cursor(v_cursor);end ...
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.
Latest Answer: 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 create a RECORD and then used %ROWTYPE.But ...
Latest Answer: declarecursor cursor_name isselect col1,col2,col3from tab_name;ab_record cursor_name%rowtype;beginopen cursor_name;loopfetch ab_record into cursor_name;exit when cursor_name%notfound;insert into tab_name(col1,col2,col3)values(ab_record.col1,ab_record.col2,ab_record.col3);end ...
Latest Answer: declare cursor v_cursor is select empno, empnm, empdept from emp where empdept = 10;begin open v_cursor; loop fetch v_cursor ...
Latest Answer: An Oracle stored procedure is a program stored in an Oracle databaseStandalone procedures are the procedures stored in the oracle database and not enclosed in a package. ...
Latest Answer: 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                   COL1------------------ ----------AAAOV+AAAAAAAJ0AAA        ...
Hi,Can somebody please answer couple of my questions ASAP?1) How do you call a trigger on a table?2) What is the maximum number of data strings that can be returned through DBMS_OUTPUT?Much thanks!!
What is the maximum number of data string can be returned from DBMS_OUTPUT? andHow do you call a trigger from a table?
Hi all I wrote a procedure to send email via plsql procedure, It was compiled sucessfully 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 )create or replace PROCEDURE send_test_messageIS mailhost VARCHAR2(64) := 'mail.cmcltd.com'; sender VARCHAR2(64) := 'akash.sharma@cmcltd.com'; recipient VARCHAR2(64) := 'lalit.mohan@cmcltd.com'; mail_conn utl_smtp.connection;BEGIN
View page << Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>
Go Top
