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

Thread: SQL Plus question

  1. 11-08-2002, 12:11 PM #1
    Chintz
    Chintz is offline Member
    Join Date
    Dec 1999
    Posts
    217

    SQL Plus question

    I just want SQL Plus to display the first 5 rows of the query, what is the set command I pass?

    Appreciate your input,
    Chintz
    Reply With Quote Reply With Quote
  2. 11-08-2002, 12:24 PM #2
    jrpm
    jrpm is offline Senior Member
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    select * from dual where rownum<6where rownum<6 where rownum<6
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'
    Reply With Quote Reply With Quote
  3. 11-08-2002, 12:35 PM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by jrpm
    select * from dual where rownum<6where rownum<6 where rownum<6
    ok, we get it ok, we get it ok, we get it
    Jeff Hunter
    Reply With Quote Reply With Quote
  4. 11-12-2002, 08:53 AM #4
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    r e a l l y ?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width