-
Analytical functions
What are analytical functions and how are they used?
singh.neerajin
- Jul 22nd, 2008
Analytic functions compute an aggregate value based on a group of rows. They differ from aggregate functions in that they return multiple rows for each group. The group of rows is called a window and ...
-
What happens to the base table transactions when procedure has some error?
Procedure A calls procedure B. A updates table t1, t2. B updates table t3. If some error happens to B what happens to the updates in all those tables? Whether they will rollback or commit? If commits how far it will commit?
vishal.bhadange
- Aug 24th, 2013
CASE 1 (If you are not handling exception in Procedure B, none of the table gets updated) "sql PROCEDURE A BEGIN UPDATE TABLE t1; UPDATE TABLE t2; CALL PROCEDURE ...
-
What is procedure and package
Hi ,can any one tel pls what is use ofprocedures and packages? why we use can anyone tell me with one real time example
-
-
Dear friend, my question is assume that we have created on table,on that table we are creating one view and one synonym know i have drop the table then status of view is invalid but status of synonym is not invalid pls give me the answer
gangadharam.p
- Jan 6th, 2007
hi, when u do so the view gets error and synonym becomes invalid. If u create a table again with same name but with different cols the synonym will work but view wont.bcz view is the stored...
raghgu
- Nov 16th, 2006
Hi friend, As per RDBMS rule we cannot have invalid synoym, but we can have a invalid view.
-
row level,statement level,before,after,insert,update,delete 3*2*2 total 12 types.
and can i even mention instead of triggers,database trigger and schema triggers">If anyone asks in interviews, about "what are the types of triggers" then my ans is likerow level,statement level,before,after,insert,update,delete 3*2*2 total 12 types.and can i even mention instead of triggers,database trigger and schema triggers
-
-
Can we use function inside a trigger
-
Bind variabales
What are bind variables in sql? explain in detail?
pradipta
- Feb 8th, 2014
The way to get Oracle to reuse the execution plans for "the statements having different hard coded value in where clause" there should use bind variables. Bind variables are ?substitution? variable...
Aarti
- Jan 15th, 2014
Bind variable is session specific variable. It is declared using variable keyword. Bind variable cant be used in named block. It cant have default value.
-
What is meant by instead of cursor?
Raviteja
- Aug 23rd, 2014
Instead of cursor is not there,, instead of trigger is used incase of complex views. when we use views with joins
Kumar
- Jul 25th, 2014
Its instead of trigger not cursor and it is used to apply trigger on views.
-
Is it possible that we can make a query to search the data
Umair Tariq">Hello,I need some info, that is it possible to find or make query ,that if we know the data stored in a table but don't know the field name in which the required data is stored.ExampleTable having fields like columnA, columnB, columnC, columnD,..........columnN and all have the same dataType. and you dont know in which field your data exists.suppose some data like e.g. "BackMan" exists in any Field of the table but we don't know in which Field this information is store.Is it possible that we can make a query to search the dataUmair Tariq
-
How to handle exception in Bulk collector?
mariashylaja
- Aug 12th, 2006
During bulk collect you can save the exception and then you can process the exception.Look at the below given example:DECLARE TYPE NumList IS TABLE OF NUMBER; num_tab NumList := NumList(10,0,11,1...
mariashylaja
- Aug 12th, 2006
DECLARE TYPE NumList IS TABLE OF NUMBER; num_tab NumList := NumList(10,0,11,12,30,0,20,199,2,0,9,1); errors NUMBER;BEGIN FORALL i IN num_tab.FIRST..num_tab.LAST SAVE EXCEPTIONS DELETE *...
-
Why DUAL table is not visible?
Read Best Answer
Editorial / Best Answer
krishnaindia2007- Member Since Sep-2007 | May 13th, 2008
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 table.
Ex:- Select sysdate from dual.
Aditya Kumar
- Dec 17th, 2017
If it contains only one column with varchar2 data type then how can it return a date through sysdate.
krishnaindia2007
- May 13th, 2008
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 table.Ex:- Select sysdate from dual.
-
Bulk binding
What are the advantages of bulk binding in PL/SQL?
-
-
What is diff between strong and weak ref cursors
Baji Shaik
- Jun 5th, 2011
Strong ref cursor return value, but seek ref cursor it can't return any value
askvenki
- Jul 20th, 2007
A strong REF CURSOR type definition specifies a return type, but a weak definition does not.DECLARE TYPE EmpCurTyp IS REF ...
-
-
What is PL/Sql tables?Is cursor variable store in PL/SQL table?
Pixie
- Feb 18th, 2014
PL/SQL tables are PL/SQLs way of providing arrays. They are temporary tables in memory and thus are processed very quickly. They are not database tables, and DML statements cannot be issued against...
sbagai2001
- May 30th, 2006
DECLARE TYPE EmpCurTyp IS REF CURSOR; // Reference Cursor - weak TYPE NumList IS TABLE OF NUMBER; // Table of Number TYPE NameList IS TABLE OF VA...
-
When we need to use USING clause in the sql?For example in this below:SELECT emp_name, department_name, city FROM employees e JOIN departments d USING (department_id) JOIN locations l USING (location_id) WHERE salary > 10000; Can anyone explain what is mean of USING in this sql statement? or USING concept in brief? Thank you.
hmounir
- Nov 17th, 2009
In natural joins USING clause can be used to specify only those culomns that should be used for an equijion
ravikumarzee@gmail.com
- Mar 9th, 2007
USING is also used while executing Dynamic SQL.e.g.,EXECUTE IMMEDIATE 'DELETE FROM dept WHERE deptno = :num' USING dept_id;
-
What is the diff between %Rowtype and %type?
manoj_lanser
- Jul 20th, 2011
%type is used when we have to define the datatype of a variable similar to another existing column data-type. eg- v_id employess.employee_id%type. In this example we have make a variable v_id similar...
Radha
- Jul 14th, 2011
We use %type and %rowtype in PL/SQL programming part. %Type: The variable will assign the datatype which contains in the column of that particular table we mentioned. Ex: v_eno employee.eno%type; ...
PL/SQL Interview Questions
Read Best Answer
Ans