Search:

Type: Posts; User: smitai; Keyword(s):

Search: Search took 0.02 seconds.

  1. Thread: Copy Table

    by smitai
    Answers
    6
    Views
    1,970

    Oracle Re: Copy Table

    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...
  2. Thread: Copy Table

    by smitai
    Answers
    6
    Views
    1,970

    Oracle Re: Copy Table

    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...
  3. SQL Server - Oracle Inbuild function to create INSERT script ?

    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...
  4. Answers
    7
    Views
    6,824

    SQL Server - Re: Lock Table in Sql Server2000

    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:...
  5. Answers
    5
    Views
    6,233

    Oracle Re: composite data type

    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...
  6. Answers
    10
    Views
    6,754

    Re: help handling error with trigger

    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...
  7. Answers
    10
    Views
    6,754

    Re: help handling error with trigger

    THANKS...
    But can u please edit my prog trig and let me know how can i do it .
    I think it not working...:p
  8. Answers
    10
    Views
    6,754

    Re: help handling error with trigger

    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...
  9. Answers
    12
    Views
    6,311

    Re: can i get answer for this

    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...
  10. Answers
    10
    Views
    6,754

    help handling error with trigger

    :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...
  11. Answers
    4
    Views
    6,898

    difference bet unique and distinct

    :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:
  12. Answers
    2
    Views
    2,283

    Re: dba or developer

    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
  13. Answers
    6
    Views
    6,823

    Re: can i get answer for this

    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...
  14. Thread: pl/sql function

    by smitai
    Answers
    4
    Views
    2,975

    Re: pl/sql function

    2,3 are right answers
  15. Thread: privilege

    by smitai
    Answers
    5
    Views
    2,066

    Re: privilege

    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.
  16. Answers
    12
    Views
    6,311

    Re: can i get answer for this

    answer 2,3,4 are true
  17. Answers
    52
    Views
    96,905

    Re: OCA certification

    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...
Results 1 to 17 of 17
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact