Search Results for "select"

...I seemed a good idea and to not let it die I created this project It contains support for the creation of insert, delete, update and select, Just enter the name of function ls, schema.table and target schema where live the new functions. This is responsible for generating the stored procedure function requested (insert, delete, update, select and save)

...It can also convert a Oracle table into a dBase file and vice versa. Sample 1 - create a shape file (alk.shp, alk.shx, alk.dbf) of type 5 (=Polygon) from table MYTABLE with sdo-column="geo" and SDO_GTYPE=3003: select zvk_shape.write_shp('DATA_PUMP_DIR','alk', 'select t.C01 "NAME", t.C20 "FLST", t.GEO from MYTABLE t where t.C02 = ''ALK'' order by t.C01','GEO',5) "alk" FROM dual;

This is a set of PLSQL packages for the Oracle database which provide acess to the OS shell and the file system from SQL and PL/SQL. The packages provide operations on file handles (delete, create, move, copy) as well as the execution of shell commands.

PL/SQL packages to perform Oracle 11g tasks within a very few number of lines : dump/load LOBs, compute CRC, get Mime Type from a BLOB, send XMPP messages, list directory contents as a table, interact with Twitter,deal with QrCodes, ...