Re: How do you get a verticle list of table columns plus sample value?

I do this by copying a line of output to Excel, converting text to columns, and then copying and "Paste Special | Transpose", a rather long way of accomplishing what you want to do.

It works but it is a pain. Worst of all, it requires using a Micro$oft tool.

However, it does work.

I'll look forward to seeing a better way.

Thanks for your post.

Greg Teets
Cincinnati, Ohio

On Sun, 01 Jul 2001 01:05:55 +0100, John Perkins <jperkins_at_cwcom.zap.net> wrote:

>Can anyone offer a method of obtaining a sample record from a table
>which lists each column vertically plus a sample value? VAX Datatrieve has
>a very useful command called LIST which does this but I haven't found an
>Oracle or Steven Feuerstein package that does a similar job. I have used a
>complex PL/SQL loop using ALL_TAB_COLUMNS but am having a job getting this
>to generate dynamic SQL in the spooled output. For example,
>the output from SCOTT.EMP would look like this:
>
>EMPNO 7521
>ENAME WARD
>JOB SALESMAN
>MGR 7698
>HIREDATE 22-Feb-81
>SAL 1250
>COMM 500
>DEPTNO 30
>
>Any suggestions welcomed!
>TIA,
>John
>
Received on Sun Jul 22 2001 - 08:54:47 CEST