Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating table in SQL plus with notepad

ce3e5a7e-6bf8-45fa-babf-0b4c9959101eJan 27 2018 — edited Jan 28 2018

I cant create a table in SQL plus with many columns as the control goes to the next line and every time I do this I get an error.How do I use the ed command to open the notepad and type the commands there?

The error I am getting is for example,

1. create table(column1 dataype,.......................................,column8 datatype--------------->at this point control goes to the next line

2.column9 datatype);

But when I execute the whole thing I get an error.

Anyone who understands my doubt pls answer as I have an exam coming up.It would be really appreciated if you help

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2018
Added on Jan 27 2018
14 comments
1,254 views