Saya setuju dengan pak Yulius, tapi untuk referensi ini saya tuliskan script
yang dapat digunakan untuk DDl pada level Procedure di database
CREATE OR REPLACE PROCEDURE SQL_DDL(v_QRY Varchar2)
IS
cur BINARY_INTEGER := DBMS_SQL.OPEN_CURSOR;
fdbk BINARY_INTEGER;
BEGIN
DBMS_SQL.PARSE (cur,v_QRY,DBMS_SQL.NATIVE);
fdbk := DBMS_SQL.EXECUTE (cur);
DBMS_SQL.CLOSE_CURSOR (cur);
END;
Dengan script diatas anda tinggak memasukan v_Qry dengan DDL command
Contoh SQL_DDL('Alter table disable.....');
----- Original Message -----
From: Yulius Wibowo
To: [email protected]
Sent: 24 January 2006 2:24
Subject: [indo-oracle] Re: Form Dev 6.0
Setahu saya nggak bisa pada saat develop (pakai Form Builder),
Kecuali pada saat runtime,
dengan menggunakan FORMS_DDL('ALTER TABLE DISABLE CONSTRAINT ....');
Bowo
--- In [email protected], agus sulaiman <[EMAIL PROTECTED]>
wrote:
>
> Kepada Teman-teman semuanya,
>
>
> Ada yang saya ingin tanyakan bila kita ingin melakukan disable
atau enable
> sebuah constraint dari form builder caranya bagaimana ,
sebenarnya bisa dilakukan
> pada form developer atau tidak atau hanya dapat dilakukan pada
database oracle-nya? mungkin teman-teman telah pernah mengalami
sebelumya.
>
>
>
>
>
> Thanks.
> Agus S
>
>
>
>
> ---------------------------------
> Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, &
more on new and used cars.
>
> [Non-text portions of this message have been removed]
>
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
SPONSORED LINKS Membership database software Database mortgage software Pda
database software
Database management software Oracle database administration Oracle
database management
------------------------------------------------------------------------------
YAHOO! GROUPS LINKS
a.. Visit your group "indo-oracle" on the web.
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
------------------------------------------------------------------------------
------------------------------------------------------------------------------
===================================================
This Mail Scanned By Messaging Security Suite
================= Provided by IT Hardware =================
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
