What are Return Statement and OUT Parameter in PLSQL Function?
Latest Answer: Functions always return a value.Procedures do not.The use of IN, OUT, and IN_OUT parameters as scalar values or ref cursors is dependent on your need and overall performance not on a pseudo-standard as answered above. ...
How can we generate debugging output from PL/SQL?
Latest Answer: Use "SHOW ERRORS" command.Regards,Karthik ...
we can create a column with' not null+unique' with out using primary key
Latest Answer: Along with the answers mentioned above To add cascading is only possible when it follow primary key - foriegn key constraint. ...
How can the error line can be identified for a package at run time ?
Latest Answer: Starting from Oracle 10G we can use DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function to get the line from where the error originated. ...
Hi All,I have requirement of sending the records based on the input received from web.I have a ref_cursor returning 30 rows..Here I am supposed to do paging on the set of records present in the above ref
Latest Answer: First you have to filter the no of records you need totally (i.e., if you receive input as 2 and if the no of records you need to return are 20, then you need to filter 20 rows) using where rownum ...
Latest Answer: Optimizer hints are used to alter execution plan of SQL statement. For ex, certain index can be sometimes more selective for certain queries. Based on the information you can choose a more efficient execution plan by using hint and telling the optimizer ...
How oracle manages dependency between referenced and dependent objects ?
Latest Answer: We can set REMOTE_DEPENDENCIES_MODE inside init.ora parameter file to TIMESTAMP or SIGNATURE.ALTER SYSTEM SET REMOTE_DEPENDENCIES_MODE = [TIMESTAMP|SIGNATURE] ...
List at least three common ways to write logs in PL SQL?
Latest Answer: 1. Create a log table and insert your logging messages into this table.2. Write to a log file, using the DBMS_FILE package, but this is not recomended because there is lot of I/O. ...
Hi,My questions is " Can function return more than one value".I have gone through the all answers relevant to my question was been posted earlier. But all answers are confusing me.Few people
Latest Answer: Yes this can be possible by TABLE FUNCTION STEP - 1 CREATE TYPE ex_tabl_fun_obj AS OBJECT (emp_name varchar2(20), emp_id NUMBER(2));STEP - 2 CREATE TYPE ex_tabl_fun_tbl AS TABLE OF ex_tabl_fun_obj;STEP - 3 ...
Hi,There is problem with ult_file.fopen. When I run from the server side, there is no issue with utl_file and it is working fine.If I run the same procedure from Client machine, I am facing problem. It
Latest Answer: the parameter set in configuration file init.oraand UTL_FILE_DIR belongs to the directory structure in oracle server machine. And the directory structure should be on same machine as oracle server. Thus fopen can run in oracle server machine not client.Thus ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
