i have one table with accounts and amounts as
colums.accounts with columns c and d. and amounts with
values 1000,2000,3000 for c and 4000,5000,8000 for d.i need
to find the sum of these accounts c and d individually
and find the differences between their sum using one select
How do you use collections in procedure to return the
write a query that returns first characters of each word in
Oracel/Sql pl sql
Table 1: col1 Timestamp
Table 2: col2 Timestamp
Write a query to display a row with table2 col2 value less
than tabl1 col1 value. Maximum timestamp value previous to
table1 col1 value.
Display a result as:
01-mar-2012 11:12:46 01-mar-2012 11:12:10
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
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 will i became good database developer?
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 well can multiple sessions access the same data
what is the bond code in materialized view?
hi,i plan to put experience on PLSQL ,can anyone suggest me
for any institutes in bangalore or how to prepare for
How global cursor can be declare with dynamic trigger ?
What is window clause?
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 will be the output of the following
String S = 1+2+"abc" S = ?
String S1 = 1+2+"abc"+5+6 S1 = ?