Oracle General Interview Questions
Questions Answers Views Company eMail

Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?

Oracle, SAH,

2 3746

what is the exact diiference between DBMS and RDBMS

Tesco,

4 6775

how to find full database size

BirlaSoft, Consultancy,

1 4854

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1764

how can we store any pdf file in oracle

1630

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

IBM, Wipro,

1 2259

Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks

IBM,

2 5257

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

IBM,

2 3036

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

IBM,

2 4013

what is main def between plsql/table and array?

Oracle,

1 3042

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

Microsoft,

2 5069

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

Microsoft,

4 6211

I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

Microsoft,

3 5228

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

Microsoft,

1569

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

Microsoft, Oracle, TCS,

5 7917


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is Library Cache in Oracle?

633


How can we create the complete backup of data in the oracle.

1676


How can we find out the current date and time in oracle?

634


How to declare a local variable?

585


Give the constructs of a package, function or a procedure.

527






What is ADDM Advisor in Oracle?

652


What is the usage of merge statement?

663


how do u setup a replication site?

1486


Explain the characteristics of oracle dba?

628


What happens to the current transaction if the session is killed?

527


How to create a table in a specific tablespace?

532


Can we convert a date to char in oracle and if so, what would be the syntax?

540


What to do if the binary spfile is wrong for the default instance?

553


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4003


What is a schema in oracle?

530