Search found 18 matches
- Tue May 26, 2009 1:25 am
- Forum: Oracle Databases
- Topic: How to use UTL_FILE
- Replies: 1
- Views: 3115
- Thu Apr 09, 2009 3:26 am
- Forum: Oracle Forms & Reports
- Topic: Create Textbox on Runtime
- Replies: 1
- Views: 1755
Create Textbox on Runtime
How to create textbox or any other control on runtime(Form Builder 6i).
Regards
Haseeb
Regards
Haseeb
- Mon Mar 16, 2009 3:28 am
- Forum: Oracle Databases
- Topic: COPY COMMAND
- Replies: 2
- Views: 3601
CREATE OR REPLACE PROCEDURE COPY_EMP as job_no number; BEGIN dbms_job.submit(job_no,'copy from scott/tiger[@]orcl replace emp using select * from emp;', SYSDATE,'SYSDATE+(60/(24*60*60))'); COMMIT; END; The above procedure created without any error. But it does'nt execute. Kindly guide me ASAP. Regar...
- Thu Mar 12, 2009 3:16 am
- Forum: Oracle Databases
- Topic: COPY COMMAND
- Replies: 2
- Views: 3601
COPY COMMAND
how to use copy command in strored procedure.
<b>copy from scott/tiger[[@]]orcl replace emp using select * from emp</b>
Kindly reply me ASAP
Regards
Haseeb
<b>copy from scott/tiger[[@]]orcl replace emp using select * from emp</b>
Kindly reply me ASAP
Regards
Haseeb
- Tue Feb 17, 2009 4:00 am
- Forum: Oracle Databases
- Topic: Materialized View
- Replies: 0
- Views: 2786
Materialized View
CREATE MATERIALIZED VIEW MV_SALE_TERR_WISE AS (Select Team_ID,Team_Name,ZonalCode,RegionalCode,TERRCODE,P_No,Assc_Name,Idate,PordId, ProdDesc,ProductID,Product, Sum(NVL(RUnits,0))+Sum(NVL(FUnits,0)) RUnits,Sum(NVL(WUnits,0)) WUnits,Sum(NVL(CUnits,0)) CUnits, Sum(NVL(IUnits,0)) IUnits, (Sum(NVL(RUnit...
- Mon Jan 26, 2009 2:30 am
- Forum: Oracle Forms & Reports
- Topic: how to create CheckBox
- Replies: 1
- Views: 8039
how to create CheckBox
Kindly define me how to create checkbox programatically on form 6i.
how to set label of checkbox according to database values.
Regards
how to set label of checkbox according to database values.
Regards
- Tue Jan 06, 2009 6:43 am
- Forum: Oracle Forms & Reports
- Topic: System date automatically come in date column
- Replies: 1
- Views: 1388
- Tue Jan 06, 2009 6:40 am
- Forum: Oracle Forms & Reports
- Topic: Round (Numbers) Function
- Replies: 1
- Views: 1313
- Wed Dec 17, 2008 1:29 am
- Forum: Oracle Forms & Reports
- Topic: Can't set ENABLED attribute of non displayed item
- Replies: 1
- Views: 7440
- Fri Nov 28, 2008 7:23 am
- Forum: Oracle Forms & Reports
- Topic: Run PowerPoint Slide From Form Builder 6i
- Replies: 0
- Views: 1288
Run PowerPoint Slide From Form Builder 6i
Define me the step, through which we will run powerpoint slide on button click in runtime.
Best Regards
Best Regards
- Fri Nov 21, 2008 12:47 am
- Forum: Oracle Databases
- Topic: Unlock default users from SQL Plus environment
- Replies: 1
- Views: 2310
- Thu Nov 20, 2008 8:01 am
- Forum: Oracle Databases
- Topic: Oracle Database Run Without Installation
- Replies: 1
- Views: 1830
Oracle Database Run Without Installation
<b>If it is possible to run oracle database on windows operating system ,without installation of oracle .
Kindly reply if possible or not.
Regards</b>
Kindly reply if possible or not.
Regards</b>
- Mon Nov 17, 2008 4:18 am
- Forum: Oracle Databases
- Topic: Spool Command in Loop
- Replies: 2
- Views: 1745
CONNECT SCOTT/TIGER@ORCL CREATE OR REPLACE DIRECTORY HASEEB AS '\\khisorasql10\ETMS1\SECURITY\HASEEB'; CREATE OR REPLACE PROCEDURE test_M AS v_output_file1 utl_file.file_type; BEGIN FOR FIRST_LOOP IN (SELECT EMPNO,ENAME,SAL,DEPTNO FROM EMP) LOOP v_output_file1 := utl_file.fopen('HASEEB', FIRST_LOOP....
- Fri Nov 14, 2008 4:23 am
- Forum: Oracle Databases
- Topic: Spool Command in Loop
- Replies: 2
- Views: 1745
- Thu Nov 13, 2008 2:44 am
- Forum: Oracle Databases
- Topic: Spool Command in Loop
- Replies: 2
- Views: 1745
Spool Command in Loop
How we use spool command with particular path in Cursor or Loop
Kindly reply ASAP
Kindly reply ASAP