LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices


Reply
  Search this Thread
Old 02-12-2003, 06:37 PM   #1
stephstellar
Member
 
Registered: Jan 2003
Location: Leeds, UK
Distribution: Knoppix (for now...)
Posts: 154

Rep: Reputation: 30
SQLplus command editor under UNIX - how??


Hi, I just started learning SQLplus (oracle) at uni. In the PC labs we use it under Windows, so use notepad as a command editor or to save queries, and all the lecture notes/workshop booklets are tailored to windows, but to access the sample databases from home (or anywhere outside that building, for that matter) we have to telnet straight into the main UNIX server.
My question is - how do I use the command editor? I'm a haphazard typist and keep making mistakes, and it's a real hassle having to type to whole command out again. I think it's wordstar or something. There are 2 lines on using it (how to start it but not how to save, exit or anything!) in our workshop book and the tutor is incommunicado...
Any pointers?
 
Old 02-12-2003, 08:07 PM   #2
moeminhtun
Member
 
Registered: Dec 2002
Location: Singapore
Distribution: Fedora Core 6
Posts: 647

Rep: Reputation: 30
Well, I've used Oracle before in the Solaris Lab back in Uni. According to what I vaguely remember,

Suppose this is your last sql quary.

SQL > select * from dogs.

you can save your last sql quary using "save" command. You can give any name. For example

SQL > save mydogs.sql

Then your last sql quary will be saved as "mydogs.sql" text file into your home directory.

You can invoke back the "mydogs.sql" files using the "start" command.
SQL > start <filename.sql>
For example,

SQL > start mydogs.sql

To edit the .sql files in your home directory, you can use any Unix editor and then edit and save it back. And ofcourse you can also create a new file and save it. Then you can just invoke using "start" command.

SQL > start <filename.sql>

Last edited by moeminhtun; 02-12-2003 at 08:08 PM.
 
Old 02-13-2003, 10:39 AM   #3
stephstellar
Member
 
Registered: Jan 2003
Location: Leeds, UK
Distribution: Knoppix (for now...)
Posts: 154

Original Poster
Rep: Reputation: 30
Thanks, that's a lot of help. Now I just need to know...
1. will queries I save in a unix session be accessible during a windows session, and vice versa? (I guess I could just try that one!)
and 2. How do I save and quit wordstar?? They really don't give us a lot to go on round here...)
 
Old 02-13-2003, 11:43 AM   #4
moeminhtun
Member
 
Registered: Dec 2002
Location: Singapore
Distribution: Fedora Core 6
Posts: 647

Rep: Reputation: 30
hmm..I'm not sure about that. I've never used wordstar before. Or you can try other editors like vi or emacs if you are familier with them. If not,

Anybody out there used wordstar before?

 
Old 05-26-2003, 10:50 AM   #5
stephstellar
Member
 
Registered: Jan 2003
Location: Leeds, UK
Distribution: Knoppix (for now...)
Posts: 154

Original Poster
Rep: Reputation: 30
Thanks VERY MUCH for your help, I got an A in my assessment which I couldn't have done without being able to use Oracle from home! Just got the darned exam tomorrow now...
 
Old 05-27-2003, 08:49 PM   #6
moeminhtun
Member
 
Registered: Dec 2002
Location: Singapore
Distribution: Fedora Core 6
Posts: 647

Rep: Reputation: 30
That's cool.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Command and Unix help thinkgeek Programming 3 07-05-2005 01:24 AM
sqlplus command from script Grassie Coetzee LinuxQuestions.org Member Intro 2 03-13-2005 12:01 PM
win text editor that saves unix format novaprime Linux - Software 7 01-15-2005 04:30 PM
unix command to linux command leonidas Linux - General 1 09-10-2004 12:40 AM
vi as Command Line Editor taz75 Linux - Newbie 8 01-04-2002 01:30 PM

LinuxQuestions.org > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 05:32 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration