Re: Rename a Oracle table

Tim Kearsley wrote:

<snipped>

Some of what you say is true. However, it is VERY obvious when someone does not even bother to read the manual.

How to rename a table is one of them. How to select a column into a variable in PL/SQL is another.

People like that, do deserve the odd lead pipe in the face.

What is the _FIRST_ thing that most of us do when we hit an Oracle problem?

Post to this newsgroup?

Nope. Like many others, my browser home page is the Oracle HTML documentation.

If I can not remember how to rename a table, I use it. It is a SQL command. So it will be discussed in the SQL Manual. Less than a minute later, I will have the syntax for the RENAME SQL command displayed.

A problem with SQL*Loader? SQL*Plus? Export? Import? Each of these are covered, and covered well.

No is saying to read every single page of a 1000 page Oracle manual, and read every one of the 10+ odd Oracle manuals. But is is UTTER STUPIDITY to say that because of the size and volume of these manuals, you can not be bothered to use it. For heavensakes, each manual has a title. SQL syntax will be in the SQL Manual. No rocket science needed. Each manual comes with an index.

A person that can not use a manual properly. Can not use the manual's index. Can not associate his problem of how to rename a table (a SQL command) with the SQL manual... will you employ a person like that Tim?

A person that runs to this newsgroup when he does not know how to rename a table, is FRIGGEN LAZY. Period.

I for one, like Sybrand, refuse to spoon feed leeches.

RTFM.

--
Billy