Title: Help on query
Dear gurus,
I have a table :
Tabel Exam
STD_NO SUBJECT POINT
== === =
001 CHEM A
001 PHYSIC A
001 BIOLOGY A
002 CHEM A
002 PHYSIC B
002 BIOLOGY A
003 CHEM A
003 PHYSIC A
003 BIOLOGY B
What is the SQL query to retrieve STD_NO which have CHEM = A and
Title: Help on query
Dear gurus,
I have a table :
Tabel Exam
STD_NO SUBJECT POINT
== === =
001 CHEM A
001 PHYSIC A
001 BIOLOGY A
002 CHEM A
002 PHYSIC B
002 BIOLOGY A
003 CHEM A
003 PHYSIC A
003 BIOLOGY B
What is the SQL query to retrieve STD_NO which have CHEM = A and
Title: Build my own aggregate function
Dear gurus,
How to build a function that work like aggregate function(SUM,COUNT,..).
TIA,
Ahmadsyah Alghozi Nugroho
Database Engineering Specialist
PT Infoglobal AutOptima
Jl. Baruk Tengah I/49
Surabaya - Jawa Timur
phone : +62 (31) 8708456 ext.113
Title: User-define Aggregate Function
Dear Gurus,
Can I build user define aggregate function, like Sum,count,etc..
TIA,
Ahmadsyah Alghozi Nugroho
Database Engineering Specialist
PT Infoglobal AutOptima
Jl. Baruk Tengah I/49
Surabaya - Jawa Timur
Indonesia
phone : +62 (31) 8708456 ext.113
Title: How to make DBA cannot 'see' User's Tables?
Dear gurus,
How to make DBA cannot 'see' user's datas?
I build an application which very important and top secret even DBA cannot 'see' this data. But DBA can backup this data.What is the solution for this problem?
TIA,
Ahmadsyah Alghozi
Title: RE: How to make DBA cannot 'see' User's Tables?
I'm using Oracle 8.1.7.
there was an error
ERROR at line 1:
ORA-28232: invalid input length for obfuscation toolkit
ORA-06512: at SYS.DBMS_OBFUSCATION_TOOLKIT_FFI, line 0
ORA-06512: at SYS.DBMS_OBFUSCATION_TOOLKIT, line 33
ORA-06512: at