How can we see a query which is behind a view and can we access a table which is residing in other schema with out using a synonym ,if yes how?

  • Interview Candidate
  • 3
  • 10735

Showing Answers 1 - 3 of 3 Answers

Dinesh Kumar Kalva

  • Jan 6th, 2006
 

you can see view definition using below query

select TEXT from all_views where view_name like upper('ap_invoices')

For 2nd point

yes, we can access different schema using schema name as a prefix. But there must be grants on that objects to schema

  Was this answer useful?  Yes

Denzy

  • Feb 13th, 2006
 

set heading off

set echo off

Set pages 999

set long 90000

spool C:\TEMP\create_script.sql

select dbms_metadata.get_ddl('VIEW','AP_INVOICES','APPS') from dual;

spool off

  Was this answer useful?  Yes

Nitin Motghare

  • Sep 26th, 2006
 

Hi,

I Struck up with API used to Create a Value Sets Runtimely.

Can u Help Me to know the name of API to Create a values Set Runtimely in Oracle Apps

Thanks

Nitin

9823564113

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions