How would you extract DDL of a table without using a GUI tool?
Answer / shafi.oracledba
to extract the ddl statement use the alter command to extract
Is This Answer Correct ? | 0 Yes | 1 No |
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.
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to divide query output into groups in oracle?
How to execute a stored procedure in oracle?
What is a database table in oracle?
How to get execution statistics reports on query statements?
What is the relationship among database, tablespace and data file?
What are the differences between char and nchar in oracle?
What is user managed backup in Oracle?
Explain view?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What are synonyms used for ?