Please Help Members By Posting Answers For Below Questions
how will i became good database developer?
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
Could you please provide oca (oracle 10g) dumps for my
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...
in oracle 10g sw after compiling procedure how to pass
parameter values ,if we (v_empid out number)how to give
empid after successful compilation program.This site exact
suitable for 10g with respect to question & answer same
format , im trying sql browser & sql command prompt using
exec procedure name & respective parameters.
What is Materialized View? In What Scenario we Use
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
What is window clause?
What packages(if any) has oracle provided for use by developers?
What is extent clause in table space?
How global cursor can be declare with dynamic trigger ?
hi,i plan to put experience on PLSQL ,can anyone suggest me
for any institutes in bangalore or how to prepare for
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
firstname.lastname@example.org Or taking tanning on this
please do contact me
what is indexing, searching and user interface?
what is the use of anchoring object? what r the difference
between anchoring object & enclosing object? can any one
tell me all the details?