A collection of 26 FAQs on PL/SQL managing our own procedures. It can also be used as learning tutorials on creating procedures and functions, executing and dropping procedures, passing actual parameters to formal parameters, making optional parameters.

Universal FAQ Manager is knowledge base software, customer support software, online support software, or technical support software. Specifically called FAQ Management Software, quality releases such as Universal FAQ Manager 2008 save businesses time and money while delivering higher levels of customer satisfaction. Worth it? Return on investments often are 1,000%. Any business today must get customer service right or will not be around tomorrow.

A collection of 15 FAQs on MySQL date and time handling. Clear answers are provided with tutorial exercises on date and time data types; formatting and converting date and times; incrementing dates and times; calculating date differences; understanding TIMESTAMP columns.

This article provides tutorial notes on Sun's Reference Implementation of JdbcRowSet working with MySQL database. Topics include installing JdbcRowSet reference implementation; connecting JdbcRowSet objects to database server with connection URL, DataSource name, ResultSet objects or Connection objects; query parameters; inserting rows.

A collection of 14 FAQs on Transact-SQL language character string and binary string operations. Clear answers are provided with tutorial exercises on concatenating character/binary strings; converting Unicode character strings; converting binary strings; inserting new line characters; locating and taking substrings; bitwise operations.

This article provides tutorial notes on sending non-ASCII text data to MySQL. Topics include sending non-ASCII text data in SQL statements; changing MySQL character set settings to send Latin1, UTF-8, BGK, and Big5 characters

A collection of 10 tutorials for you to get started quickly with running Transact-SQL statements on SQL Server 2005. Clear examples are provided for running CREATE TABLE, INSERT, UPDATE, DELTE, SELECT, CREATE USER, GRANT EXECUTE statements.

A collection of 10 FAQs on MySQL command-line interface mysql. Clear answers are provided with tutorial exercises on mysql command option; running SQL and mysql commands; running mysql command files in batch mode; returning query output in HTML and XML formats.

A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs.

A collection of 12 FAQs on MySQL server mysqld administration. Clear answers are provided with tutorial exercises on starting and shuting down the server; turning on server log files; viewing binary log files; running server on different port numbers.

This new web-based software application can assist companies and businesses in retrieving all the information they need for a thorough background check on their employees. Reports are typically returned in less than 48 hours. The background checking service verifies such information as: Employment History Dates of employment and position held Job performance and reason for leaving Pay rate Residential Address History County Criminal Records County level Felony and misdemeanor criminal history Based on zip codes provided by applicant State and Federal Criminal Records Name check for criminal history at State and Federal level repositories County and Federal Civil Records County and Federal records check for lawsuit involvement Liens and Judgment History Workers Compensation Search Discovery of any workers compensation claims in a particular state Social Security Number Verification Validate SSN and applicant's legal name Credit Report Credit History report covering previous seven years DMV Record Verify valid driver's license Identify derogatory driving history (traffic tickets, accidents, DWIs) US Bankruptcy Search Federal index search for Chapter 7 and Chapter 13 bankruptcy filings Formal Education and Degree Verification Degree and date earned (or in progress) GPA. Contact to verify Military Record U.S. Military service records Rank and discharge status Professional License and Certification Verification Type of license, status, date of issue, expiration, and any noted disciplinary action Professional References Telephone interviews of references to verify applicant's work performance and character Drug Screening Applicant drug testing (outsourced to lab)

The costs and complexities of data integration have been greatly reduced by using XML as a common data-exchange format. However, without the right tool and the knowledge to use it, data mapping between relational and hierarchical structures can be intimidating and time-consuming. This intermediate, instructor-led, online class provides an in-depth look at how to use Altova MapForce to visually create and execute data mappings between relational databases and XML. It provides an overview of the database support features available within MapForce, and explores the issues that arise in mapping relational structures to hierarchical XSD. Register for this FREE class today!

Altova DatabaseSpy 2007 is the unique multi-database data management, query, and design tool from the creators of XMLSpy. DatabaseSpy connects to all major databases, easing SQL editing and database structure design, for a fraction of the cost of single-database solutions. Its straightforward Project Manager organizes connections and related files to make accessing your databases and their components effortless. You can even open connections to multiple databases at once. The Database Browser clearly presents your tables, views, and data in easily negotiable windows. The DatabaseSpy SQL Editor facilitates query writing with capabilities like code completion, syntax coloring, drag & drop construction, and more. And the powerful Database Design Editor enables graphical design and visualization of database structures or schemas. You can also use it to duplicate existing structures in differing database types. DatabaseSpy supports Microsoft SQL Server 2000 and 2005, Microsoft Access 2003, Oracle 9i and 10g, IBM DB2 8.x and 9, MySQL 4.x and 5.x, and Sybase 11, as well as other ADO or ODBC databases. It exports data in five formats, including XML, XML Structure, CSV, HTML, and Excel, and it imports data from CSV files. With all this capability and more, DatabaseSpy is sure to save you time, simplify your work, and ensure accuracy for all your data. It is the one tool to finally liberate data management. Do data differently! Download Altova DatabaseSpy today, and try it free for 30 days.

Oxygen offers support for importing database data, MS Excel files and text files into XML documents, that can be further converted into other formats using the Transform features. The user can examine the database contents and select the table to be exported using the database browser. It is possible to refine the data source by editing the generated SQL select statement in order to join multiple tables or to use advanced SQL expressions. Oxygen can generate an XML Schema from the database structure.

This tutorial covers accessing Relational Data as XML. The following topics are covered: Overview of Database to XML Data Sources, Creating a Database to XML Data Source, Specifying Connection Settings, Using an ODBC Data Source in Stylus Studio, Working with Scenarios, Composing SQL/XML in Stylus Studio, Working with Relational Data as XML, Using the URL Builder.

This tutorial covers: An overview of DB-to-XML data sources, opening a New DB-to-XML data source document, specifying connection settings, working with scenarios, composing SQL/XML in Stylus Studio, and Working with relational data as XML as well.

This is a tutorial on hierarchical structures, their semantics, and operational principles. It explains how nonprocedural 4GLs like SQL can process multi-leg structures automatically by utilizing the semantics in the structure being processed. The process of being able to process multi-leg queries automatically means that any query posed against a multi-leg structure can be processed nonprocedurally and the user does not have to be knowledgeable of the hierarchical structure. XQuery being more procedural requires that hierarchical multi-leg query logic be specified to indicate how the multiple legs need to be related in order to properly hierarchically process the query. This means the coder of the query also has to be knowledgeable of the hierarchical structure being processed. Multi-leg queries are hierarchically complex to process and require Lowest Common Ancestor (LCA) logic. Procedural queries require this logic to be specified externally, while nonprocedural queries perform this logic automatically internally. This tutorial describes this hierarchical processing and much more.

Analysis At its annual analyst conference last week, IBM announced its next generation database. The big news is that this will not be a relational database. Or, to be more accurate, it will not just be a relational database.

In this fifth article in the series about managing content in an employee workplace, the author describes how the team designed and implemented a sample Web portal application to support the authoring tasks for the document management scenario called Analyst research reporting. The scenario is about employees collaborating to author, review, and publish research reports accessible to every employee in the company.

Learn how to use databases on mobile devices.