hello friends Im doing my final year engineering in B.Tech..
one of uncle said he can provide job in his company if im
good in database management. but i have only basic knowledge
about database, so like to join database management course
in good intuition. so friends kindly help me to get good
intuition because its my future.
create or replace procedure show_tab_rec ( P_tab VARCHAR2 )
cmd := 'select *
from '|| P_tab;
for int in ( execute immediate cmd )
dbms_output.put_line ( int.ename||' '||int.deptno);
when i m compling this procedure i m getting this error
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting
of the following:
. ( ) , * @ % & | = - + < / > at in is mod remainder not
range rem => .. <an exponent (**)> <> or != or ~= >= <= <>
and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member
PLZ solve this error
give this question answer asap
I m giving Source, Destination and Age. Write a procedure or
function, it will give to u this source to destination
tickets are available or not, if available then check this
person is senior citizen or not,if this person is senior
citizen then give some discount.
PLZ give this answer......
How do u print the data horizantally by using XML report?
EX:Suppose there is one table names as SAMPLE in that we
have only two columns say empno,ename.I want the output
like this,At run time user may enter 3 colums(i.e to data
empno ename empno ename empno ename
100 aaa 101 bbb 102 ccc
103 ddd 104 eee 105 fff
You have 4 instances running on the same UNIX box. How can
you determine which shared memory and semaphores are
associated with which instance?
types of receipts and detail desription about recipts and
tables effected by receipts?
How to do performance tunning a database in DB2 V8.2 UDB
What is data modeling and Reterminal integrity?
We are using Oracle apps with XML publisher.In that,we are
facing some problems while giving a Footer in RTF
Template.While giving a footer in RTF Template it is
Visible in all the pages,but after the PDF is getiing
generated,the Footer are Visible on alternate pages only
(like on first page ,third page) and so on.
Please provide the Solution for getting the Footer on all
Hi all, can any one please tell me the difference between
sql server 2008 and orace 9i
I'm need to prepare Month Over Month Sales Growth report. Is
there any function available in OBIEE to perform this task.
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...