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
What action do you have to perform before retrieving data
from the next result set of a stored procedure ?
what is the difference difference between procedure and
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
Could you please provide oca (oracle 10g) dumps for my
What will be the output of the following
String S = 1+2+"abc" S = ?
String S1 = 1+2+"abc"+5+6 S1 = ?
Describe the Index, Types of index, At what situation we
have used? Which one s better than others?
i have some prob
lem to tell me about my self in interview first round ...
what is the bond code in materialized view?
what is single byte over head in oracle..?
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
What are code pages ?
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
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????