{ Category Archives }
eg :
WHERE tb.XML_COLUMN.existsNode(‘/some/xpath[with_test="Jeff"]‘)=1
have to use this “existsNode” the xpath can then do the filter – if you want to filter on the value of a node you do the above, otherwise use @ for attributes.
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…
http://www.toadsoft.com/lic_agree.html
Read Me