Setahu saya sih kalo utk query langsung ga bisa. Palingan perlu bantuan pake
function / procedure
Kira2 gini nih contohnya :
PROCEDURE xxx(abc in varchar2) IS
query_str VARCHAR2(4000);
BEGIN
query_str := 'SELECT field1, field2 '||
'FROM A1, A2 '||
'WHERE A1.id = A2.id ';
query_str := query_str ||
'AND EXISTS (SELECT ''e'' from A1 '||
'WHERE A1.code = '''||abc||''' '||
'AND ij.object_version_number <> j.object_version_number) ';
OPEN p_cursor FOR query_str ;
Semoga dapat membantu...
CMIIW,
eldin
To: [email protected]
From: [EMAIL PROTECTED]
Date: Mon, 1 Sep 2008 14:42:40 +0800
Subject: [indo-oracle] nama field sebagai parameter pencarian
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]
_________________________________________________________________
Manage multiple email accounts with Windows Live Mail effortlessly.
http://www.get.live.com/wl/all
[Non-text portions of this message have been removed]
