Oracle General Interview Questions
Questions Answers Views Company eMail

Can we write insert statement in function in oracle?

857

What is a package in oracle?

803

What is pragma autonomous transaction in oracle?

801

What is define in oracle?

841

Can we write dml statement in function in oracle?

867

What is a trigger oracle?

837

Is oracle a programming language?

781

Is truncate autocommit in oracle?

875

Why we use bulk collect in oracle?

785

What is procedure overloading in oracle?

812

Is oracle a language?

732

How do you bind variables in oracle?

778

Is insert autocommit in oracle?

833

What is data type in oracle?

806

Why packages are used in oracle?

823


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to define a variable of a specific record type?

884


How to build data dictionary view an new database?

818


Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1515


What is an oracle tablespace?

814


What is execute immediate in oracle?

773


In which language oracle has been developed?

876


What is a schema in oracle?

812


What are the different types of synonyms?

871


Explain parameter file in oracle.

815


What is the difference between a user and a schema in oracle?

840


Explain the use of record length option in exp command.

843


How do we represent comments in oracle?

857


How to use "in out" parameter properly?

834


Difference between varchar and varchar2 data types?

892


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

823