I have a procedure in a procedure. The inner procedure
contains out parameter. How I can call the inner procedure
in the out procedure and send the inner procedure parameter
value(out parameter value) into out procedure?
SELECT * FROM
(SELECT TITLE FROM MOVIE ORDER BY RANK DESC)
WHERE ROWNUM > 4;
when i run the above query .it produces output as NO ROWS
SELECTED.why ?plz any one help me
How would you determine the time zone under which a
database was operating?
11
WHAT IS CARDINALITIES OF JOIN?
132
in user parameter property we have list of values.can we
write select query for binding?
for example::
select empno from emp where deptno=:deptnum
:deptnum is first parameter it displays distinct dept nos.
if i do like this it is giving error::
bind variables are not allowed in the select statement
34
what are the advantages of running a database in NO archive
log mode?
2
What is the difference between referencing and joining?
79
Hi ,
any one can help me on the same,this is regarding the
Informatica Function doc,i want to know how developer is
will develop the mapping. pl forwar the any function
doc .just for my references.
svlc75@yahoo.co.in
in after report trigger if you don't write
Srw.user_exit(Fnd_user exit) what it will do it will stop
report execution or it will just not free the memory
27
what is meant by magic query
16
can any one please send sql quries most used in applications.
9
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
8
Which types of backups you can take in Oracle?
2. A database is running in NOARCHIVELOG mode then which
type of backups you can take?
3. Can you take partial backups if the Database is running
in NOARCHIVELOG mode?
16
i made a table whih contain a column "Photo" with image
data type and i want to insert the byte of a picture
present in my hardisk using insert statement in that
colum... so what will be my insert statement?
35
If a parameter is used in a query without being previously
defined, what diff. exist betw. report 2.0 and 2.5 when the
query is applied ?
HI
THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY
SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS
POSSIBLE BY USING DATASTAGE7.5.
5
What are the disadvantages of cursors? How can you avoid
cursors?
233
can i use the commands "modify" and Change in DB2 to alter
my column datatype and its name in a table?
47
explain about the critical recovery scenario you had
experienced
54
1.what is the diff between nolock optimizer and read
uncommitted
isolation?
2.what is the diff between revoke and deny?
3.what is percieved down time?
4.whether password protection are required for backups?if
yes why?if no why?
5.what is fill factor?
6.what is cost analysis?
7.what is mean by piece meal restore?
8.what is 'rowguidcol'?
9.impersonate permission?
10.what is selectivity?
along with your userid / name. ThanQ
Site Map