Hello all,
I need to run the following query on a table. How would i formulate this in
SQLite as it appears that SQLite doesn't do PL/SQL?
I can use the tcl SQLite API or do this via SQLiteSPY, but SQLitespy doesn't
understand the constructs.
Thanks
DECLARE
TYPE OpList IS TABLE OF VARCHAR2(100);
lcount NUMBER;
names OpList ;
BEGIN
select distinct operation BULK COLLECT INTO names from MYTAB where ocrelease
like '10.0.0';
for indx in names.first..names.last loop
select count(*) into lcount from MYTAB where release like '10.0.0' and
operation like names(indx);
dbms_output.put_line(names(indx)||' = '||lcount);
end loop;
END;
/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
