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

On 3: how's typing "ed" (without the quotes...) in a plus session?
Or learn sqlplus:
l2
c/bla/"bla"
/

Would List line 2, and Change the (1st) occurance of bla in "bla". The slash on the lst line would execute what's in the buffer.

--
Frank
Stefan Grundmann <s.grundmann_at_t-online.de> schreef in berichtnieuws
8qatvj$b6d$11$1_at_news.t-online.com...


> 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

> >

> >

>

>