How to write text literals in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
Name the three major set of files on disk that compose a database in Oracle?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
How to shutdown your 10g xe server?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
State some uses of redo log files?
What is oracle used for?
What is snapshot is too old? Give and example for better understand.
What is a initialization parameter file in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to call a stored function with parameters?
Explain the difference between a procedure and a function? What do you understand by those terms?
How to use subqueries with the in operator using oracle?