Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Tham khảo tài liệu 'oracle database 10g the complete reference phần 2', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 118 Part II SQL and SQL Plus If the file already exists you must use the replace option abbreviated rep of the save command to save the new query in a file with that name. For this example the syntax would be save fred.sql rep Alternatively you could append to the fred.sql file with the command save fred.sql app. store You can use the store command to save your current SQL Plus environment settings to a file. The following will create a file called my_settings.sql and will store the settings in that file immỊst ore set my_settings.sql create If the my_settings.sql file already exists you can use the replace option instead of create replacing the old file with the new settings. You could also use the append option to append the new settings to an existing file. Editing Everyone has a favorite editor. Word processing programs can be used with SQL Plus but only if you save the files created in them in ASCII format see your word processor manual for details on how to do this . Editors are just programs themselves. They are normally invoked simply by typing their name at the operating system prompt. On UNIX it usually looks something like this K vi fred.sql In this example vi is your editor s name and fred.sql represents the file you want to edit the start file described previously was used here only as an example you would enter the real name of whatever file you want to edit . Other kinds of computers won t necessarily have the prompt but they will have something equivalent. If you can invoke an editor this way on your computer it is nearly certain you can do the same from within SQL Plus except that you don t type the name of your editor but rather the word edit SQL edit fred.sql You should first tell SQL Plus your editor s name. You do this while in SQL Plus by defining the editor like this define _editor vi That s an underscore before the e in editor. SQL Plus will then remember the name of your editor until you quit SQL Plus and allow you to use it anytime you .
