there are 2 variables called x and y ,x contains 1,2 and y
contains 3,4 we have to swap the values from x to y and y
to x with out using dummy variables and it can be done only
by using a single statement ? how?
What packages(if any) has oracle provided for use by developers?
Describe the Index, Types of index, At what situation we
have used? Which one s better than others?
1. is it possible to use the cursor atttibutes (%found ,%
rowcount , %isopen , %notfound ) to our user defined cursor
cursor cursor_name is select * from scott.emp
if you use...
cursor_name%found , %rowcount ,%isopen,%notfound...will it
2.what is the difference between the varray and index by
type type_name is table of number(8,3)
index by binary_integer;
first , last , prior , next ,trim are the methods we can
use it for the above type...simillary is there any way to
apply for cursors...
with thanks and regards..sarao...
what is the bond code in materialized view?
What action do you have to perform before retrieving data
from the next result set of a stored procedure ?
what is indexing, searching and user interface?
What is the use of time stamp in select statement?
How do you use collections in procedure to return the
which will default fire first
statement level trigger or row level trigger
What is Materialized View? In What Scenario we Use
Could you please provide oca (oracle 10g) dumps for my
write a query that returns first characters of each word in
Oracel/Sql pl sql
What is window clause?
what is the difference difference between procedure and