SELECT * FROM foo WHERE rownum < 4
--
Howard Fore, [EMAIL PROTECTED]
On May 5, 2004, at 3:00 PM, Howard Fore wrote:
> As for your other question:
>
> SELECT TOP 3 FROM FOO
>
> --
> Howard Fore, [EMAIL PROTECTED]
>
>
> On May 5, 2004, at 2:16 PM, Daniel Kessler wrote:
>
>> I'm trying to add a column in my DB in Oracle. I'm doing:
>> ALTER TABLE whatsnew ADD (image varchar2(100));
>> I also tried:
>> ALTER TABLE whatsnew ADD column image varchar2(100);
>>
>> but I get the error about line 4 of the cfm. This is a reference to
>> the text field from the form that contains the above line (alter
>> table...):
>> The error occurred in
>> hhp/htdocs/HHPv1/WNFunctions/DatabaseFunctions/addsql.cfm: line 4
>>
>> 2 : <BODY>
>> 3 : <CFQUERY NAME="SQLEXE" DATASOURCE="dpch">
>> 4 : #sql_statement#
>> 5 : </CFQUERY>
>> 6 : <B>SQL Statement Executed</B
>>
>>
>> Also, can anyone tell me how to query for just 3 records in Oracle?
>> I know how to do it in mySQL, but...
>>
>> thanks.
>>
>> --
>> Daniel Kessler
>>
>> Department of Public and Community Health
>> University of Maryland
>> Suite 2387 Valley Drive
>> College Park, MD 20742-2611
>> 301-405-2545 Phone
>> www.phi.umd.edu
>>
>>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
