di oracle ada fungsi baru yang namanya dinamic sql. untuk cara pembuatane pakai
prosedure semisal begini
=============================
create or replace procedure coba_dynamicSQL(tabel in string) is
TYPE EmpCurTyp IS REF CURSOR;
cur EmpCurTyp;
vsql varchar(1000);
kode varchar(50);
begin
vsql:='select distinct kode_relasi from ' || tabel || '.Jurnal';
--dbms_output.put_line(vsql);
open cur for vsql;
LOOP
FETCH cur INTO kode;
EXIT WHEN cur%NOTFOUND;
dbms_output.put_line('Kode Relasi : '|| kode);
dbms_output.put_line(cur%rowcount);
end loop;
close cur;
end coba_dynamicSQL;
======================
cara exekusinya = exec coba_dynamicSQL('buku');
===============================
semoga bermanfaat
--- On Mon, 9/1/08, musisi musisi <[EMAIL PROTECTED]> wrote:
From: musisi musisi <[EMAIL PROTECTED]>
Subject: [indo-oracle] nama field sebagai parameter pencarian
To: "Indo oracle" <[email protected]>
Date: Monday, September 1, 2008, 6:42 AM
dear all,
saya minta bantuan nih.
saya ada table A1 dgn field spt ini :
...........
field1 varchar2(5) default '0'
field2 varchar2(5) default '0'
field3 varchar2(5) default '0'
...........
bagaimana caranya agar clausa where bisa dinamis.
misal suatu saat saya melakukan query :
select * from A1 where field1='0'
disaat yang lain melakukan query :
select * from A1 where field2='0'
bisa tidak ya, jika satu sintax query bisa untuk semuanya ( dengan parameter
where yang berubah-ubah )
select * from A1 where ????? = '0'
tolong pencerahannya.
Thx
____________ _________ _________ _________ _________ _________ _
Search, browse and book your hotels and flights through Yahoo! Travel.
http://sg.travel. yahoo.com
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
