definition of cluster and non-clustered index?
No Answer is Posted For this Question
Be the First to Post Answer
What are operators in oracle?
what is the use of rank function?
How to create a new tablespace in oracle?
What is tns service name?
How can you Enforce Referential Integrity in snapshots ?
What is a cursor variable?
What is the difference between a vector and an Array? (Java)
What is RULE-based approach to optimization ?
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.
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is the data type of dual table?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?