NO same database with different user.
i.e
copy from user1@database1 to user2@database1
n if table name is tab1 in user1@database1 user/schema then queries will
grant select on tab1 to...
Type: Posts; User: smitai; Keyword(s):
NO same database with different user.
i.e
copy from user1@database1 to user2@database1
n if table name is tab1 in user1@database1 user/schema then queries will
grant select on tab1 to...
No it wont work cause 2 different users even if same database, it wont work.
For this user2 should give select privilege to user1 on this table.
So above suggesion may work plaese try out this...
Hi, i need a function in which i ll pass (table_name,col_wanted,col_unwanted) and this function will create a insert scripts for that tables having columns which is passed as col_wanted for all data...
Hi Mahesh ,
For ur problem i suggest you to try with "for update nowait" clause.
For more information please visit http://www.dbmotive.com/oracle_error_codes.php?errcode=00054
:) ORA-00054:...
Hi,
in pl/sql we have two types of datatypes
1. scalar
2. composite.
In scalar u can store only one value at a time and
ex is a number(10),name char(1) etc.
WHile in Composite u can store...
Hiiiiiiii
Raghav
Thanks for trying my question......
Can you tell me
this stack error like ora-06512 must be store somewhere ,in a table or any dictionary,view after getting raise .
we can take...
THANKS...
But can u please edit my prog trig and let me know how can i do it .
I think it not working...:p
Hiiiiiii
Thanks..
u know what it is possible in java to hide some error so i think there must b some way to hide this in oracle also ...
bcos it is not user friendly and unwanted thing for client...
Hellllllllllll0
again.
If 4 is correct then 3 must be correct and if 3 is correct then which data dictionary?
Bcos USER_OBJECTS is data dictionary maintained by oracle itself always...
so 2 is...
:confused:
dear one,
create table smita(n number,name varchar2(30));
insert into smita values(1,'iii');
insert into smita values(2,'iii');
insert into smita values(3,'iii');
insert into...
:mad: :mad: Is threre any difference bet 'disinct' and 'unique' key word used in select clause
ex
select disinct(column_name) from table_name;
select unique(column_name) from table_name;:rolleyes:
The great combination is
OCA(sql,pl/sql-II exams)+dba III exams
or
OCA(sql,funda1)+ocp
i dont think that ,it is must to do frontend forms for dba people, no use
ddl trig can fire on following objects only
clustr,function,index,package,procedure,role,sequence,synonym,table,tablespace,trigger,type,view,user
so the choices r first five are right so if u...
2,3 are right answers
i st option is right
if u want that procedure should execute under user priv instead of ur privs u should include a keyword 'authid current_user' in create pocedure.
answer 2,3,4 are true
visit oracle authorised center which will conduct oca exam.
i did my oca so telling u two institute in pune
1. sqlstarplus
2. dsk infotek
1st floor
gandharve hights,
near rahul...