Answer Posted / kamala k n
view is virtual table and index is created on table columns which is performance the query
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How data locks are respected in oracle?
Explain a segment?
How to insert multiple rows with one insert statement in oracle?
How to create additional tablespaces for an new database?
How to find out what oracle odbc drivers are installed?
How can I combine multiple rows into a comma-delimited list in oracle?
What is the difference between translate and replace?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What are the set operators union, union all, minus & intersect meant to do?
What is transport network substrate (tns) in oracle?
How to connect ms access to oracle servers?
What are the uses of linked server and explain it in detail?
How to execute a stored program unit?
How to store only time; not date and time?
What is the difference between PFILE and SPFILE in Oracle?