$ 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 just to annoy more
SQL> select * from [...]
updatedb and locate are parts of the findutils package, which exists since a long time on most unix / linux flavors.
Something I never get worked is to search for files on network drives with Cygwin, I always got :
find: /cygdrive/y/Favorites/Links/del changed during execution of find (old inode number -474324984, new inode number -44545478
4, filesystem type [...]
How to detect cycling records in 9i, remember CONNECT BY NOCYCLE does not exist in 9i
SQL> create table lsc_t as
2 select 1 parent, 2 child from dual
3 union all select 2,3 from dual
4 union all select 4,5 from dual
5 union all select 5,6 from dual
6 union all select 6,4 from dual;
Table created.
SQL> select parent,child
2 from lsc_t
3 where level=50
4 connect by parent=prior child
5 and level<=50
6 and [...]
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 [...]
I just notice on Sven Blog that 11.1.0.7 is available. I have recently upgraded my connection at home so it took a bit less than half an hour to download this 1.5G patchset
$ wget -O p6890831_111070_Linux-x86-64.zip http://oracle-updates.oracle…
–10:17:40– http://oracle-updates.oracle.com/ARUConnect/p6890831_111070_Linux-x86-64..
Resolving oracle-updates.oracle.com… 87.248.199.23, 87.248.199.24
Connecting to oracle-updates.oracle.com|87.248.199.23|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 1,613,366,248 (1.5G) [application/zip]
100%[==================================>] 1,613,366,248 [...]
SQL is a case insensitive language. That means, you can write any SQL statement in uppercase or lowercase.
SQL> SELECT DUMMY FROM DUAL;
D
-
X
SQL> select dummy from dual;
D
-
X
Some formatters like Toad and some courseware like Skillsoft E-Learning advise to use UPPERCASE for commands and lowercase for tables and columns.
/* Formatted on 2008/09/19 10:00 (Formatter Plus v4.8.8) */
SELECT [...]
Congrats to Denes Kubicek for being the first journeyman on OTN.
OTN stars Justin and Nicolas (18954 and 15321 posts) do not get this title, as we Oracle Ace are sticked to our Ace logos. OTN upgraded the forums recently, many posts about this :
OTN Forums - Change the look and feel yourself
OTN Forums Update - [...]
one colleague just showed me how to insert duplicate rows in a table that has a primary key.
create table t(x number primary key);[F5]
Table created.
insert into t values (1);[F5]
1 row created.
insert into t values (1);[F5]
1 row created.
Hey, what happened? It took me quite a while to figure out which feature of Toad was “allowing” this.
Let’s [...]
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 lpad('c',4000,'c') c,
5 lpad('d',4000,'d') d
6 from dual connect by level<10000;
Table created.
SQL> create index i on t(id);
Index created.
SQL> alter table t [...]
What is the difference between rollbac and rollback?
SQL> create table t as select 1 x from dual;
Table created.
SQL> update t set x=2;
1 row updated.
SQL> savepoint a;
Savepoint created.
SQL> update t set x=3;
1 row updated.
SQL> rollbac to savepoint a;
Rollback complete.
SQL> select * from t;
X
———-
1
WTF! rollbac does not seem to work correctly
Actually, ROLL, ROLLB, [...]