|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single Latest Answer : when query is based on condition we use where clause & there is no any aggregate functionwhen query is base on contion & aggregate function has to be use then we can usehaving clause. ... Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while Latest Answer : PROCEDURE ... 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 ... Oracle Call Interface is a method of accesing database from a 3GL program. Uses--No precompiler is required,PL/SQL blocks are executed like other DML statements. The OCI library provides-functions to parse Latest Answer : The Oracle Call Interface (OCI) is a set of low-level APIs (Application Programming Interface Calls) used to interact with Oracle databases. It allows one to use operations like logon, execute, parse, fetch, etc. OCI programs are normally written in C ... UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, PUT_LINE, NEW_LINE, Latest Answer : With the Oracle-supplied UTL_FILE package, you can read from and write to operating system files. It Provides security for directories on the server through the init.ora file. UTL_FILE Procedures and Functions:• Function FOPEN• Function IS_OPEN• ... You have EMP and dept table .how do you get the entire department and corresponding employee details You have EMP and dept table .how do you get the entire department and corresponding employee details and the department which are not alloted it?what is referential integrity constraint?wat is triggers,stored procedures,stored functions explain with examples Read Answers (2) | Asked by : umarajeswari Latest Answer : An external procedure is simply a program unit that is not written in Oracle’s SQL or PL/SQL and resides outside of the database. External procedures must be stored as shared libraries at the operating system level. In a Windows NT environment, ... Read Answers (3) | Asked by : samanta
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
