Un-Answered Questions { Oracle General }

Why do you use stored procedures and state some of its disadvantages?

542


How to convert a date to char in oracle? Give one example.

569


What is the difference between translate and replace in oracle?

615


What are the different types of synonyms?

566


How do you store pictures in a database?

536


What is the use of file param in imp command?

620


What is a system tablespace?

574


In the oracle version 9.3.0.5.0, what does each number shows?

706


What are the different types of modules in oracle forms?

532


What are the limitations of check constraint?

547


How to convert a string to a date in oracle database?

527


What will be the syntax to find current date and time in format "yyyy-mm-dd"?

539


Can you create a synonym without having a table?

537


What are the components of logical database structure in oracle database?

560


What is the usage of save points in oracle database?

516