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/