Oracle General Interview Questions
Questions Answers Views Company eMail

Find all employees in Dept “Marketing”.

2 3922

How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10

2 3770

1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 4185

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2864

what is null value?

9 8020

1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.

6 6832

what is the difference between rollback & commit? can a foreign key has null value?

6 12270

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

IBM,

2 6031

What is the Extension of Oracle Database? As extension of Access Database is .mdb

2 7747

A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?

2 3560

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

1906

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

3681

How to restrict the duplicate records in table valuesets

IBM,

2 6146

What is the disadvantage of User defind function?

CybAge,

1809

Please explan Why static query is more faster than dynamic query ?

2 6083


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

1882


What are the execution control statements?

587


How to get execution path reports on query statements?

538


How do I find the database name in oracle?

580


What is tns entry?

597






What is catalog in Oracle?

614


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

623


What is a trigger oracle?

538


What is a view and how is it different from a table?

553


What is a user role in oracle?

595


how may join possible between (requisition with purchase order)

1680


What privilege is needed for a user to delete rows from tables in another schema?

547


What is the fastest query method to fetch data from the table?

814


What is proxy method?

523


Whats the benefit of dbms_stats over analyze?

1469