By Steve Montgomerie – Here is how to use UTL_FILE to detect a file on the OS insead of writing a UNIX or DOS script. The procedure can be scheduled through DBA_JOBS to check for the existence of a file that has been FTP’ed, for example. Once the file has been detected, it calls another procedure to
Community
Empirical Hacker – Protect your database server
By Luis F. Medina – Will you be another statistic? Is the connection to your database server mutually exclusive? Has database security become an empirical concept among database administrators in your company? If the probability of an attack in the future is determined by your observations of securi
Microsoft patches Windows 2000 flaw, SQL holes
By Sam Costello – Microsoft Corp. released a patch for a vulnerability it called “critical” that could allow an attacker to take complete control of Windows 2000 systems. The company also released a cumulative patch for SQL Sever 7.0 and 2000 that repaired a new security hole.
Jacada Adds Web Services To Integration Platform
Jacada Ltd., a developer of enterprise application integration software, said it has made available Jacada Integrator 3.6, with full support for Web services protocols.Jacada Integrator creates reusable components out of applications running on IBM zSeries mainframe, IBM iSeries midrange com
POSTing data with Microsoft.XMLHTTP
The most common operation XMLHTTP is used for is to retrive data, whether it be XML or something else, from remote servers via HTTP. It’s a useful trick to have, especially in these days of RDF/RSS feeds and so on, but the second method which XMLHTTP can be used for is perhaps one with less obvious
The Absent Yet Present Link
by Kendall Grant Clark – In last week’s column, ” XHTML 2.0: The Latest Trick”, I described the next step in the evolution of XHTML, at least according to the 5 August XHTML 2.0 working draft. As is often the case, however, reaction to a new W3C specification, even a very early draft, exposed
Database Horizons
By GARY H. ANTHES – The modern database era began in 1970, when E.F. Codd published his paper “A Relational Model of Data for Large Shared Data Banks.” His ideas enabled the logical manipulation of data to be independent of its physical location, greatly simplifying the work of application developer
How to create views in SQL Server 7.0/2000
By Dan Seewer – Think of a view as another table within the database. Views are often referred to as virtual tables since no physical table exists in the database: A view is merely a “stored query” that returns a result set that can be used in SQL. The view can then be used as part of other SQL quer
OLAP and Data Warehousing – Data Warehousing Solution Architecture (Part 2)
By Alexzander Nepomnjashiy – Analysis is usually accomplished with tools that are built on the base of attendant technologies. Let’s briefly describe two of the most popular technologies – Online Analysis Processing (OLAP – the online operating analysis) and Data Mining (mining for hidden informatio
The Platform for the Connected Enterprise
By Philip J. GIll – Application developers need more than just an application server; they need an application platform. Oracle9iAS and J2EE combine to form just such a platform.