 Related Questions NULLNOT NULLCHECKDEFAULT Latest Answer : The Constraints are Primary Unique Check Null ... It is a column that is not an actual column in the table.eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL. Latest Answer : Pseudo columns is not actula column in the table. it behaves like table columnwe can retivesv values of pseduo column but can not insert,update or delete value in that.has two data type 1. rowid 2. urowidrow id uniqely identify row in databaseEXM ... PL/SQL declares a cursor implicitly for all SQL data manipulation statements, including quries that return only one row. However,queries that return more than one row you must declare an explicit cursor Latest Answer : explicit ... A cursor variable is associated with different statements at run time, which can hold different values at run time. Static cursors can only be associated with one run time query. A cursor variable is reference INOUTINOUT Latest Answer : IN : lets you pass values to the subprogram being calledOUT: lets you return values to the caller of subprogramINOUT: lets you to pass values to the subprogram and return values to the caller of the subprogram. ... The variables declared in the procedure and which are passed, as arguments are called actual, the parameters in the procedure declaration. Actual parameters contain the values that are passed to a procedure Latest Answer : Formal Parameter: A variable declared in the parameter list of a subprogram specificationExample: create or replace procedure/function x (p_id number, p_sal number)Actual Parameter: A variable or expression refrenced in the parameter list of a subprogram ... Yes Latest Answer : Yes. In such case you don’t need to specify any value and the actual parameter will take the default value provided in the function definition ... No. A function has to return a value,an OUT parameter cannot return a value. Latest Answer : Yes ,function can return a value but it is not a good programming practice ... How to delete set of records at a time where all the records having same values , except the Rowid differs? How do we restrict the insert/ updates on the foreign column in a table if that table is in different instance that the table with Primary Key. Say for Example Emp and Dept Table. We have deptno in both tables and Deptno in Emp table is the Primary Key and other is foreign Key. How do we control what values we insert in Dept table if both the tables are not in the same instance.
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
