Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP
junecarol.walsh <junecarol.walsh_at_ntlworld.com> wrote:
>I have not used Oracle 4 a while!
>
>I was wondering if anyone could help me on the following things:-
>
>1) Add a column to a table
ALTER TABLE table ADD (column datatype);
>2) Average a column
select AVG(column) FROM table;
>3) Find the greastest value in a column
MAX(column)
>4) Find the lowest value in a colum
MIN(column)
>5) Put a column in date order
ORDER BY (column)
>I know these may seem basic 2 a few of u but i have not used oracle for a
>while, lets just say I am rusty & need some help 2 rejog my memory
Most of these are basic SQL, not Oracle specific - may I recommend Andrew
Cumming's excellent short interactive SQL tutorial "A gentle introduction
to SQL" -
http://www.dcs.napier.ac.uk/~andrew/sql/
(Hmm.. that site seems to be down at the moment, there's a
non-interactive mirror at:
http://members.nbci.com/_XMCM/tuttle_h/gisq/home.htm
)
-- Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/Received on Fri Aug 03 2001 - 03:52:07 CDT