Home » SQL & PL/SQL » SQL & PL/SQL » EXTERNAL TABLE
EXTERNAL TABLE [message #308352] Mon, 24 March 2008 02:07 Go to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hi,

I have created an external table using a PL/SQL procedure that loads the alert log data into the table. I have displayed the ora errors on the screen using

select * from table name where line like 'ORA-%';

now i need to display the timestamp of this ora error which is just one line above the ora error. I am not understanding how to do so.

all the lines in the text file form one row in the table so timestamp is just one row above the ora error
Re: EXTERNAL TABLE [message #308355 is a reply to message #308352] Mon, 24 March 2008 02:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use LAG function.

Regards
Michel
Re: EXTERNAL TABLE [message #308381 is a reply to message #308355] Mon, 24 March 2008 03:14 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Will Lag function work for external table which has only one column called line and more than 4000 rows. Each row having the data from the external file.
Re: EXTERNAL TABLE [message #308388 is a reply to message #308381] Mon, 24 March 2008 03:27 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hi

I used

SQL> select line, lag(line,1,0) over (ORDER BY line) AS TIMESTAMP from alert_log_external where line like 'ORA-%';


I am getting only the ora erros not the timestamps

The output is :


LINE
--------------------------------------------------------------------------------

TIMESTAMP
--------------------------------------------------------------------------------


ORA-8378 system errorDump filec:\oracle\admin\bdump\alert_db.log
ORA-3344 check conversion of external to internal tableDump file c:\oracle\admin

Re: EXTERNAL TABLE [message #308393 is a reply to message #308388] Mon, 24 March 2008 03:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You get 2 consecutive lines within the order you gave.
You ordered by line, so you get 2 consecutive lines within the alphabetical order.

Order by NULL, then you'll get 2 lines without no order that is the one of the file (unless you defined a parallel on the table).

Regards
Michel
Re: EXTERNAL TABLE [message #308402 is a reply to message #308393] Mon, 24 March 2008 03:57 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Please check this out

SQL> select line, lag(line,1,0) over (order by NULL) as TIMESTAMP from alert_log_external where line like 'ORA-%';

OUTPUT:

LINE
--------------------------------------------------------------------------------

TIMESTAMP
--------------------------------------------------------------------------------

ORA-3297 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE 'C:\ORACLE...



ORA-8378 system errorDump file c:\oracle\admin\bdump\alert_ora.log
ORA-3297 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE 'C:\ORACLE...


ORA-3344 check conversion of external to internal tableDump file c:\oracle\admin\bdump\alert_ora.log
ORA-8378 system errorDump file c:\oracle\admin\bdump\alert_log.log

LINE
--------------------------------------------------------------------------------

TIMESTAMP
--------------------------------------------------------------------------------


ORA-3297 signalled during: alter database datafile 'C:\ORACLE\ORADATA\SYS...

ORA-3344 check conversion of external to internal tableDump file c:\oracle\admin

\bdump\alert_ora.log

ORA-3297 signalled during: alter database datafile 'C:\ORACLE\ORADATA\SYS...

ORA-3297 signalled during: alter database datafile 'C:\ORACLE\ORADATA\SYS...


ORA-3297 signalled during: alter database datafile 'C:\ORACLE\ORADATA\SYS...


LINE
--------------------------------------------------------------------------------

TIMESTAMP
--------------------------------------------------------------------------------

ORA-3297 signalled during: alter database datafile 'C:\ORACLE\ORADATA\SYS...


ORA-3297 signalled during: alter database datafile 'C:\ORACLE\ORADATA\SYS...

ORA-3297 signalled during: alter database datafile 'C:\ORACLE\ORADATA\SYS...



7 rows selected.

Still no timestamp. Timestamp is recorded one like before the ora error.
Thanks a lot for your help
Re: EXTERNAL TABLE [message #308538 is a reply to message #308402] Mon, 24 March 2008 14:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I have neither your table definition nor your alert.log file.

Also please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel
Re: EXTERNAL TABLE [message #308573 is a reply to message #308538] Mon, 24 March 2008 23:23 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hi,

Yes i shall do that. Thanks so much for your help i am new to this forum.


I needed the solution ASAP.

Do you want me to give you my table definition and the file format?

Regards,

SD
Re: EXTERNAL TABLE [message #308583 is a reply to message #308573] Tue, 25 March 2008 00:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Do you want me to give you my table definition and the file format?

Yes it is mandatory (an abstract of the file, and the result of select on the table for the 10 first lines). How can we debug something without seeing this thing?

Regards
Michel
Re: EXTERNAL TABLE [message #308590 is a reply to message #308583] Tue, 25 March 2008 00:19 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hi,

Table definition

ORGANIZATION EXTERNAL

Name Null? Type
----- ------- -------

LINE VARCHAR(4000)


ABSTRACT OF THE FILE

First few lines of the text file & this is also the result of select on the table for first ten lines

I want to print the highlighted lines

Tue Mar 04 17:25:12 2008
Thread 1 advanced to log sequence 10
Tue Mar 04 17:25:12 2008
ARC0: Evaluating archive log 3 thread 1 sequence 9
Tue Mar 04 17:25:12 2008
Current log# 1 seq# 10 mem# 0: C:\ORACLE\ORADATA\REDO01.LOG
Tue Mar 04 17:25:12 2008
ARC0: Beginning to archive log 3 thread 1 sequence 9
Tue Mar 04 17:25:23 2008
ORA-3297 signalled during alter database


Regards,

SD
Re: EXTERNAL TABLE [message #308600 is a reply to message #308590] Tue, 25 March 2008 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I want the CREATE TABLE statement you used or, better, use DBMS_METADATA to get it.

Pleas post it FORMATTED, this is a MANDATORY condition for me to answer now.

Regards
Michel
Re: EXTERNAL TABLE [message #308610 is a reply to message #308600] Tue, 25 March 2008 01:06 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hi,

What do u want me to format?
Re: EXTERNAL TABLE [message #308614 is a reply to message #308610] Tue, 25 March 2008 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The table definition you will give.
The select statement and its result you will post.

Regards
Michel
Re: EXTERNAL TABLE [message #308678 is a reply to message #308352] Tue, 25 March 2008 03:36 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hi,

Create table syntax:

create or replace procedure external_alert_log as
  path_bdump varchar2(4000);
  name_alert varchar2(100);
begin

  select 
    value into path_bdump 
  from 
    sys.v_$parameter
  where
    name = 'background_dump_dest';

  select
    'alert_' || value || '.log' into name_alert
  from
    sys.v_$parameter
  where
    name = 'db_name';

  execute immediate 'create or replace directory background_dump_dest_dir as ''' || 
    path_bdump || '''';

  execute immediate 
    'create table alert_log_external '              ||
    ' ( line  varchar2(4000) ) '                    ||
    '  organization external '                      ||
    ' (type oracle_loader '                         ||
    '  default directory background_dump_dest_dir ' ||
    '  access parameters ( '                        ||
    '    records delimited by newline '             ||
    '    nobadfile '                                ||
    '    nologfile '                                ||
    '    nodiscardfile '                            ||
    '    fields terminated by ''#$~=ui$X'''         ||
    '    missing field values are null '            ||
    '    (line)  '                                  ||
    '  ) '                                          ||
    '  location (''' || name_alert || ''') )'       ||
    '  reject limit unlimited ';
end;
/


Query:
SQL> select * from alert_log_external where line like 'ORA-%';

[Updated on: Tue, 25 March 2008 03:37]

Report message to a moderator

Re: EXTERNAL TABLE [message #308687 is a reply to message #308678] Tue, 25 March 2008 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> create or replace procedure external_alert_log as
  2    path_bdump varchar2(4000);
  3    name_alert varchar2(100);
  4  begin
  5  
  6    select 
  7      value into path_bdump 
  8    from 
  9      sys.v_$parameter
 10    where
 11      name = 'background_dump_dest';
 12  
 13    select
 14      'alert_' || value || '.log' into name_alert
 15    from
 16      sys.v_$parameter
 17    where
 18      name = 'db_name';
 19  
 20    execute immediate 'create or replace directory background_dump_dest_dir as ''' || 
 21      path_bdump || '''';
 22  
 23    execute immediate 
 24      'create table alert_log_external '              ||
 25      ' ( line  varchar2(4000) ) '                    ||
 26      '  organization external '                      ||
 27      ' (type oracle_loader '                         ||
 28      '  default directory background_dump_dest_dir ' ||
 29      '  access parameters ( '                        ||
 30      '    records delimited by newline '             ||
 31      '    nobadfile '                                ||
 32      '    nologfile '                                ||
 33      '    nodiscardfile '                            ||
 34      '    fields terminated by ''#$~=ui$X'''         ||
 35      '    missing field values are null '            ||
 36      '    (line)  '                                  ||
 37      '  ) '                                          ||
 38      '  location (''' || name_alert || ''') )'       ||
 39      '  reject limit unlimited ';
 40  end;
 41  /

Procedure created.

SQL> exec external_alert_log;

PL/SQL procedure successfully completed.

SQL> select line from alert_log_external where rownum<10;
LINE
-----------------------------------------------------------------------------
Dump file c:\oracle\admin\mika\bdump\alert_mika.log
Wed Sep 26 08:49:21 2007
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU                 : 2 - type 586
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:734M/1023M, Ph+PgF:2290M/2458M, VA:1939M/2047M
Wed Sep 26 08:49:21 2007

9 rows selected.

SQL> col timestamp format a24
SQL> col line format a80
SQL> select prev_line as timestamp, line
  2  from ( select line, lag(line) over (order by null) prev_line from alert_log_external )
  3  where line like 'ORA-%' 
  4    and length(prev_line) = 24
  5    and rownum < 10
  6  /
TIMESTAMP                LINE
------------------------ -------------------------------------------------------------------
Wed Sep 26 08:49:30 2007 ORA-00202: control file: 'C:\ORACLE\BASES\MIKA\CONTROL1.CTL'
Wed Sep 26 08:49:31 2007 ORA-205 signalled during: alter database mount exclusive...
Wed Sep 26 09:24:45 2007 ORA-942 signalled during: ALTER DATABASE OPEN...
Mon Oct 01 07:46:09 2007 ORA-942 signalled during: alter database open...
Mon Oct 08 07:53:01 2007 ORA-942 signalled during: alter database open...
Wed Oct 10 07:57:54 2007 ORA-942 signalled during: ALTER DATABASE OPEN...
Wed Oct 10 15:18:20 2007 ORA-1119 signalled during: create tablespace ts_d02 datafile
Mon Oct 15 07:43:57 2007 ORA-942 signalled during: alter database open...
Mon Oct 22 08:01:34 2007 ORA-942 signalled during: alter database open...

9 rows selected.

Note that not all ORA-... lines are preceded by a timestamp.

Regards
Michel
Re: EXTERNAL TABLE [message #308741 is a reply to message #308687] Tue, 25 March 2008 05:49 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hi,

Thanks the script works perfect.

Just i wanted to know why do we put rownum <10. If i do not put the statement it works fine.

Regards,

SD
Re: EXTERNAL TABLE [message #308748 is a reply to message #308741] Tue, 25 March 2008 06:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just to prevent from posting here thousand lines and only the first 9 ones.

Regards
Michel
Re: EXTERNAL TABLE [message #308795 is a reply to message #308748] Tue, 25 March 2008 08:28 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hi,

In case we put rownum<10 then the ora errors before the rownum 10 would not be printed is it?
Re: EXTERNAL TABLE [message #308797 is a reply to message #308795] Tue, 25 March 2008 08:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only the rows BEFORE rownum 10 are displayed.
ROWNUM

Regards
Michel
Re: EXTERNAL TABLE [message #308800 is a reply to message #308797] Tue, 25 March 2008 08:36 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hi,

Sorry question wrongly framed.
Why do we need to display the rows before 10 we need to search the entire table for ora errors?
Re: EXTERNAL TABLE [message #308801 is a reply to message #308800] Tue, 25 March 2008 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no problem to search all errors if you want, but there is a problem if I posted HERE thousand of useless lines.
This was just that, nothing more, remove it for your use.

Regards
Michel
Re: EXTERNAL TABLE [message #308805 is a reply to message #308801] Tue, 25 March 2008 08:47 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Oh thanks so much michel.

My file just had three ora errors thats why i could confused.

Now all clear.

thanks once again !
Re: EXTERNAL TABLE [message #310329 is a reply to message #308801] Mon, 31 March 2008 23:48 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hi,

With Reference to the above doubt.

How do we get the timestamp if it is two or more lines above the ORA error.

Should we make a PL/SQL procedure and put an if condition?

Regards,

SD
Re: EXTERNAL TABLE [message #310332 is a reply to message #310329] Tue, 01 April 2008 00:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, use a pipelined function then you can keep the select way of requesting.

Regards
Michel
Re: EXTERNAL TABLE [message #310349 is a reply to message #310332] Tue, 01 April 2008 00:33 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
for example I have some ora errors as :



Apr 23 14:40:49 2007
Database mounted in Exclusive Mode.
ORA-1501 signaled during: CREATE DATABASE CPRDUAT
Apr 23 14:34:59 2007
ORA-006 
ORA-061
ORA-781
.
.
.
.



How do we generate the timestamp for such ora errors?


Re: EXTERNAL TABLE [message #310361 is a reply to message #310349] Tue, 01 April 2008 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Take a real alert.log, analyze its structure and consequently write a pipelined function.

Regards
Michel
Re: EXTERNAL TABLE [message #310366 is a reply to message #310361] Tue, 01 April 2008 00:59 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Ya I have a real alert.log file.

And i have created an External table using PL/SQL procedure as shown above. Should i make changes to the above procedure or create a new procedure which will query the external table.

I have never used Pipe line Function. Embarassed

Regards,

SD
Re: EXTERNAL TABLE [message #310369 is a reply to message #310366] Tue, 01 April 2008 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Should i make changes to the above procedure or create a new procedure which will query the external table.

There was no procedure to query the external table above (the only procedure is just there to create the external table and is not mandatory, you can do the same thing without it).
Yes, you have to create a new procedure. Pipelined function is just a hint, you can do it as you want.

Regards
Michel
Re: EXTERNAL TABLE [message #310378 is a reply to message #310369] Tue, 01 April 2008 01:15 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Can you please help me getting the timestamps which is a few lines above the ORA errors?

Regards,

SD
Re: EXTERNAL TABLE [message #310381 is a reply to message #310378] Tue, 01 April 2008 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
read line
read line
if date put it in a variable
read line
read line
if ora-... output with previous date
loop on this

Check on a real alert.log if this is a valid algorithm.

Regards
Michel
Re: EXTERNAL TABLE [message #310387 is a reply to message #310381] Tue, 01 April 2008 01:25 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
We need to specify the source of the external table from which it is reading lines or do we have to parse the alert.log file for the procedure?

[Updated on: Tue, 01 April 2008 01:31]

Report message to a moderator

Re: EXTERNAL TABLE [message #310390 is a reply to message #310387] Tue, 01 April 2008 01:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Replace "read line" by "fetch one row from external table" in my previous post.

Regards
Michel
Re: EXTERNAL TABLE [message #310417 is a reply to message #310390] Tue, 01 April 2008 03:33 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hi i am unable to create the procedure for getting the timestamps a few lines above the ORA error Embarassed

Regards,

SD
Re: EXTERNAL TABLE [message #310425 is a reply to message #310417] Tue, 01 April 2008 04:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what you already tried.
When you'll post it don't forget to format it and use code tags.

Regards
Michel
Re: EXTERNAL TABLE [message #310547 is a reply to message #308687] Tue, 01 April 2008 10:48 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member

select * from
(
SELECT rnum,line,lag(line) over(order by rnum) TimeStamp
FROM (SELECT ROW_NUMBER () OVER (ORDER BY NULL) rnum,
SUBSTR (line, 1, LENGTH (line) - 1) line
FROM alert_log_external)
WHERE line LIKE 'ORA%'
OR DECODE (TRANSLATE (SUBSTR (line, -14, 13), '\ \:0123456789', '*'),
NULL, 1,
0
) = 1
ORDER BY rnum) where line like 'ORA%' 


This doesnt help when we have two three ORA errors consecutively for eg:
data used:
Thu Mar 06 14:35:15 2008
Completed: alter database open
ORA-3297 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE 'C:\ORACLE...
ORA-982 signalled

ouput:


LINE
TIMESTAMP

ORA-982 signalled
ORA-3297 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE 
Re: EXTERNAL TABLE [message #310549 is a reply to message #310547] Tue, 01 April 2008 10:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is what I said when I gave you the solution:
Quote:
Note that not all ORA-... lines are preceded by a timestamp.

And this is why I have:
and length(prev_line) = 24

For more complex cases, you have to create a function as the one you started to do it and posted me in PM.
Continue in this way.

Regards
Michel
Re: EXTERNAL TABLE [message #310554 is a reply to message #310549] Tue, 01 April 2008 11:10 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hi,

This is one of the PL/SQL codes:

declare
d1 DATE;
d2 DATE;
BEGIN
for c1 in(select line from alert_log_external) LOOP
if substr(c1.line,4,1)=' ' and substr(c1.line,8,1)=' '
   and substr(c1.line,11,1)=' ' and substr(c1.line,14,1)=':'
   and substr(c1.line,17,1)=':' and substr(c1.line,20,1)=' '
THEN
BEGIN
d1 := to_date(substr(c1.line,1,24), 'Dy Mon DD hh24:Mi:SS YYYY');
exception when others then d1:=NULL;
END;
END IF;
if d1 is not NULL THEN d2:=d1; END IF;
if substr(c1.line,1,4)='ORA-' and substr(c1.line,10,2)=': '
then
dbms_output.put_line(to_char(d2, 'Dy Mon DD hh24:Mi:SS YYYY'));
dbms_output.put_line(c1.line);
end if;
end loop;
END;
/ 

[Updated on: Tue, 01 April 2008 12:09] by Moderator

Report message to a moderator

Re: EXTERNAL TABLE [message #310562 is a reply to message #310554] Tue, 01 April 2008 12:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't have an Oracle database now but this seems correct.
You can use dbms_output.put instead of put_line to display date on the same line than message like in my post.

Regards
Michel
Re: EXTERNAL TABLE [message #310565 is a reply to message #310562] Tue, 01 April 2008 12:21 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hi this code doesn't print the output on the screen


SQL> declare
  2  d1 DATE;
  3  d2 DATE;
  4  BEGIN
  5  for c1 in(select line from alert_log_external) LOOP
  6  if substr(c1.line,4,1)=' ' and substr(c1.line,8,1)=' ' and substr(c1.line,1
1,1)=' ' and substr(c1.line,14,1)=':' and substr(c1.line,17,1)=':' and substr(c1
.line,20,1)=' '
  7  THEN
  8  BEGIN
  9  d1 := to_date(substr(c1.line,1,24), 'Dy Mon DD hh24:Mi:SS YYYY');
 10  exception when others then d1:=NULL;
 11  END;
 12  END IF;
 13  if d1 is not NULL THEN d2:=d1; END IF;
 14  if substr(c1.line,1,4)='ORA-' and substr(c1.line,10,2)=': '
 15  then
 16  dbms_output.put(to_char(d2, 'Dy Mon DD hh24:Mi:SS YYYY'));
 17  dbms_output.put(c1.line);
 18  end if;
 19  end loop;
 20  END;
 21  /

PL/SQL procedure successfully completed.

SQL>
SQL>



Re: EXTERNAL TABLE [message #310566 is a reply to message #310565] Tue, 01 April 2008 12:23 Go to previous messageGo to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set serveroutput on

Regards
Michel
Previous Topic: Cursor Within a Cursor
Next Topic: how to avoid hard code logic value all over pl/sql application?
Goto Forum:
  


Current Time: Wed Dec 07 18:38:30 CST 2016

Total time taken to generate the page: 0.28465 seconds