Re: ok, now don't laugh.....

From: Stefan Grundmann <s.grundmann_at_t-online.de>
Date: 2000/09/20
Message-ID: <8qatvj$b6d$11$1@news.t-online.com>#1/1

Hallo Jim!

To question #1:
user the l(ist), c(hange), r(un) commands under SQL*Plus with the line number
SQL>create table blabla(

      > col1 Varchar2(10)
      > col2 number(5)
      > )

SQL> l2
2*>col Varchar2(10)

SQL> c/)/),
SQL> l
SQL>create table blabla(
     2> col1 Varchar2(10),
     3> col2 number(5)
     4> )

SQL> r

To question #2:
use the alter table modify command
alter table jimsmp3files modify (misc varchar2(30));

To question #3:
use the edit command to get your work the editor (win notepad) I prefer writing the SQL-commands directly in the editor and then copy and paste them to SQL*PLus or run the command-file with start file_name.

Hope this help's,
Stefan

Jim Kotsonas <jkotsonas_at_lucidityinc.com> schrieb in im Newsbeitrag: 39c8e879$0$22125_at_wodc7nh6.news.uu.net...
> Howdy,
> Extreme newbie here. I've got a couple of (probably) simple questions
> for you.
>
> I'm gonna be taking some Oracle classes soon, so I'm trying to get a bit
> of a head start. I've downloaded Oracle 8i (lite) from the Oracle site,
> and I'm stumbling through some on-line tutorials.
>
> Question #1 is: First, is there some kind of shortcut for editing a
> previous
> line of text? I've created a table, and when I update/change it, by the
 time
> I
> get to lines 3 or 4, I find that I need to go back to line 2 to insert an
> "'". I can't
> seem to do this without starting all over. Second, when I created the
 table,
> (the table is jimsmp3files, and there's 3 rows; Artist, Song title and
> Misc.
> I set the "varchar" for Misc at (20) which ended up being too short.I'd
 like
> to
> update it to (30), but can't quite figure out how. And thirdly, how
 does
> one
> save one's work, and then access it again. When I went to "File>save", it
> only saved the last bit that I was working on, not the complete table.
>
> Thanks in advance for any and all help!
>
> Take care,
>
> Jim
>
>
Received on Wed Sep 20 2000 - 00:00:00 CDT