{ 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.
Just a quick note about something that i did at work which is a cool pattern – A Timed Cache. We have some files which get loaded from a db and the db can change periodically – everything is readonly.
the simple solution is to have a timeout period and when you check the cache to see if something is loaded you also check the current time and the time you last cleared the cache, if the difference is greater than the timeout period then you simply clear the cache first.
this all happens inside a synchronized method which i am fairly certain about but which i’d like to do some more experimentation with to be sure – another post! I will probably set up some kind of multithreaded test environment where i can really see whats going on once and for all – its quite hard to conceptualise all this synchronised stuff in your head – its all very well in theory:)
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…
Subscribe