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

Find all employees in Dept “Marketing”.

2 3581

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 3519

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 3982

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.

2746

what is null value?

9 7200

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 6319

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

6 11628

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 5635

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

2 7446

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

2 3285

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

1763

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

3493

How to restrict the duplicate records in table valuesets

IBM,

2 5834

What is the disadvantage of User defind function?

CybAge,

1677

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

2 5744


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How do I reset a sequence in oracle?

426


How to concatenate two text values in oracle?

426


How much memory your 10g xe server is using?

428


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1447


State some uses of redo log files?

395






What is the data pump export utility?

481


How to create an initialization parameter file?

410


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1324


Explain parameter file in oracle.

415


How to create a stored function in oracle?

431


What are transaction isolation levels supported by oracle?

410


What is a sub query and what are the different types of subqueries?

467


How to empty your oracle recycle bin?

406


How to recover a dropped table in oracle?

428


What is difference between cartesian join and cross join?

404