Month: October 2008

duplicate of echo does not accept end of arguments operator

Let’s start with an example : $ cat AI #!/usr/bin/bash while : do echo “What’s your name ?” read a if [ ! $a ] then break fi echo “Your name is :” echo $a echo done echo “Bye” $ ./AI What’s your name ? Jo Your name is : Jo What’s your name ? […]

Have fun with this caps-lock user question : asktom:Logic behind the DENSE_RANK This is one more statement on how to not use order by like in select ename, deptno, row_number() over (order by 1) from emp order by 2; ENAME DEPTNO ROW_NUMBER()OVER(ORDERBY1) ———- ———- ————————– CLARK 10 1 KING 10 2 MILLER 10 3 JONES […]

Whether you need to write in Chinese אני אוהב אותך Reverse your characters ʎuunɟ Play some chess ♔ or do some maths ≲∀∃∄∑ Unicode can helps you. It can be stored in the database, in email, in plain-text files. Read more : – Unicode Home Page

Note: Performance Tuning Guide Stored outlines will be desupported in a future release in favor of SQL plan management. In Oracle Database 11g Release 1 (11.1), stored outlines continue to function as in past releases. However, Oracle strongly recommends that you use SQL plan management for new applications. SQL plan management creates SQL plan baselines, […]

I just downloaded and installed osdm Have a look at my first screen of the ERD generated from my Scott schema

$ sqlplus scott/tiger@DEVL SQL> select * from all_db_links; no rows selected SQL> select * from dual@PROD; D – X Hey, why does this work??? Ok, after some research I found out that this seems to be an implicit loopback database link. The fact that the DEVL database has the global name set to PROD is […]