Submitted Questions

  • How do you set table for read only access ?

    if i am updating one record in a table at that time no other user can't able insert ,update the record in same table How is it possible

    Aditya

    • Feb 28th, 2018

    Lock table < table name > in exclusive mode;

    Smruti R Das

    • Sep 26th, 2012

    GRANT SELECT ON table_name TO user_name

  • Force View

    What is Force View. Why Oracle Give Facility to create force view? What is the use of force View

    sonam kanungo

    • Oct 15th, 2011

    As per my knowledge when view is created without base table.then the view is called as forced view.

    in this type of view is created with compilation error.

    mohan

    • Oct 14th, 2011

    If we create a view without having base table, that view called as forced view. it will create with compile error. it will be in invalid till base table create.