I want to display the employees who have joined in last two
months. (It should be executed randomly means If I execute
the query in March it should display Jan and Feb joined
employees. Same query if i execute in Feb, 2007 it should
display dec, 2006 and jan 2007 joined employees.
How to retrieve Duplicate Rows only in a Table?
Suppose if a Table Name is "Education". It consists of
multiple columns. Then if we insert rows into this table
with duplicate records then how can we retrieve only
duplicate records from that table?
what is the difference between trigger and constraint?
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...
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.
Differences between Oracle 9i and 10g (Probably in terms of
SQL and PL/SQL)?
1. is it possible to use the cursor atttibutes (%found ,%
rowcount , %isopen , %notfound ) to our user defined cursor
cursor cursor_name is select * from scott.emp
if you use...
cursor_name%found , %rowcount ,%isopen,%notfound...will it
2.what is the difference between the varray and index by
type type_name is table of number(8,3)
index by binary_integer;
first , last , prior , next ,trim are the methods we can
use it for the above type...simillary is there any way to
apply for cursors...
with thanks and regards..sarao...
how will i became good database developer?
Describe the Index, Types of index, At what situation we
have used? Which one s better than others?
what is the difference difference between procedure and
What is the criteria while applying index to any column on
How do you use collections in procedure to return the
What packages(if any) has oracle provided for use by developers?
what is the use of anchoring object? what r the difference
between anchoring object & enclosing object? can any one
tell me all the details?
Are there any features that are decommissioned in 11g that are
not present in 11g?
What action do you have to perform before retrieving data
from the next result set of a stored procedure ?
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