12 May 2014 sye   » (Journeyer)

http://www.dba-oracle.com/t_pl_sql_plsql_select_into_clause.htm

select distinct nodeid from ofpubsubsubscription where length(nodeid) less than 9

select count(*) from ofoffline where username = 'njnsp0285'
select offlinedate from ofpresence where username = 'admin'
select username from ofpresence where cast(offlinedate as int) >=1382125813051
# '1382125813051' is approx. 205 days 23 hours and 6 min.
select count(*) from ofoffline where username = 'njnsp02s9'
# returns 55 rows
select count(*) from ofoffline where username like 'nj%'
# returns 4859 rows
select count(*) from ofoffline where username = 'admin'
# returns 2592 rows
select count(*) from ofoffline
# returns total 7451 rows
select distinct username from ofoffline where messageid > 0
# returns 9 rows.
delete from ofoffline where username = 'njnsp01t8'
# updateCount = 79

pure SQL or NOT ? trial and error, still the best way to go...

Latest blog entries     Older blog entries

New Advogato Features

New HTML Parser: The long-awaited libxml2 based HTML parser code is live. It needs further work but already handles most markup better than the original parser.

Keep up with the latest Advogato features by reading the Advogato status blog.

If you're a C programmer with some spare time, take a look at the mod_virgule project page and help us with one of the tasks on the ToDo list!