What are inner join and outer join?3 8763
what are indexes..how many types of index's are there and what are they?7 12377
What are the components of Physical database structure of Oracle Database?4 8465
What are the components of Logical database structure of ORACLE database?4 10344
What is a Tablespace?5 5251
What is SYSTEM tablespace and When is it Created?2 4714
Explain the relationship among Database, Tablespace and Data file?4 7924
how to clone 9i Database on to 10g Database.
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Which environment variables are absolutely critical in order to run the OUI?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
WHAT IS ecc 6.0
if you ctreate table identity
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.
Hi Can any one tell me what are the API's used in requisition import.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
what's query optimization and without use of IN AND Exist can we get another way data from query
1) Does oracle have any table which contain all the exceptions and it's code internally?
How can we create the complete backup of data in the oracle.
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is snapshot is too old? Give and example for better understand.