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?
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
How do you use collections in procedure to return the
how will i became good database developer?
i have some prob
lem to tell me about my self in interview first round ...
how to find the First and Last Observation from the table:
Ex: OBS Name Sal Ans like: OBS Name Sal
105 E 5000--> 105 E 5000
102 B 2000 104 D 4000
103 C 3000
101 A 1000-->
104 D 4000
Are there any features that are decommissioned in 11g that are
not present in 11g?
What will be the output of the following
String S = 1+2+"abc" S = ?
String S1 = 1+2+"abc"+5+6 S1 = ?
ERROR:Insert or update on table"accnt" violates foreign key
present in the table "curr_symbol" ......solve The Problem..
What are wait events. Describe the wait event tables.
i am an comp science engineering graduate planning to do
ORACLE certification in PLSQL 9i. just wanted to know whats
the possibility getting job is their openings???? is it
worth doin that course n certification
How global cursor can be declare with dynamic trigger ?
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