 Related Questions WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers Latest Answer : When referencing the current row from an explicit cursor, use the WHERE CURRENT OF clause. This allows you to apply updates and deletes to the row currently being addressed, without the need to explicitly reference the ROWID. You must include the FOR ... Insert Update Latest Answer : Triggers can be classified based on the below factors -(1) Trigger Event:INSERTUPDATEDELETE(2) Trigger Type:STATEMENT LevelROW Level(3) Trigger Timings:BEFOREAFTERINSTEAD OF ... I. done using Database triggers. ii. done using Integarity Constraints. I & ii. Exception Latest Answer : create table a ( b number, c number check (c >100) );create or replace trigger t1 before insert on a begindbms_output.put_line('this is before insert trigger'); end;create or replace trigger t2after insert on a begindbms_output.put_line('this ... Latest Answer : View: If a query is being used again and again then its better to create a view with that query. The query gets stored in database as an object.Materialized view: When you want you replicate the main data to multiple sites to reduce the load on main server ... What is pragma? can any one give me the example of autonomous Transaction ?can we change the order of procedure parameter while calling procedure? Read Answers (6) | Asked by : manali If there is an index including three columns A, B and C. And if we issue a query in which where clause uses only column B....will the index be useful??and what if the where clause only has coulmn A..will the index b useful?? Read Answers (6) | Asked by : smita Latest Answer : Order of triggre firing :::::::Before Statement levelBefore Row levelAfter Row levelAfter Statement level ... Read Answers (6) | Asked by : joseph In PL/SQL if we write select statement with INTO clause it may return two exceptions NO_DATA_FOUND or TOO_MANY_ROW . To do you avoid these execeptions. How do you write SQL statement in alternative way? Write sample code that can create a hierachical set of data without using a start with and connect by clause in PL/SQL SELECT APE.DAT_INSERT_DATE as "Payment Entry Date", Case when APE.TXT_INTERMEDIARY_CD is null or APE.TXT_PAYER_CUSTOMER_ID APE.TXT_INTERMEDIARY_CD then (Select TXT_CUSTOMER_NAME from GENMST_CUSTOMER Latest Answer : create or replace procedure sql_to_procedure as declare cursor c1 is SELECT APE.DAT_INSERT_DATE as "Payment Entry Date",APE.TXT_INTERMEDIARY_CD AS "Intermediary ID",APE.TXT_PAYER_CUSTOMER_ID as "CustomerID/Payer ID",TXT_CUSTOMER_NAME ... Read Answers (1) | Asked by : preeti
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0