Dear Shahid.
Yes product_user_profile will disable commands used in sql*plus.
i tried, it worked. Thanks to the guy who gave the clue
insert into PRODUCT_USER_PROFILE (product,userid,attribute,char_value)
values('SQL*PLUS','TEST','SELECT','DISABLED')
Ramana
- Original Message
try this..
SELECT DISTINCT AA FROM AA A WHERE STATUS='F' AND
AA IN (SELECT AA FROM AA B WHERE A.AA=B.AA AND STATUS 'F'
GROUP BY B.AA HAVING COUNT(B.AA) 1)
Ramana
--- Leslie Lu [EMAIL PROTECTED] wrote:
Just to clearfy my previous question (as follow):
if 1 has F and A and B, that what
hi bunyamin
you have forgot to open the cusror before the start of the programme.
excute the dbms_sql.open_cursor function to get the curosr id.
cursor_name:=dbms_sql.open_cursor;
Venkata Ramana
Sierra Optima Limited,
SVR Towers, 8-2-1/B/1, Panjagutta,
Hyderabad 500082, India.
Ph: (91-40
...
Venkata Ramana
Sierra Optima Limited,
SVR Towers, 8-2-1/B/1, Panjagutta,
Hyderabad 500082, India.
Ph: (91-40) - 3730321, 3746122, 3745051 Ext: 228,219
Fax:(91-40) - 3746419.
Email : [EMAIL PROTECTED]
--
From: Venkata Ramana Kanchinadam
Reply To: [EMAIL PROTECTED
hi sharma
The builtin packages UTL_SMTP and UTL_TCP are available with oracle 8.1.5
onwards , thats the reason you were getting compilation errors.
Ramana
--
From: Saurabh Sharma[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, May 25, 2001 12:40