| More newbie questions... [message #4012] |
Fri, 01 November 2002 14:53  |
Michael Wilusz
Messages: 4
Registered: November 2002
|
Junior Member |
|
|
Here's some more things that have me stumped...
How can I just print the full table to the screen?
Let's say I have SSN as a number, how do I change it to charvar2 without doing the table over?
How do I change a column title from SSN to Social Security for example.
Thanks a ton!
-Mike
|
|
|
|
| Re: More newbie questions... [message #4013 is a reply to message #4012] |
Fri, 01 November 2002 15:58  |
Todd Barry
Messages: 4819
Registered: August 2001
|
Senior Member |
|
|
I assume we're talking SQL*Plus here. To see the table, just:
To change the datatype:
sql>create table t (ssn number(9));
Table created.
sql>insert into t values (123456789);
1 row created.
sql>alter table t add (ssn_temp varchar2(9));
Table altered.
sql>update t set ssn_temp = to_char(ssn, 'FM000000000');
1 row updated.
sql>alter table t drop (ssn);
Table altered.
sql>alter table t add (ssn varchar2(9));
Table altered.
sql>update t set ssn = ssn_temp;
1 row updated.
sql>alter table t drop (ssn_temp);
Table altered.
sql>select * from t;
SSN
---------
123456789
sql>column "Social Security" format a15
sql>select ssn "Social Security" from t;
Social Security
---------------
123456789
1 row selected. |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
