Please Help Members By Posting Answers For Below Questions
How do you use collections in procedure to return the
when MSQL8.0 is in market
if table named a is there
and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time
What will be the output of the following
String S = 1+2+"abc" S = ?
String S1 = 1+2+"abc"+5+6 S1 = ?
Difference between global and parameter variables?
what is indexing, searching and user interface?
What is extent clause in table space?
hi,i plan to put experience on PLSQL ,can anyone suggest me
for any institutes in bangalore or how to prepare for
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,
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????
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
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
How consistent is the view of the data between and within
multiple sessions, transactions or statements ?
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...