tailieunhanh - Oracle Database 10g The Complete Reference phần 2

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 rep Alternatively you could append to the file with the command save 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 and will store the settings in that file immỊst ore set create If the 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 In this example vi is your editor s name and 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 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 .

Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.