What Is BulkBind? When it is used?
Latest Answer: Bulk Bind is the facilty through which we can INSERT, UPDATE, DELETE or SELECT from records from a table in bulk rather than multiple individual statments..Suppose you have 10 inserts to be made so you use 10 INSERT into statments to do this.Instead of ...
How can we handle multiple rows without using loops in PL SQL?
Latest Answer: This can be done by a function called TABLE FUNCTION by means of this you can return more number of rows and columns this is more effective than using ref cursorregards sen-prakash ...
While tuning SQL query what should be taken into consideration?
Latest Answer: During the SQL tuning, there couple of things need to be considered1. If it is below Oracle 9i we need make sure about the driving table concept (Since it uses RBO - Rule Based Optimization), which improves the performance, After
Oracle 9i Oracle will ...
How to send Email via PL/SQL Procedure?
Latest Answer: rem -----------------------------------------------------------------------rem Filename: smtp.sqlrem Purpose: Send e-mail messages from PL/SQLrem Notes: From Oracle8i release 8.1.6 one can send ...
How to call a PL/SQL function in another PL/SQL function? Is it possible? Give example?
Latest Answer: eg,create or replace fun_1 return varchar2asddmmyy varchar2;beginselect sysdate into ddmmyy from dual;end fun1;in above example function fun_1 calling another function (i.e. sysdate) thro' select statement. this way you can call any function ...
What are advantages of Autonomous Transcation?
Define External Table
Latest Answer: it is same as oracle table but act as view to the data available in an external file of a physical drive,so here we can query the data and retrieve and can do anything but cannot do manupulations on the data ...
How to load whitespace delimited data using SQL*Loader?
How to load tab delimited data using SQL*Loader?
How to return more than one row through functions? Explain with example.
Latest Answer: create or replace function f1 return sys_refcursor as
r1 sys_refcursor;
begin open r1 for select * from emp;
return(r1);
end;
call the function as: select f1 from dual;
Thanks & Regards
RAJIV GUPTA (ORACLE CONSULTANT)
YOGIK TECHNOLOGIES ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
