Oracle Interview Questions
Questions Answers Views Company eMail

How to compare dates in oracle sql?

646

What is the sql query to concatenate column values from multiple rows in oracle?

553

How to handle a single quote in oracle sql?

583

Is there a function to split a string in plsql?

558

How to speed up webrick?

582

How can I get column names from a table in oracle?

526

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

535

How to connect to oracle using service name instead of sid?

542

When do I need to use a semicolon vs a slash in oracle sql?

580

How do I escape a reserved word in oracle?

622

How to best split csv strings in oracle 9i?

576

What is different types of joins?

565

How to fetch the row which has the max value for a column?

530

How to get last row id?

547

How to put more than 1000 values into an oracle in clause?

579


Un-Answered Questions { Oracle }

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

4657


Explain about functional dependency and its relation with table design?

543


What is the difference between online and offline backups?

554


What is oracle and what are its different editions?

564


What is a proxy class?

549






Can we commit inside a function in oracle?

546


How many concurrent programs you have customized, can you name some of them?

1


What are the new features in release 11i?

1


How to handle a single quote in oracle sql?

583


When do you get a .pll extension in oracle? Explain its importance

566


List out the types of joins.

583


What parameters control copy latches?

276


Can you remove an open file under unix?

342


What is tkprof and how can we use it?

1


defination of bitmap index

1614