DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: column formating

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    hi,
    I am trying to do some column formating for the following table (egs emp)
    I have a script as

    begin
    col empid a(4);
    col empname a(30);
    col deptno 9999;
    end;

    i am getting the following err
    ERROR at line 2:
    ORA-06550: line 2, column 5:
    PLS-00103: Encountered the symbol "empid" when expecting one of the
    following:
    := . ( @ % ;

    Can I use this script for column formating ,when ever I need it
    or exclucively set it?

    Please advise
    Badrinath

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    See this example for sample sql script formatting.
    <font face=courier>
    col owner format a12
    col db_link format a36
    col username format a12
    col host format a12
    col created format a12

    select owner,
    db_link,
    username,
    host,
    created
    from dba_db_links ;
    </font>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width