Hi,
You can use
grant execute on procedurename to username
Try this one.
Thanks,
Mohan Reddy G
goudelly
Last Activity: Oct 25 '11, 04:02 AM
Joined: Sep 13 '06
Location: Bangalore
-
Hi,
The sql*loader is a utility you load the text,csv data into you oracle database.
The Ex :
emp.ctl (control file)
options(direct= true)
load data
infile 'd:\utl_dir\emp 2.txt'
badfile 'd:\utl_dir\emp .bad'
discardfile 'd:\utl_dir\emp .dsc'
into table emp
fields terminated by "|"
trailing nullcols
(empno,ename.., ...)
...Leave a comment:
-
Hi,
You can create the script in text editor : for ex: user.sql
create user abc identified by abc;
create user ijk identified by ikj;
create user lmn identified by lmn;
create user xyz identified by xyz;
In sql prompt :
@user.sql;
it will create the user one by one from the script.
Thanks,
Mohan Reddy...Leave a comment:
-
Hi,
In Win-XP you have to add the oracle and oracle.exe in below given sequence :
Where you Oracle is there in Win-XP system.
Network icon on status bar (right click)-->status-->properties-->advanced-->settings-->exceptions
addport -- (oracle and port is 1521)
addprog -- (c:\oracle\ora9 0\bin\oracle.ex e).
Now the oracle can acess your clients with Win-XP firewall...Leave a comment:
-
Hi,
Use the trigger.
CREATE OR REPLACE TRIGGER trg_emp_dob BEFORE INSERT OR UPDATE ON emp
BEGIN
IF :new.dob > SYSDATE THEN
RAISE_APPLICATI ON_ERROR (num => -20000, msg => 'DOB Cannot be in the future');
END IF;
END;
Thanks,
Mohan Reddy GLeave a comment:
-
Hi,
You have to use the pl/sql for that..
you have decalre the 2 cursors 1 for rows on table 2nd for no of columns on table then check each with cursor1 with cursor2 then you get the output.
Thanks,
Mohan Reddy GLeave a comment:
-
hI,
sys_context('US ERENV','CURRENT _SQL') FROM DUAL;
It will execute the query
Thanks,
Mohan Reddy GLeave a comment:
-
goudelly replied to URGENT- ORA-06502: PL/SQL: numeric or value error: character string buffer too smallin OracleHi,
What exatly doing in function. If the value or size of the filed length is small and you are try to insert the morethan the filed size..
Please check in you function.
Thanks,
Mohan ReddyLeave a comment:
-
Hi,
UTL_FILE is pl/sql packsge.
Eg:
Decalre
cursor c1 is select * from emp;
v_file utl_file.file_t ype;
begin
v_file := utl_file.fopen( 'c:\utl_dir','e mp.txt','w');
for r1 in c1 loop
utl_file.put_li ne(v_file,r1.em pid||'|'||r1.en ame||'|''sal||
end loop;
ult_file.fclose (v_file);
end;
Complie this and execute it..
...Leave a comment:
-
Hi,
What knid of mapping you want.. You want to send the client_id to function and get the all acctid's are what? Please give the details.
Thanks,
Mohan Reddy GLeave a comment:
-
hi,
You want to see the schema objects..
Select * from user_objects;
You can see all type of user objects.
Thanks,
Mohan Reddy GLeave a comment:
-
Hi,
Give the table details to me.
Thanks,
Mohan ReddyLeave a comment:
-
Hi,
Do you have any kind of backup with you can do it.. Like .DMP files are colod backup. or backup-archivelogs..
Based on your backup type weill give the solution to you..
Thanks,
Mohan ReddyLeave a comment:
No activity results to display
Leave a comment: