Hi All,I want create a stored procedure by passing the parameter to top nth recordfor Excreate proc test1(@x integer)asbeginselect top @x empid from emp order by empid descendwhen iam executing iam getting
Latest Answer: Solution to your problem:Create Procedure TEST1( p_num number)isv_eid number;begin  select empid into v_eid from EMPwhere empid=(select A.empid from (SELECT empid, rank() over (order by empid desc) RNK FROM emp) A where A.RNK=p_num);dbms_output.put_line('Top'|| ...
A. A function must return a value.B. A procedure must return a value.C. A function executes a PL/SQL statement.D. A function is invoked as part of an expression.E. A procedure must have a return data type
Latest Answer: These two are true A & D ...
Latest Answer: You can use these two methods to find out the Duplicate Entries. There are some more ways to do the same, But I am not able to recollect those at this time. Anyways these two will do the work for you. ...
Latest Answer: DB buffer cache, Redo Log cache and Shared PoolShared Pool --> data dictionary cache, Library cache and User Global area ...
Which two statements complete a transaction? (Choose two)A. DELETE employees;B. DESCRIBE employees;C. ROLLBACK TO SAVEPOINT C;D. GRANT SELECT ON employees TO SCOTT;E. ALTER TABLE employees SET UNUSED COLUMN sal;F. Select MAX(sal) FROM employees WHERE department_id = 20;According to my knowledge, DDL & DCL stmts have implicit commit & so end the transaction.Also, issuing of ROLLBACK & COMMIT ends a transaction hence answers should be C(ROLLBACK), D(DCL) & E(DDL) & E. Pls confirm.
Latest Answer: We can set all the null value columns to some other values after that we can get all the corresponding rows and columns of the table. ...
Latest Answer: Hi,select owner, segment_name,bytes/1024/1024 "Size in Mb" from dba_segments where segment_type=This is total size physicall occupiedfor actual size:Analyze the table first using DBMS_STATS package and run the follwoing command.select ...
Latest Answer: using dbms_output.put_line(loop counter variable); ...
Latest Answer: Hello,SQL * LOADER is a utility tool which comes inbulit with any versions of Oracle. it is used to load data (.txt,.xls, tables, Doc ...) any flat files of this type can be loaded into Oracle database tables.It can take one single flat file and ...
Latest Answer: tablespaces are the logical constructs which are group of datafiles. a datafile belongs to one database. in laymans language we can say that tablespaces are like folders in windows environment. as we create diff folders to store files in the same way ...
View page [1] 2 3 Next >>
Go Top
