DatabaseJournal.com Staff

>>Script Language and Platform: OracleThis script can be used to create partitions as well, as indexes for these, in a single run. It calls the following scripts: 1.tablespace_size_stat.sql2.select_partition_table.sql3.create_partition_tablespace.sql4.add_partition.sql5.create_ind_partition_tablespace.sql6.rebuild_partition_index.sql Author: BHABANI SHANKAR MAHARANA Download Script:create_partitions.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in […]

[From WebProNews] SQL Injection is one of the most common security vulnerabilities on the web. Here I’ll try to explain in detail these kinds of vulnerabilities with examples of bugs in PHP and possible solutions. If you are not so confident with programming languages and web technologies you may be wondering what SQL stands for. […]

[From MySQL Developer Zone] It’s amazing in an age where relational databases reign supreme when it comes to managing data that so much information still exists outside RDBMS engines in the form of flat files and other such constructs. In most enterprises, data is passed back and forth between disparate systems in a fashion and […]

[From Lorenzo Alberton] The SQL 2003 Standard introduced a schema called INFORMATION_SCHEMA. It’s meant to be a set of views you can query using regular SELECT statements, if you need to know something about the defined triggers, or the structure of a table. Firebird doesn’t have it, but you can retrieve everything you need from […]

[From Microsoft Corp.] Microsoft updated SQL Server 2005 Books Online documentation. This new version of documentation contains new material and fixes to existing documentation. You can download the April 2006 version of BOL here: http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en The article continues at http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en

This stored procedure for SQL Server 7.0 and 2000 will return the number of rows for stored procedures. Setting the parameter to a stored procedure name will return the count of rows for that procedure. Omitting the parameter or setting it to NULL will return all the stored procedures in the database and the row […]

[From SearchOpenSource.com] Many people consider PostgreSQL 8.0 to be a groundbreaking release for the PostgreSQL project, calling it the first version to include native Windows support. But while it did indeed take a significant step in this direction, if you look a bit further you will see that PostgreSQL 8.0 did not cover entirely new […]

>>Script Language and Platform: SQL Plus This script will display the Customers which fall within a specific territory, with all the customer names and customer ID. Author: Srikanth SELECT RC.CUSTOMER_ID, RC.CUSTOMER_NUMBER, RC.CUSTOMER_NAME, RAT.SEGMENT2, RAT.SEGMENT3 FROM RA_CUSTOMERS RC, RA_TERRITORIES RAT , RA_ADDRESSES_ALL RAA, RA_SITE_USES_ALL SUA WHERE RC.PARTY_ID = RAA.PARTY_ID AND RC.CUSTOMER_ID = RAA.CUSTOMER_ID AND RAA.ADDRESS_ID = […]

Vincent Chan (vkchan99@yahoo.com) is a Senior Consultant at MSD Inc. He is an Oracle Certified Master DBA with more than ten years of experience architecting and implementing Oracle solutions for various clients. Current Articles:

[From Oracle Corp.] REDWOOD SHORES, Calif. 03-APR-2006 In response to small and mid-size customers’ demand for a continuation of Oracle’s JD Edwards EnterpriseOne software on IBM’s platform, Oracle today announced plans to strengthen its partnership with IBM to position their industry-leading SMB reseller channel to promote Oracle’s JD Edwards applications. Specifically, Oracle has increased investment […]

>>Script Language and Platform: OracleUse this script to set the session identifier and correctly get trace file name. Author: Prashu Download Script:find_own_trace.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on these […]

by Paul C. Zikopoulos In Part 1 of this series, I discussed how to use the Database Explorer view in the IBM Rational Application Developer for WebSphereSoftware (Rational AD) product to create and work with IBM DB2 Universal Database (DB2 UDB) for Linux, UNIX, and Windows database connections. Part 2 introduced you to some of […]