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?
i have some prob
lem to tell me about my self in interview first round ...
what is indexing, searching and user interface?
Are there any features that are decommissioned in 11g that are
not present in 11g?
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
what is the bond code in materialized view?
How well can multiple sessions access the same data
Differences between Oracle 9i and 10g (Probably in terms of
SQL and PL/SQL)?
What is Materialized View? In What Scenario we Use
What is your daily office routine?
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...
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...
when MSQL8.0 is in market
i have 2 table table one 4 columns respective values a1
7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values
a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same
then 4th column values 1)Qes diff >5 then print 5 * diff
value 2)Que diff <5 print 5
how will i became good database developer?
What packages(if any) has oracle provided for use by developers?