Answer Posted / nishi
A database instance is a set of memory structures that manage database files. A database is a set of physical files on disk created by the CREATE DATABASE statement. The instance manages its associated data and serves the users of thedatabase.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create lov dynamically at runtime & attach to text field?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How to use fetch statement in a loop?
What are data pump export and import modes?
How can we delete duplicate rows in a table?
Explain a synonym?
What are the types of partitions in oracle?
What is connection pooling in oracle?
What do database buffers contain?
What are the most common interview questions on ETL Testing for experience?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
How to connect to the server with user account: sys?
What is the difference between online and offline backups?
Why do we use bulk collect in oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?