Lewis Cunningham has worked with the Oracle database in numerous capcacities since 1993. He has been a developer, team leader, designer, architect and DBA in both employee and consulting roles. He is currently building high performance, high capacity DSS and operations analytics database applications for a large financial services company in St Petersburg, Florida. Lewis specializes in designing highly maintainable applications using Oracle-provided functionality such as XML, AQ and advanced SQL and PL/SQL.
Do you have a question for our experts?
Contributions from Lewis Cunningham, Senior Oracle DBA
- Log execution time for a procedure
- Loading data into Oracle
- Detect if a column is NUMBER or VARCHAR2 in PL/SQL
- Hiding objects in a schema
- Query for five most recent dates
- Connecting with Visual Basic
- SQL ANSI standards and compliance
- Developing a parser for recognizing HTML tags
- Concatenating XML fragments
- Oracle and SOAP
- Two schemas on a single database
- Generating XML from stored procedures
- Controlling bandwidth used by XML
- Changing the tablespace for an XML schema
- Using XML and Oracle together
- Stored procedures in concatenated XML
- CLOB string too long
- Rolling back Oracle XSU
- Is there a way to see XML data using SQL?
- Displaying time, including milliseconds