What if you need to query a stored XML , but it was unfortunately stored as a BLOB instead of a CLOB? You can easily convert it to a CLOB ...

So you decided for some reasons that a BLOB would be a good type choice to store something for which the CLOB was invented, but now you...

In Oracle SQL, you can perform a SELECT from a list of string values using the DBMS_DEBUG package as: SELECT * FROM TABLE(SYS.DBMS_DEBUG...

For those of you forced to use Microsoft Access , thus needing to write bad SQL , here's how you would write an UPDATE table SELECT FROM...

In an usual TIBCO  BusinessEvents  setting, all messages received on a  channel  are automatically mapped to the specified default event , ...

Users accessing Spotfire analysis from the Web Player have the ability to export data in multiple formats (assuming they were given the ne...

With custom expressions in Spotfire, you have more control on how the data is to be handled and displayed. These expressions are also usefu...