Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the relationship among Database, Tablespace and Data
file?
- 4 Answers
- 12761 Views
- I also Faced
- E-Mail Answers
Answer Posted / nishi
database contain atleast one tablespace and tablespace must have atleast one datafile
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the usage of save points in oracle database?
What is instant client oracle?
How to name query output columns in oracle?
Explain the use of tables option in exp command.
What is set verify off in oracle?
What are the attributes of the cursor?
What is oracle instant client?
How can we find out the duplicate values in an oracle table?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Explain the use of online redo log files in oracle.
How to define an explicit cursor in oracle?
What is the difference between sharding and replication?
> 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 view the tablespaces in the current database?
What is a subquery?
