1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

PL/SQL - Oracle

Discussion in 'Databases' started by skimmy, Feb 13, 2006.

  1. #1
    Hi I'm creating a PL/SQL Procedure in Oracle 9i. I need to display the contents of a table onto the screen from within my Procedure. If I simply issue a 'SELCT * FROM tablename' it gives an error that the statement requires a SELECT INTO clause. Can anyone tell me how to just dump the contents of the table onto the screen from that code block?
    SEMrush
    Many thanks,
     
    skimmy, Feb 13, 2006 IP
    SEMrush
  2. skimmy

    skimmy Peon

    Messages:
    138
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Well I guess I figured out the answer to my own question...

    Issue the select statement after the 'END' command... just in case anyone else wants to know.
     
    skimmy, Feb 13, 2006 IP