Re: using for loop to read the field values

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 27 Feb 2003 10:44:36 -0800
Message-ID: <1b061893.0302271044.546d3e84_at_posting.google.com>

Use dynamic SQL and populate the SQL statements using contents of user_tab_columns (column "COLUMN_NAME"). It's not the best solution performance-wise (dynamic SQL is usually slower than static), but at least you won't have to type each column manually.

Daniel Received on Thu Feb 27 2003 - 19:44:36 CET

This message: [ Message body ]
Next message: Daniel Roy: "Re: schema PUBLIC"
Previous message: Guido Konsolke: "Re: Ignore Case"
In reply to: SV: "using for loop to read the field values"
Next in thread: Daniel Roy: "Re: schema PUBLIC"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message