Sneakpeek explanation and summary for comp.databases.oracle.misc

From: <sneakpeek_at_talkway.com>
Date: 1998/08/20
Message-ID: <EPTC1.1917$Mw1.925058@c01read01.service.talkway.com>#1/1

We developed SneakPeek postings as a result of many Usenet users' desire for a summarizing tool that would help them skim through the most active threads. Thus, SneakPeek postings are intended to help users with limited time keep abreast of group discussions, stay in touch with more groups, and check out new groups quickly.

Usenet is an environment where every voice should count equally. However, while some users have found SneakPeek postings useful, others have tried to shout it down, potentially resulting in the tyranny of a vocal few. Therefore, we encourage all to post their constructive opinions so that we may democratically decide if there is room for SneakPeek postings in Usenet.

Talkway, Inc.
http://www.talkway.com

The rest of this message summarizes the most active recent threads in this newsgroup.

SUBJECT: SQL-HELP

Steve Wood: Is there an equivalent in SQL to the case statement in C ?

Thanks in Advance
Steve

Ken Madsen: The closest thing is the DECODE statement. Abbrev. syntax:

DECODE(Column, test_value1, return_value1, default_value)

You can add many more (test, return) pairs before the default value. And the default value is optional.
...

Arjan van Bentem: ... Try decode:

decode( my_col, 1, 'A', 2, 'D', 3, 'D', 4, 'C', 'Z' )

returns 'A' if my_col = 1, 'D' if it is 2, etc., or 'Z' if no match is found. You can not use decode in PL/SQL.

SUBJECT: Re: career advice

Michael Levitin: ... I think, it's a "blend alley" : IMHO, it's unpossible to get real knowledge not on ÅÒÕ real systems. In this case, you can configure your Oracle DB forever, but if you have not practice in a real environments - it's poor job. Only real practice on the real systems can made real DBAs.
Paul Sian: ... So what exactly are a DBAs responsibilities?
Paul Sian: ... So what exactly are a DBAs responsibilities?

SUBJECT: Why is query time SLOW on NT?

PERRY: Hi all,

I am running Personal Oracle 8 on a dual 200 Pentium pro NT system. It has plenty of fast disk storage and 128mb RAM. Should be fast, right? Not with Oracle!
...

Prasad Chavali: Well there a lot of things you can look into to make the database query faster. There is a manual on Oracle Tuning. No matter how big the machine is if the right resources are not allocated to the database it will not perform to your expectations.
Jerry Gitomer: Hi Perry,

I just ran the query on a four processor Pentium and counted a 38500 row table in under three seconds. I have my init<sid>.ora parameters all set to large -- and then some :-) Edit the init file and set everything to large. shutdown the database and then start it up and

SUBJECT: Access front-end to Oracle - How to?

Paolo F. Cantoni: We have a Human Resources Database which also handles Organisational Structure among multiple Business Entities if required. It is currently written in Microsoft Access and has separate Application Database and Data Database. The data is fully normalised and consists of over 130 tables. ...
James Arvigo: I suggest that you look into products by Embarcadero Technologies, Inc. Those would be, "DB Artisan", "ER/Studio", and "Rapid SQL", although you would probably only need "ER/Studio" to do this. http://www.embarcadero.com ...
Paolo F. Cantoni: Hi James,

...
I'll have a look...

BTW, I presume these products would also handle SQL-Server?

SUBJECT: NOT USING A NOT IN SQL

D S Tharpe: What are some equivalent ways of SQL coding to avoid a 'not' in the following sql clause. I'm vaguely familiar with 'exists' and 'minus'. The rule I've heard is never use a not - it takes much longer to return a result. Does anyone have ...
Alan D. Mills: I think the answer will be very much dependent on the specific SQL statement you wish to write (or re-write). You could arguably use an outer join or a MINUS or even a NOT EXISTS to rewrite your example. ...
Keith McKendry: Select t1.c1 from table_1 t1, table_2 t2 where t1.c1 - t2.c2 (+) and t2.c2 is null;

Talkway, Inc.
http://www.talkway.com Received on Thu Aug 20 1998 - 00:00:00 CDT