Home » SQL & PL/SQL » SQL & PL/SQL » sql prompt
sql prompt [message #194876] Mon, 25 September 2006 18:52 Go to next message
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?
Re: sql prompt [message #194889 is a reply to message #194876] Mon, 25 September 2006 23:36 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member



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

Thumbs Up
Rajuvan
Re: sql prompt [message #194895 is a reply to message #194876] Tue, 26 September 2006 01:20 Go to previous messageGo to next message
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



Re: sql prompt [message #194899 is a reply to message #194876] Tue, 26 September 2006 01:43 Go to previous message
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: Wed Dec 07 02:58:24 CST 2016

Total time taken to generate the page: 0.09669 seconds