Did you ever think you could write something nobody can read ? Submit your query before April 1st to the Oracle SQL Obfuscation Contest… You can also vote there My query : http://www.oraclecommunity…7305
Month: March 2008
Linux 10.2.0.4 for x86_64 is out
While Linux x86_64 just came out, Unix Releases like HPUX, AIX and SunSolaris will probably not be available before third week of April.
Linux 10.2.0.4 for x86_64 is out
While Linux x86_64 just came out, Unix Releases like HPUX, AIX and SunSolaris will probably not be available before third week of April.
alter user identified by values in 11g
I wrote about dba_users changes in 11g . When spooling alter user commands in 11g, it is important to understand the mechanism. Oracle 11g supports both sensitive and insensitive passwords. When issuing an CREATE/ALTER USER IDENTIFIED BY PASSWORD, both the insensitive and the sensitive hashes are saved. SQL> create user u identified by u; User […]
Baton Rouge Oracle User Group
I will be speaking about SQL Model at Baton Rouge Oracle User Group, Thursday, March 20, 2008 from 11:30am to 1:30pm. Check http://www.broug.org for details
Software Configuration Manager
I just noticed today the Web 2.0 interface of metalink : The URL is http://csm.oracle.com, like Coftware Sonfiguration Manager (or maybe Configuration Software Manager). [edit: original name is: Configuration Support Manager] It seems nice, you can customize the portal with drag and drop, their is a blog too http://blogs.oracle.com/supportportal and a feedback button I am […]
Concours SQL
I tried my chance at Le petit jeu des requêtes SQL and yesterday received my price at home. Thanks to the author for organizing the competition 🙂 Next milestone : oraclecommunity.net obfuscation contest
take care of minus !
Imagine this script (10gR2) : set echo on select BINARY_DOUBLE_INFINITY – BINARY_DOUBLE_INFINITY from DUAL; Run it and you would will get an expected result! SQL> select BINARY_DOUBLE_INFINITY – > BINARY_DOUBLE_INFINITY from DUAL; BINARY_DOUBLE_INFINITY ———————- Inf The issue in sqlplus is that – at the end of line means “query continues next line”. The correct answer […]