emperor: (Default)

(no subject)

posted by [personal profile] emperor at 06:28am on 07/02/2005
done, as a large comment of pain.
the @?.... rune was entirely opaque to me, however. Presumably this is some way of outputting the contents of a table where EXPLAIN PLAN sticks its stuff by default?
[parent entry] [link] [parent] [reply]
 

(no subject)

posted by [identity profile] mobbsy.livejournal.com at 06:32am on 07/02/2005
So I see, I'll look through it :-)

"@" is just "source in this file to SQL*Plus" - @foo looks in the current directory for foo.sql and runs it.

"?" is short for $ORACLE_HOME in SQL*Plus

The rest is just a path. If you look in $ORACLE_HOME/rdbms/admin you'll find a lot of SQL scripts, utlxpls.sql is Utility Explain Plan Serial
[link] [parent] [reply]
 

(no subject)

posted by [identity profile] mobbsy.livejournal.com at 06:37am on 07/02/2005
...and looking at the utlxpls script, rather dates me. In 8i it was a big SQL query formatting a "SELECT ... FROM plan_table" - in 9iR2 and 10g it just wraps the dbms_xplan package.
[link] [parent] [reply]
 

(no subject)

posted by [identity profile] ex-lark-asc.livejournal.com at 07:24am on 07/02/2005
rather dates me

Now I have this weird mental image of you being asked out by a database management system.

I really don't want to think about how databases shag.
[link] [parent] [reply]
emperor: (eye)

(no subject)

posted by [personal profile] emperor at 07:28am on 07/02/2005
IRTA "inner join"
[link] [parent] [reply]

October

SunMonTueWedThuFriSat
      1
 
 2
 
 3
 
 4
 
5
 
 6
 
 7
 
 8
 
 9
 
 10
 
 11
 
12
 
 13
 
 14
 
 15
 
 16
 
 17
 
 18
 
19
 
 20
 
 21
 
 22
 
 23
 
 24
 
 25
1
26
 
 27
 
 28
 
 29
 
 30
 
 31