ERPstuff - Oracle EBS Community

How to create textbox or any other control on runtime(Form Builder 6i).

Regards
Haseeb

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...

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

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...

Kindly define me how to create checkbox programatically on form 6i.

how to set label of checkbox according to database values.


Regards

create trigger When New Record Instance

ateTextbox:=sysdate;

OR

select sysdate into ateTextbox from dual;

Simply type this in sql enviroment


<b>set numformat 9999.99</b>

Kindly Use This Code:

SET_ITEM_PROPERTY('B1',ENABLED,PROPERTY_FALSE);

Make sure when form run ,B1 is not a current item.

B1 is a button Name:

Regards

Define me the step, through which we will run powerpoint slide on button click in runtime.


Best Regards

Connect System/*******

alter user scott account unlock


Regards

<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>

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....

<b>Kindly make this spool command into LOOP</b>



set feed off markup html on spool on
spool excelfile.xls
select * from your_table;
spool off
set markup html off spool off


Kindly reply me it's help ful or not
Regards

How we use spool command with particular path in Cursor or Loop


Kindly reply ASAP