Answered Questions

  • How to retrieve data using view?

    shwetac

    • May 2nd, 2007

    In Oracle Apps, to get data from views we have to set the org id for the application so that we can fetch relevant data. This can be done using the following block : beginfnd_client_info.set_org_context( ) ;end;

    ratnakar

    • Jan 24th, 2007

    View is a virtual table we can create view by using following query Create view view_name as select * from table_namewe can select data from view by using following query.select * from view...