Oracle General Interview Questions
Questions Answers Views Company eMail

what r routers?

1 3671

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

1 3038

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 9537

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 6310

Explain the family trees and connection by clause

1797

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

Secon,

2 4114

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 2950

What are main difference between Stored Procedure and Functions.

CA, Metric Stream,

6 24196

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

3 9193

what diffrence between function and procedure?

4 6432

Who i will insert 1 lacks record in a Database table

TCS,

4 11389

what is IDE,DMV in sql server?

2230

What is STATSPACK tool?

Wipro,

3 7809

what are the differen between key flexifild and discriptive fiexifild.

1 3175

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

2 5344


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How do I recompile a procedure in oracle?

514


Can a formula column referred to columns in higher group ?

2073


How a database is related to tablespaces?

566


Will you be able to store pictures in the database?

623


How to use "while" statements in oracle?

720






What is an oracle database?

602


What is an oracle user account?

558


How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

534


How to view all columns in an existing table?

540


What is concurrency in oracle?

530


What is the implicit cursor in oracle?

550


How to use in conditions in oracle?

537


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1792


What are the oracle built-in data types?

553


What is raw datatype?

581