 Related Questions A view is stored procedure based on one or more tables, it’s a virtual table. Latest Answer : View
View is logical table based on one are more table join and named as viewname
View is not stored in database View is used to perform complex query, View Object,
View support, LOB, varray, Nested Tables Should have CREATE ... INSTR('120000 12 0 .125',1,'.')output 13 Latest Answer : select instr('1200023.56', '.') from dual; ... '' Should be used before '%'. Latest Answer : select * from emp where instr('ename','%')!=0 ... SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal Latest Answer : SELECT v.sal FROM (SELECT TO_NUMBER(salary) sal,rank() over (ORDER BY TO_NUMBER(salary) DESC) ranksal FROM employee ORDER BY 1 DESC)v WHERE v.ranksal=6 Pls note where 6 is the ranknumber ... A bad answer is count them (SELECT COUNT(*) FROM table_name)A good answer is :-'By generating SQL to ANALYZE TABLE table_name COUNT STATISTICS by querying Oracle System Catalogues (e.g. USER_TABLES Latest Answer : If you want to find the number of Rows in table SELECT COUNT(*) FROM EMP;This is valid query ... 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 In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with version 2.2, the only means of passing a cursor 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:Parameters IN, OUT and IN OUT and can return n number of values via sys cursor.Function:Only IN parameter and must return a value by using RETURN.Can be used in where clause of the Query but performance issue will raise. ... 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 ... Drop Procedure procedure_nameDrop Function function_name Latest Answer : absolutely it will work ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0