|
From: John K. W. <jo...@sl...> - 2003-08-23 01:26:56
|
If someone would write an enhancement/plugin which would enable the =20 easy editting of stored procs/triggers in squirrel, it would become a =20= serious alternative to TOAD and SQL-Navigator. Then, we just need =20 editting java stored procs to make it complete. :) John On Thursday, Aug 21, 2003, at 00:34 US/Pacific, Dani Hernandez wrote: > On Oracle, you can get all your source code from a system view that =20= > filters > for each user his sources: > > select * from user_source; > > Where you can filter with where clauses by TYPE (FUNCTION, PROCEDURE, > PACKAGE, ...) or NAME. > > You cannot edit this code with update querys, but. > > Dani. > > ----- Original Message ----- > From: "Colin Bell" <Col...@as...> > To: "'aj...@wo...'" <cz0...@ti...>; > <squ...@li...> > Sent: Friday, August 08, 2003 5:24 AM > Subject: RE: [Squirrel-sql-users] The stored procedures > > >> To create a stored procedure in SQuirreL means executing a CREATE > PROCEDURE >> SQL statement. Something like >> >> CREATE OR REPLACE PROCEDURE PROC01 >> AS >> SELECT * FROM TAB01; >> >> Consult the documentation that came with your SQL server for more >> information. >> >> To retrieve the source for your stored procedure is a little = trickier. > There >> is no vendor-neutral way using JDBC to retrieve the source for a =20 >> stored >> procedure. Instead you'll have to consult the documentation that came = =20 >> with >> your SQL server to see how to do this. Usually its stored in a table =20= >> in > your >> system database. >> >> Col >> >>> -----Original Message----- >>> From: aj...@wo... [mailto:cz0...@ti...] >>> Sent: Thursday, 7 August 2003 17:07 >>> To: squ...@li... >>> Subject: [Squirrel-sql-users] The stored procedures >>> >>> >>> Please can someone tell me how I can create and edit the >>> stored procedures >>> in Squirrel? Thanks. >>> >>> >>> Betty >>> >>> >>> ___________________________________________________________________ >>> Nakreslete si svoji mapu a vyhrajte ceny z letn=ED kolekce! >>> Soutezte s MapClubem na http://mapy.tiscali.cz >>> >>> >>> >>> >>> >>> ------------------------------------------------------- >>> This SF.Net email sponsored by: Free pre-built ASP.NET sites =20 >>> including >>> Data Reports, E-commerce, Portals, and Forums are available now. >>> Download today and enter to win an XBOX or Visual Studio .NET. >>> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet >>> _072303_01/01 >>> _______________________________________________ >>> Squirrel-sql-users mailing list >>> Squ...@li... >>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >>> >> >> >> ------------------------------------------------------- >> This SF.Net email sponsored by: Free pre-built ASP.NET sites = including >> Data Reports, E-commerce, Portals, and Forums are available now. >> Download today and enter to win an XBOX or Visual Studio .NET. >> > http://aspnet.click-url.com/go/psa00100003ave/=20 > direct;at.aspnet_072303_01/01 >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> >> > > > > ------------------------------------------------------- > This SF.net email is sponsored by: VM Ware > With VMware you can run multiple operating systems on a single = machine. > WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines > at the same time. Free trial click =20 > here:http://www.vmware.com/wl/offer/358/0 > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
