What are inner join and outer join?3 9078
what are indexes..how many types of index's are there and what are they?7 12871
What are the components of Physical database structure of Oracle Database?4 8788
What are the components of Logical database structure of ORACLE database?4 10689
What is a Tablespace?5 5531
What is SYSTEM tablespace and When is it Created?2 4891
Explain the relationship among Database, Tablespace and Data file?4 8352
What are a cluster and non-cluster index?
What is a relational database management system?
Differentiate between post-database commit and post-form commit?
What is a read only transaction in oracle?
What happens to the current transaction if the session is killed?
Who developed oracle & when?
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 do you mean by cdb and pdb in oracle 12c?
How a tablespace is related to data files?
Please explain oracle data types with examples?
What is system global area (sga) in oracle?
Is postgres faster than oracle?
What is the oracle implicit cursor?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to save query output to a local file?