create table one_true_lookup_table (
one_table_to_find_them integer primary key,
) tablespace and_in_the_darkness_bind_them;
The discussions around choice 4 of the 19 March quiz, in particularly those titled "Choice 4's commit is unnecessary" and 'The "last_name" column is unnecessary in Choice 4', made me realize that I need to offer a more explicit definition of what it means for two blogs to have the "same result."
The book OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide by Packt publishing has been published. The book has been authored by Steve Ries and I was the technical reviewer of the book. It was pleasure reviewing the book as the style of presentation, topics coverage and authenticity of content was pretty impressive.
with the_sql_monitor as (
where tuning_pack_license = 'Y'
and the_boss = 'screaming for the result'
where real_time_execution_plans =
'taking !$@# forever to run';
create profile highly_restricted limit
alter user cowboy_developer
Profiles have been superceded by the DB Resource Manager for limiting resource
Somebody was trying to create a striped view based on a table’s
end_date temporal columns. They asked for some help, so here are the steps.
Basically, you create a user-defined data type, or structure:
Previously i showed not obvious example with hint “INDEX_STATS(“OWNER”.”TABLE_NAME”, “INDEX_NAME”, scale, blocks=X, rows=Y)“. Strictly speaking i don’t know how exactly cbo calculates number of index leaf blocks in that case: in those examples they was 1981 for “blocks=1, rows=50″ and 49525 for “blocks=5, rows=10″.
But i know that with “INDEX_STATS(“OWNER”.”TABLE_NAME”, “INDEX_NAME”, scale, blocks=X)” i can set exact blocks number.
Also those test-cases didn’t show when occurs decision changing. So todays my test will show it.
I like Scrabble, for many reasons.
I like words. I like to write. I like to read.
But one of the things I like best about Scrabble is how it is so much like life.
Every time I play a game of Scrabble, something totally amazing about the pattern of play in that game will strike me:
"Check it out! Ten turns and not a single letter E was used!"
"Whoa, that's amazing. Every word that contains an A also contains the letter I!"
and so on.
Oracle processing new SQL statements
Reading ancient Arabic
Both of these are slow and arduous tasks that you don't want to spend more time doing than you have to!
select posts from sqlfail