HI
in report builder am creating paramters.for that i have
taken emp table from scott user .
in deptnum am displaying distinct deptno.if i select dept
10 ,empnum drop down should display empno's of deptno 10.
.if i select dept 20 ,empnum drop down should display
empno's of deptno 20.for this wat i have to do.
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
why the Ctl file u put only in bin folder why not in other
folder
108
i wrote a pl/sql procedure. it must run every sunday 4.40
How can i schedule it with the help of dbms_jobs (or
another other procedure with out creating bat file,exe file)
i have a web page and in this page i create 3 textbax and a
"summit" button do you have any html code for add text velue
in my web page like link summation(form) sites.
112
please explain about oracle
6
did u p prepared complex report
108
what is partitioning? Types of partitioning. explain? what
is the new kind of partitioning type introduced in 9i?
102
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2
)
2 RETURN NUMBER AS
3 new_str VARCHAR2(4000) := factstr||'*' ;
4 fact number := 1 ;
5 BEGIN
6
7 WHILE new_str IS NOT NULL
8 LOOP
9 fact := fact *
TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1));
10 new_str := substr(
new_str,INSTR(new_str,'*')+1);
11 END LOOP;
12
13 RETURN fact;
14
15 END;
explanation Above program?
62
Give two examples of referential integrity constraints.
along with your userid / name. ThanQ
Site Map
