Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Oracle General Interview Questions
Questions Answers Views Company eMail

what r routers?

1 3022

after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble

1 2413

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

AppLabs,

2 8580

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

Philips,

2 5382

Explain the family trees and connection by clause

1394

can a table has a column that has only view data and in other columns we can change data?

Secon,

2 3252

consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 2396

What are main difference between Stored Procedure and Functions.

CA, Metric Stream,

6 22405

HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?

3 7827

what diffrence between function and procedure?

4 5155

Who i will insert 1 lacks record in a Database table

TCS,

4 9755

what is IDE,DMV in sql server?

1711

What is STATSPACK tool?

Wipro,

3 6576

what are the differen between key flexifild and discriptive fiexifild.

1 2510

Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.

2 4506


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

how to clone 9i Database on to 10g Database.

1341


Where are the settings stored for each instance in oracle?

138


Can a parameter be passed to a cursor?

145


What do you mean by a tablespace?

139


Compare and contrast between sql and sql server and explain its various functions?

137






What is rowid and rownum in oracle?

118


What language does oracle use?

109


What is difference between cartesian join and cross join?

142


What are the ways tablespaces can be managed and how do they differ?

1069


What are internal user account in oracle?

160


What are the attributes that are found in a cursor?

166


Explain the characteristics of oracle dba?

191


How to define an anonymous block?

147


What is the max number of columns in an oracle table?

114


Is it possible to insert comments into sql statements return in the data model editor ?

1542