How to connect to oracle using service name instead of sid?
No Answer is Posted For this Question
Be the First to Post Answer
What is PL/SQL ?
How to shutdown your 10g xe server?
What is a oracle database?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
From the database level, how can you tell under which time zone a database is operating?
How to convert a date to char in oracle? Give one example.
select statement does not retrieve any records. what exception is raised?
What are the attributes of the cursor?
What is an UTL_FILE.What are different procedures and functions associated with it?
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
What is a dead lock in oracle?