SQL Assistant Anons
From: Denis V. Berdnikov <doc_at_takthq.lipetsk.su>
Date: Sat, 22 Aug 1998 22:26:06 +0400
Message-ID: <6rkee9$a2o_at_news.lipetsk.su>
<This text was translated from Russian by Stylus>
SQL Assistant - program, which can facilitate a daily transactions the developer of applications for the Oracle server. She allows to execute main DML, DDL of sentence. The outcome of execution is represented as the table, which allows navigate to edit selected data and to output them in the file or on the printer. In the given version of the program it is not enough new, especially revolutionary ideas. She is constructed on a principle
"all best for convenience".
In it the advantages of such produced programs both are assembled SQL*Plus (c) Oracle Corp., Database Explorer (c) Inprise Corp.
The server: Oracle 7.1 also is higher (SQL*Net 2 server part) The client - Windows 95 (SQL*Net 2 client part, large fonts)
On the server to start scripts:
sqlassist.sql (see comments inside script) and setenvassist.sql (each of the users SQL Assistant) - optional.
<Shift> - <Enter> to execute SQL-sentence
<Ctrl> - <Break> to interrupt execution
<Tab> to proceed in the table " an outcome of execution "
<F8> to enter new SQL-sentence
<Ctrl> - <Up> to select the previous sentence in the stack
<Ctrl> - <Down> to select the following sentence in the stack
<Ctrl> - <Enter> to proceed to the following string(line)
of editing of SQL-sentence
<Ctrl> - <Tab> to enter character of tabulation
<Ctrl> - {<c> | <v> | <z> | <a>} as is usual
LeftClick on header of a column - saving of width and title of a column
In the present version of the program the demo-components are used DOA (Â) Allroundautomations, therefore she cannot be the goods!
I shall be glad to accept the remarks and sentences on operation of the program.
E-mail: doc_at_takthq.lipetsk.su
Tel: (0742) 47-0960 (employ)
(0742) 74-1884 (home).
Date: Sat, 22 Aug 1998 22:26:06 +0400
Message-ID: <6rkee9$a2o_at_news.lipetsk.su>
<This text was translated from Russian by Stylus>
Readme SQL Assistant (c) 1998 Denis Berdnikov
The description
SQL Assistant - program, which can facilitate a daily transactions the developer of applications for the Oracle server. She allows to execute main DML, DDL of sentence. The outcome of execution is represented as the table, which allows navigate to edit selected data and to output them in the file or on the printer. In the given version of the program it is not enough new, especially revolutionary ideas. She is constructed on a principle
"all best for convenience".
In it the advantages of such produced programs both are assembled SQL*Plus (c) Oracle Corp., Database Explorer (c) Inprise Corp.
The requirements
The server: Oracle 7.1 also is higher (SQL*Net 2 server part) The client - Windows 95 (SQL*Net 2 client part, large fonts)
Installation
On the server to start scripts:
sqlassist.sql (see comments inside script) and setenvassist.sql (each of the users SQL Assistant) - optional.
Hot keys
<Shift> - <Enter> to execute SQL-sentence
<Ctrl> - <Break> to interrupt execution
<Tab> to proceed in the table " an outcome of execution "
<F8> to enter new SQL-sentence
<Ctrl> - <Up> to select the previous sentence in the stack
<Ctrl> - <Down> to select the following sentence in the stack
<Ctrl> - <Enter> to proceed to the following string(line)
of editing of SQL-sentence
<Ctrl> - <Tab> to enter character of tabulation
<Ctrl> - {<c> | <v> | <z> | <a>} as is usual
LeftClick on header of a column - saving of width and title of a column
Limitations
- With execution of simplis or external connection
SELECT
Tab1.field1,
Tab2.field1
FROM tab1, tab2
WHERE tab1.id = tab2.id (+)
the fields by first indicated in a phrase FROM can be subject to upgrade the tables, i.e. tab1. If you want to update fields tab2 - put it on the first place.
- The excessive use of blanks can reduce to nonupdatable query
In the following version will be included
- Help on F1
- Support of data-ins
- Compilation of the comments of sort /* hints */ and --
- Saving the "last" name and connect string
- Saving about following columns
- Possibility of use of blanks in any place of sentence
The note
In the present version of the program the demo-components are used DOA (Â) Allroundautomations, therefore she cannot be the goods!
The conclusion
I shall be glad to accept the remarks and sentences on operation of the program.
E-mail: doc_at_takthq.lipetsk.su
Tel: (0742) 47-0960 (employ)
(0742) 74-1884 (home).
Doc.
Download from
ftp://ftp.lipetsk.ru/pub/windows/Oracle/SQLAssistant/sqlassist.zip
Received on Sat Aug 22 1998 - 20:26:06 CEST