Flying toasters and dense_rank

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

Stored outlines

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, […]

where is my database link listed?

$ 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 […]