begin htp.p('Content-type: text/csv'); htp.p('Content-disposition: attachment;filename=ledger.csv'); owa_util.http_header_close; htp.p('"Emp No","Emp Name"'); for i in ( select empno, ename from emp) loop htp.p('"'||i.empno||'","'||i.ename||'"'); end loop; end;
select .....
from ......
where
..... önceki koşullarınız.....
and
(
:P1_MY_SHUTTLE is not null and
(instr(':'||:P1_MY_SHUTTLE ||':',':'|| f.component_id||':',1) > 0 )
)
HTML Form Element Attributes: style="width:250px" select group_id,
listagg(name, ',') within group (order by name) as names
from demotable
group by group_id
group_id names
-------- -----
1 'Alan, David, David, John'
2 'Charles, Julie'
select group_id,
regexp_replace(
listagg(name, ',') within group (order by name)
,'([^,]+)(,\1)+', '\1')
from demotable
group by group_id;
group_id names
-------- -----
1 'Alan, David, John'
2 'Charles, Julie'
DECLARE
BEGIN
/* Open up a cursor for loop, also selecting
* the "p" function which will write rows to
* t2 for every row fetched from t1. */
FOR crec IN (SELECT tcol, p(tcol) FROM t1) LOOP
-- Break out of the loop immediately
EXIT;
END LOOP;
END;
SQL> with t as (select 'abcd,123,defoifcd,87765' as str from dual)
select level as n, regexp_substr(str,'[^,]+',1,level) as val
from t
connect by regexp_substr(str,'[^,]+',1,level) is not null ;
N VAL
---------- ------------------------------
1 abcd
2 123
3 defoifcd
4 87765
SQL>
select
deptno,
listagg (ename, ',')
WITHIN GROUP
(ORDER BY ename) enames
FROM
emp
GROUP BY
deptno
/
DEPTNO ENAMES
---------- --------------------------------------------------
10 CLARK,KING,MILLER
20 ADAMS,FORD,JONES,SCOTT,SMITH
30 ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARD
SQL> set echo on
SQL> SPOOL test.log
SQL> select 1 from dual;
1
----------
1
SQL>
-bash-3.2$ cat test.log
SQL> select 1 from dual;
1
----------
1
SQL>
SQL>
SQL> exit
-bash-3.2$
CREATE OR REPLACE PROCEDURE test1 (name_array IN owa.vc_arr,
value_array IN owa.vc_arr)IS
i INTEGER;BEGIN
FOR i IN 1 .. name_array.COUNT
LOOP
htp.p('name_array ' || to_char(i) || '=' || name_array(i) || ' -- value_array ' || to_char(i) || '=' || value_array(i));
END LOOP;END;
Prosedürümüze aşağıdaki gibi yetki veriyoruz.
GRANT EXECUTE ON test1 TO PUBLIC
CREATE OR REPLACE FUNCTION APEX_040200.wwv_flow_epg_include_mod_local(
procedure_name IN VARCHAR2)RETURN booleanIS
BEGIN
--return false; -- remove this statement when you modify this function BU SATIRI CALISMAZ HALE GETIRDIM
--
-- Administrator note: the procedure_name input parameter may be in the format:
--
-- procedure
-- schema.procedure
-- package.procedure
-- schema.package.procedure
--
-- If the expected input parameter is a procedure name only, the IN list code shown below
-- can be modified to itemize the expected procedure names. Otherwise you must parse the
-- procedure_name parameter and replace the simple code below with code that will evaluate
-- all of the cases listed above.
--
--PROCEDURE ISMINI BURAYA EKLIYORUZ
IF UPPER(procedure_name) IN (
'TEST1') THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;END wwv_flow_epg_include_mod_local;
$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 3 11:21:39 2013Copyright (c) 1982, 2011, Oracle. All rights reserved.SQL> @apexins.sql APEX APEX TEMP /i/
Benim makinemde komutun tamamlanması 16 dk. sürdü.Sonrasında “APEX_040200″ kullanıcısının oluştuğunu görebilirsiniz.
$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 3 11:21:39 2013Copyright (c) 1982, 2011, Oracle. All rights reserved.SQL> select status from dba_registry where comp_id='APEX';STATUS-------------------------------------------------------VALIDDECLAREACL_PATH VARCHAR2(4000);BEGIN-- Look for the ACL currently assigned to '*' and give APEX_040200-- the "connect" privilege if APEX_040200 does not have the privilege yet.SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLSWHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_040200','connect') IS NULL THENDBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,'APEX_040200', TRUE, 'connect');END IF;EXCEPTION-- When no ACL has been assigned to '*'.WHEN NO_DATA_FOUND THENDBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml','ACL that lets power users to connect to everywhere','APEX_040200', TRUE, 'connect');DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');END;/COMMIT;