Can we use oracle pl/sql block in core java? if so how? pls
get back to me .....
What are the types of synonyms?
What is difference between SQL and SQL*PLUS?
How many file formats are supported to export data?
What is an oracle wallet?
Explain database link?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
How to drop an index?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What are the uses of Rollback Segment ?
Explain an exception?
How to omit columns with default values in insert statement in oracle?