What are inner join and outer join?3 8524
what are indexes..how many types of index's are there and what are they?7 12006
What are the components of Physical database structure of Oracle Database?4 8242
What are the components of Logical database structure of ORACLE database?4 10096
What is a Tablespace?5 5078
What is SYSTEM tablespace and When is it Created?2 4616
Explain the relationship among Database, Tablespace and Data file?4 7594
types of indexes and the rationale behind choosing a particular index for a situation.
What would you do with an in-doubt distributed transaction?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
if you ctreate table identity
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ firstname.lastname@example.org thanks Arun
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
can u send the sql dumps to email@example.com plz help me
how do u setup a replication site?