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?
GLOBAL TEMPORARY TABLE over Views in advantages insolving
Could you please provide oca (oracle 10g) dumps for my
Hi am new to PLSQL & facing problems in writing code like in
SP, Functions, so any one having some SP coding with in
depth explanation please share with me my Email ID
email@example.com Or taking tanning on this
please do contact me
write a query that returns first characters of each word in
Oracel/Sql pl sql
Write a query to genarate target column.Please answer me.
Q10 Quarter to 2010
Q90 Quarter to 1990
Q80 Quarter to 1980
Q74 Quarter to 1974
If i can use sys.check_constraints to display my constraints
from my database using sql server 2005, how can i display
then if i am using sql server 2000????
How global cursor can be declare with dynamic trigger ?
what is the difference between varray and table data
type..please expalain with some examples...
under what situation you will go for varray..instead of
index by table...
Maximum how many triggers can we use in trigger and How to find out how many records it fetched.
column A column b | output
10 7 | 10
5 8 | 8
7 -9 | 7
3 5 | 5
0 6 | 6
Write a sql query to print such output.
What packages(if any) has oracle provided for use by developers?
What are code pages ?
How consistent is the view of the data between and within
multiple sessions, transactions or statements ?
in oracle 10g sw after compiling procedure how to pass
parameter values ,if we (v_empid out number)how to give
empid after successful compilation program.This site exact
suitable for 10g with respect to question & answer same
format , im trying sql browser & sql command prompt using
exec procedure name & respective parameters.