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. ...
When using a count(distinct) is it better to use a self-join or temp table to find redundant data, and provide an example?
Latest Answer: Application trigger: Fires whenever an event occurs with a particular application Database trigger: Fires whenever a data event (such as DML) or system event (such as logon or shutdown) occurs on a schema or database ...
Latest Answer: With the Oracle-supplied UTL_FILE package, you can read from and write to operating system files. It Provides security for directories on the server through the init.ora file. UTL_FILE Procedures and Functions:• Function FOPEN• Function IS_OPEN• ...
Latest Answer: Hi, Please find the explanation below....CURSOR A cursor is a variable that runs through the tuples of some relation. This relation can be a stored table, or it can be the answer to some query. A cursor can be used in realtime when ...
What is the difference between private packages and public package . what is the difference in declaration of these 2 packages.
View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>

Go Top