The SQL function TRIM has been around since Oracle 8i and maybe earlier. TRIM enables you to trim characters from a character string. The following examples demonstrate its usage and show you a few little known features of this simple function.
Remove leading and trailing blank spaces:
SQL> SELECT TRIM (’ mystring ‘) FROM dual;
TRIM(’MY
——–
mystring
Remove […]
The social network for Oracle people OracleCommunity.net was launched on January 31, 2008. Since then, it has had a tremendous growth. We went from 1 to 2,445+ members in 8 months. Existing features have been enhanced and new features have been added. Features like chat, events and the iPhone version did not even exist when […]
Rather than blog the events of an entire day, I’ve decided to dump my thoughts periodically.
This is more effective for me anyway, since to remember anything lately, I feel like I need to forget something else. So, a memory dump will happen eventually, better (or worse, depending) to get it recorded before the inevitable happens.
Here […]
Oh no, not another post about COUNT(*) and COUNT(1)
Well, it is not exactly the case. I just had the issue this morning that count(*) was too slow.
SQL> create table t as select rownum id,
2 lpad(’a',4000,’a') a,
3 lpad(’b',4000,’b') b,
4 […]
For those of you that were still wondering if cloud computing would really catch on: Oracle and Amazon have just announced that several Oracle products can now be licensed to run on Amazon’s EC2, while backups can be made on Amazon’s S3 web service through the Oracle Secure Backup Cloud module.
One of the big advantages […]
If you are migrating a database with business logic inside (typically SQL Server and Sybase) to Oracle, it can happen that translation process to freeze during converting a particular stored procedure or trigger.
The problem come up when finding lots of IF… ELSE loops inside the stored procedure and this will be solved in the next […]
I finally got around to reading this update from Red Hat about Spacewalk, the open source version of Red Hat Network Satellite, launched in June.
Other than the progress in attracting participants and patches, the interesting news is that PostgreSQL support is being added after being demanded by the community. The roadmap confirms that work on […]
If you use Firefox, you’re in for a treat. If not, please download it and resume reading about Ubiquity and how you can use it to query the Oracle database documentation library and do other neat stuff using simple commands.
Jake was struggling to define it, but basically, Ubiquity is a Firefox extension, a powerful one. […]
I have packaged and released version 0.2.3 of gerald. This is mainly a tidy up and bug fix release, with numerous additional unit tests. You can find all of the details in the CHANGELOG.txt file that comes with the source distribution (or view it here) but in a nutshell the changes from the last release […]
If you have a datawarehouse and the data are getting to big for a full duplicate or tablespace transport, if you want to experience more about Streams or simply if you are in San Francisco and wants some distraction on Thursday after at 1pm, do not miss Chen session Oracle Streams - Live Demo
Oracle OpenWorld […]