Re: SQL Basics

From: HansF <News.Hans_at_telus.net>
Date: Tue, 07 Mar 2006 16:28:11 GMT
Message-Id: <pan.2006.03.07.16.28.12.20081@telus.net>

On Tue, 07 Mar 2006 08:20:15 -0800, mm_at_malin.pl wrote:

> Hello.
>
> How to display records from a table where column name fits some
> pattern?
>
> I want to display all records form table EAM_WORK_ORDERS_V where column
> name contains "activity" string. Something like:
>
> select "%activity%" from EAM_WORK_ORDERS_V
>

Is not supported directly by basic SELECT statement.

Is one of the valid reasons for creating [potentially perforanmce killing] dynamic SQL.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***

Received on Tue Mar 07 2006 - 10:28:11 CST