by Boris Milrud – Learn how to write, load, and run a SQLJ stored procedure on an Oracle database, and see how its results compare with PL/SQL’s.
Author: SSWUG Research
Allow a user to kill certain sessions without giving them the alter system privilege
(Kevin Nicholson) This procedure will allow you to give a user the ability to kill any session other than SYS, SYSTEM, DBSNMP, REPADMIN, OUTLN and the background processes without giving them the alter system privilege. (R)
Visual XSLT 1.2 Advances the State of the Art
by A. Russell Jones – ActiveState's Visual XSLT integrates directly into Visual Studio to give you full-featured XSLT editing and debugging capabilities. Read the full review now.
Deploying Web services with WSDL, Part 2: Simple Object Access Protocol (SOAP)
In this article, Bial Siddiqui will discuss details of SOAP communications, how objects expose their functionality using SOAP, how to invoke SOAP objects and how to exchange information between SOAP-aware applications. He'll also demonstrate the deployment of SOAP services for the WSDL applicati
Google's Gaffe
Paul Prescod explains why moving its API to use SOAP was a backward step for the popular search engine, and argues for a return to a pure HTTP and XML interface.
Oracle 9i R1 allows any user to access any table
By Chris Eaton – This was posted on the forum (comp.database.oracle.server) and I have tried it on my test system and it is a real problem: Any user can access any table using 9i. Someone on the forum posted that there is a TAR 2121935 open stating that it will be fixed in 9iR2 and not in 9.0.x. I s
Oracle SQL Techniques
by Sanjay Mishra, Alan Beaulieu – If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle’s implementation of SQL, is the key to writing good queries in a ti
Auditing Your SQL Server Environment, Part II (Reviewing Role Memberships)
by Randy Dyess – This article is the second article in a series to share those stored procedures and methods I have learned with you, in order to help you document and learn a new environment if you move on, or obtain another project at your existing company.
Inserting Images ( binary data ) into Database
In this tutorial you are going to learn everything in detail step by step you’ll ever want to know about inserting binary data ( images, zip files etc ) into database. This is actually first of the three articles I am going to write on manipulating binary data in the database.
Programming ADO SQL Server Applications
Microsoft® ActiveX® Data Objects (ADO) is a data access interface used to communicate with OLE DB-compliant data sources, such as Microsoft SQL Server™ 2000. Data consumer applications can use ADO to connect to, retrieve, manipulate, and update data from an instance of SQL Server.