OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » sql prompt

Mon, 25 September 2006 18:52

ypoonawala1987
Messages: 2
Registered: September 2006
Location: India

Junior Member

how can we change the SQL> prompt?
how can rename a column in a table?
when was PL/SQL implemented and by whom?

Mon, 25 September 2006 23:36

rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India

Senior Member

Search in Google for SET SQLPROMPT ,ALTER ... RENAME commands ...

Thumbs Up

Rajuvan

Tue, 26 September 2006 01:20

be2sp1
Messages: 52
Registered: September 2005
Location: India

Member

Hi,

You can use the following statements to get your thing done.

Set SQLPROMPT 'XYZ >';

alter table xyz rename column a to b;

Regards

Tue, 26 September 2006 01:43

orafaqer
Messages: 48
Registered: July 2006

Member

ypoonawala1987 wrote on Tue, 26 September 2006 03:52

how can we change the SQL> prompt?
how can rename a column in a table?
when was PL/SQL implemented and by whom?

1988.
By Oracle Corp. Smile

Previous Topic:	How increase the speed for query
Next Topic:	I have a little problem in Oracle 10g Database For Windows

Goto Forum:

]

Current Time: Thu Dec 12 07:57:01 CST 2024