 Related Questions Cursor C1 is Select empno, ename from Latest Answer : Commit in this context will not do anything except the commiting the changes into database, done using DML statements. However, if the cursor is created with FOR UPDATE clause, it will raise runtime exception as commit, in that case, would also ... 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 ... SQLCODE returns the latest code of the error that has occurred.SQLERRM returns the relevant error message of the SQLCODE. Latest Answer : • SQLCODE: Returns the numeric value for the error code• SQLERRM: Returns the message associated with the error numberSQLCODE Value Description ... A FUNCTION is always returns a value using the return statement. A PROCEDURE may return one or more values through parameters or Latest Answer : 1. Function is mainly used in the case where it must return a value. Where as a procedure may or may not return a value or may return more than one value using the OUT parameter. 2. Function can be called from SQL statements where as procedure can not ... IN,OUT,IN-OUT parameters. Latest Answer : IN (default): Passes a constant value from the calling environment into the procedureOUT :Passes a value from the procedure to the calling environmentIN OUT :Passes a value from the calling environment into the ... FUNCTION name (argument list .....) Return datatype is local variable declarations Begin Latest Answer : create or replace function function_name(formal parameters list with only IN mode) return datatypeislocal variable declarationsbegin executable statments; return value;end function_name; ... Function is called as part of an expression. sal := calculate_sal ('a822'); procedure is called as a PL/SQL statement calculate_bonus ('A822'); Latest Answer : Procedure can be called in the following waysa) CALL direcb) EXCECUTE from calling environmentc) from other procedures or functions or packagesFunctions can be called in the following ... The Same procedure name is repeated with parameters of different datatypes and parameters in different positions, varying number of parameters is called overloading of Latest Answer : Definining two or more procedures with same name is called overloading of procedures. But they must differ in no or order or datatype family of formal arguments. ... a. Stored procedure or anonymous block b. an application program such a PRC *C, PRO* COBOL c. SQL *PLUS Latest Answer : a. PACKAGE NAME.PROCEDURE NAME (parameters); variable := PACKAGE NAME.FUNCTION NAME (arguments); b. BEGIN PACKAGE NAME.PROCEDURE ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2 
2