Answer Posted / syed mazhar nadir
we can say that the trace files are the outlines files . a
trace files are those files which help us to covert our
control files into readable format. they are recorded in
alter .log ext.
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
How to create lov dynamically at runtime & attach to text field?
Difference between pre-select and pre-query
How to export your connection information to a file?
What is an oracle database?
How to enter a new row into a table interactively?
What is set verify off in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How to create a testing table in oracle?
Explain the use of rows option in imp command.
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How to create a single index for multiple columns?
How a tablespace is related to data files?
What is the usage of save points in oracle database?
> 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?
What is a system tablespace and when it is created?