Latest Answer: DUAL is a part data dictionary and owned by SYS. You should not make modifications to this table. It contains only one row and one column of VARCHAR2 datatype.Used to refer an object which does not have any pysical reference in database ...
Latest Answer: To be callable from SQL statements, a stored function must obey the following "purity" rules, which are meant to control side effects:1. When called from a SELECT statement or a parallelized INSERT, UPDATE, or DELETE statement, the function ...
Latest Answer: late binding ...
What is the difference between using IS and AS while creating a procedure, function package and package body?
Latest Answer: We cant use functions with OUT parameter in sql statements because there is no way for you to declare a variable in a SQL query and in order to call an IN OUT -- you need a local variable (to supply a value to be read from and to supply a place to put ...
Latest Answer: OCI stands for Oracle Call Interface, it is a interface api used to access oracle database from C programs. Data Guard stands for it is multiple DB servers enviornment configured for Physical as well as Logical Standby Databases. And Oracle Advance Queueing ...
Latest Answer: We should use Exists or In based on the no of records inner and outer query is expected to return.Using Exists : Here the outer query is executed first and then inner query is excecuted for each value of outer query. So use this when outer query contains ...
How to reduce the the burden/main memory on database if i am using refcursor to hold large data to increase performance.
Latest Answer: SQL (Structures Query Language)PL/SQL (Procedure Language / SQL) is the Oracle's version with lots of additional proprietary functions.T-SQL : Transact-SQL is Microsoft's proprietary version of SQL. ...
View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>
Go Top
