non-random ramble :: Oracle and simple SQL

{ 18 01 2006 12:01 }

Oracle and simple SQL

So im playing with oracle and have forgotten everything i know about it.

SELECT table_name FROM all_tables WHERE owner = USER;

this gives me all my tables.

cant even remember the syntax for a CREATE table!!

create table test (column1 varchar(20), column2 int);

insert into test values (‘jim001′, 34);

delete from test where column1=’jim001′;

update test set column1=’jim003′, column2=’56′ where column1=’jim001′;

this will go in my wikki when i work out how to work that!:)

woohoo!! toad is so beautiful! i think its had a revamp…