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?
Maximum how many triggers can we use in trigger and How to find out how many records it fetched.
Differences between Oracle 9i and 10g (Probably in terms of
SQL and PL/SQL)?
in sql table follw columns r their
1234 |1FS |1-JAN|PUNE|
4561 |2FS |5-JAN|PUNE|
1234 |PS |7-JAN|PUNE|
1234 |PS |15-JAN|MUMB|
i want o/p below
PLS help me out to execute using sql query
when MSQL8.0 is in market
what is the difference between trigger and constraint?
how to delete duplicate rows from a join tables(I have three
tables on that join)
how do you know which join is need to be used?
The select statement I have is:
WHERE gc_area_tec.id_skill_type (+) =
AND gc_technology.id_area_tec (+) =
order by gc_skill_type.skill_type asc, gc_area_tec.area asc,
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 use of anchoring object? what r the difference
between anchoring object & enclosing object? can any one
tell me all the details?
Could you please provide oca (oracle 10g) dumps for my
what is the bond code in materialized view?
source destination distance
chennai bangalore 500
bangalore chennai 500
hyd delhi 1000
delhi hyd 1000
bangalore hyd 800
Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria.
Based on the distance i want to display only one row using sql query?
What is your daily office routine?
What is the use of time stamp in select statement?
Describe the Index, Types of index, At what situation we
have used? Which one s better than others?
a table has 2 classifications
this liabitity has 2 elements with 2 input values
the earnings have 2 elements with 2 input values
i wrote a query so that my input is
liability savings amount1 amount2
xxxx null xxxxxx 0
xxx1 null xxxxx1 0
null yyyy 0 yyyy
null yyy1 0 yyy1
my problem is
--when i developed a report(d2k) with this data
my o/p is
how could i move this savings,savings values 2 palces up.
can any body provide me witha better solution