Why do you create or replace procedures rather that drop and recreate.
How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
What is a tns service name?
Is the After report trigger fired if the report execution fails ?
What are the differences between char and nchar in oracle?
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
Why does for update in oracle 8 cause an ora-01002 error?
What are the advantages of oracle?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
How many categories of data types?
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
can u call user defined functions in select statements
How to write an inner join with the where clause in oracle?