What is Segment Advisor in Oracle?
what is normalisation?what are its uses?
Explain what are the different type of segments?
difference between truncate and delete ,drop?
how to hide the stored procedure inside a package
What are the differences between char and varchar2 in oracle?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
how to truncate date and get only time part 9:20:00
How do I find the database name in oracle?
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?
What is a dynamic performance view in oracle?
how the indexes are stored in the Oracle Database?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?