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: create proc test1(@x integer)asbeginSELECT empid FROM (SELECT empid FROM emp ORDER BY empid ) WHERE ROWNUM = @x;end ...
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: Data Buffers ...
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: Hello,NVL2 function is used to substitute a value for an expressionNVL2(string, value_if _not_null_value, value_null_value) if the string contains a null vlaue it is replaced with the 2 (Value_null_vale)else ...
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
