Output in SQL Worksheet or SQLPlus

From: Tom Williamson <tomw_at_action.cnchost.com>
Date: Fri, 20 Aug 1999 20:51:48 GMT
Message-ID: <Edjv3.9335$3%1.2176@news.rdc1.az.home.com>

Please pardon this newbie question, but what's the best way to display output in SQL Worksheet or SQL Plus, when using PL/SQL?

In MS-SQL Server it would be simple - either simply SELECT * FROM TABLE or else PRINT the values you want.

In Oracle, SELECT X FROM TABLENAME results in an error stating "an INTO clause is expected", and there doesn't seem to be a PRINT or ECHO statement anywhere (at least I can't find it.) What's everyone's favorite way of doing this (getting output onto the screen)?

Thanks - Tom Received on Fri Aug 20 1999 - 15:51:48 CDT