Basic question SQL Worksheet in Oracle 8.1.*
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Basic question SQL Worksheet in Oracle 8.1.*

  1. #1
    Join Date
    Jan 2001
    Posts
    318
    In Oracle 8.1.6 and 8.1.7 I have SQL*Plus and SQL*Plus worksheet but I do not have Oracle SQL worksheet which I have on Oracle 8.0.6.
    Did they take out this utility ?

    Both SQL*Plus and SQL*Plus worksheet in Oracle 8.1.7 do not have a column formatted after you execute the query. In other words it gives one line of column name then one line of data then again column name and so on...like before it used to show one line of column name list and then below it data requested.

    Before -

    SQLWKS> select USER_INT_ID, USER_ID, USER_FULL_NAME from mwebuser where rownum<5
    2>
    USER_INT_I USER_ID USER_FULL_NAME
    ---------- -------------------------------------------------- --------------------------------------------------------------------------------
    2 admin Administrator
    337 sg180 Gagliese, Suzanne
    11 ADMIN Chow, Alex
    12 sj100 Jackson, Shelley
    4 rows selected.


    Now -
    USER_INT_I USER_ID USER_FULL_NAME
    ---------- -------------------------------------------------- --------------------------------------------------------------------------------
    2 admin Administrator
    USER_INT_I USER_ID USER_FULL_NAME
    ---------- -------------------------------------------------- --------------------------------------------------------------------------------
    337 sg180 Gagliese, Suzanne
    USER_INT_I USER_ID USER_FULL_NAME
    ---------- -------------------------------------------------- --------------------------------------------------------------------------------
    11 ADMIN Chow, Alex
    USER_INT_I USER_ID USER_FULL_NAME
    ---------- -------------------------------------------------- --------------------------------------------------------------------------------
    12 sj100 Jackson, Shelley


    Is their any way to get this SQL*Plus worksheet to work more like SQL Worksheet.

    Thanks
    Sonali
    Sonali

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    See SQLPLUS SET PAREMETERS:

    set linesize XXX
    set pagesize XXX
    column CCCCC format FFFFF

    and many others for format input in SQLPLUS


  3. #3
    Join Date
    Jan 2001
    Posts
    318
    So that means we have lost the old worksheet and now we just have SQL plus in oracle 8.1.7.

    Do I have to set these parameters everytime I query tables and/or everytime I log on to SQL*PLUS worksheet ?

    thanks
    Sonali

  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Yes, you can set this parameteres on any time.

  5. #5
    Join Date
    Apr 2001
    Posts
    118
    Originally posted by Shestakov
    Yes, you can set this parameteres on any time.
    Or you can put them in your sqlplus\admin\glogin.sql file and SQL*Plus will set them for you every time you start it.

    And I think SQL*Plus Worksheet is a POS as well. I have no idea why Oracle changed the SQL Worksheet.

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    You should be able to install SQL Worksheet, it is just not a default during installation. Run again Universal Insaller and select only SQL Worksheet.




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