Search results for query: *

Ooooh, good one, Santa! That is star quality.

John, I believe what Ken is suggesting is that when we are grateful for the efforts or suggestions of others here on Tek-Tips, the method of expressing that gratitude is both by cordial acknowledgements such as yours and by clicking the [Thank <poster_screen_name> for this valuable post!] link...

I should have been more explicit about my operating system (besides relying upon the direction of my path slashes..."/"...to signify my using a *nix environment). All of the suggestions, above, are very clever methods of defining the default path for SQL*Plus to use. As a result, please accept...

If the current path that SQL*Plus checks, as a default, to resolve scripts (as in "@<script>") is path "/x/y/z", what change can I make, for my SQL*Plus session only, to use as my new default path, "/a/b/c"?

DrD, Thanks for your response...I'll try out your suggestions in a few minutes after I put out another brush fire. [banghead] In short answer to your earlier questions: Yes, we have SQL*Plus (in which I'll try your code). Here are the results of an o/s "uname -a":Linux <domain> 2.6.9-5.ELsmp...

When I run "top" in *nix, there are about a dozen processes that are running between 80%-100% CPU utilization on an 8-CPU box. They are all processes logged in as Oracle. Customers are starting to complain. We are not presently running Oracle Enterprise Manager. What queries can I run (as a...

This is the second time in as many weeks that I have encountered problems with database-link references within a PL/SQL block, while the problem does not exist at the SQL prompt. Note, below, the successful DESCRIBE of the "submissions" table via the database link, "mss":SQL> desc...

Hello all you amazing contributors. I apologize for my tardiness and delay in getting back to you. I have been traveling and had my finger in several pots that took me away from Tek-Tips for a while. However the results are in and I have established the corporate identity of.... drum roll...

sxschech, First, let me ask about the intermediate and final totals: Those rows seem to be in your data already rather than calculated...is that correct? If so, do you want the query to do the correct sub- and final-totaling calculations without the bogus sub and final total rows?

Your intuition, Santa, is hitting on all cylinders. I would not place anything in the SYSTEM tablespace following the install. Since Oracle is deprecating the SYSTEM user, and since I did not want to contrive another user for administrative tasks, and since what I wanted to do was audit/track...

Here are facts about my situation. 1) I am logged into Oracle 10g as the SYSTEM user. 2) SYSTEM user is (as usual) a member of the DBA role, which I have confirmed possesses the CREATE ANY TABLE privilege. I attempt to issue this command:CREATE TABLE SYS.X (Y NUMBER); * ERROR at Line 1...

You all are AMAZING! I'd have to say the front runners thus far are: Surreal Estates Inc., That Really Nice Agent, Inc., and PIF Investments, Inc. How about Pay It Forward Principal Investments, Inc. (with a play on the word principal vs principle). Keep em coming. I have to have my decision...

My neighbor's name was Fillmore Crank. His full name Fillmore Pajeau Crank IV - all by himself!

Thanks for asking. I don't want it associated with my IT business. It will end in Inc. rather than Ltd. and I consider myself a bit of a Rebel - after all I'm a gray haired 48 year old Scuba Diving mom.

I attended high school with a fellow by the name of Harry Tongue IV - to think there were 4 generations of the same name.

You MAI-ers did a remarkable job helping MiniMufasa name her business (thread1256-1128199 ; Winner: KenCunningham's "Proof Positive Inventory" entry, with great honorable mentions from many other MAI-ers). I, too, am eager to benefit from your individual and collective creativity in the naming...

If what Mufsa and Taupirho did what you wanted, then it is customary to give them a purple star...click [Thank <them> for this valuable post]

Sorry, I must protest: I say Cajun's answers and explanations are always the perfect-lier-est of all!...Donit just roll off the tongue?

Seyfert, Yes, Mufasa has been extremly helpful to me too, and similar to Ebay there is a way to leave positive feedback. I always remember to give Mufasa (and other helpful Tek-tipsters) a Purple Star...it sounds like you would like to give him one too. The way you do that is by clicking the...

I'm bumping this thread to the top of the forum since my need is becoming more urgent, and I'm hoping someone has guidance or a suggestion for me. I'm rather surprised that no one has responded yet since I would have thought that this is an "easy" question. (In no way am I being negative or...