Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
SQL editor (Read 3174 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
SQL editor
31.05.07 at 22:38:31
 
SQL editor
 
SQL*XL communicates to databases through the SQL language. This Simple Query Language is a powerful language with which you specify what to extract from the database or what to change inside the database.  
 
SQL can be used to extract data by running select statements (DQL). You can also send SQL to insert or update data (DML). Another set of SQL allows you to create database objects such as tables, views, users, etc (DDL). Some databases allow the usage of programming lanugages. Oracle e.g. can process PL/SQL a procedural SQL language. SQL Server uses a different language called T-SQL. These statements can all be executed from the SQL dialog and can be compiled in the SQL editor.
 
The SQL editor is started from the SQL dialog. SQL can already be typed into the SQL dialog. When a better editor is required the SQL editor can be started from the SQL dialog.
 
In the SQL editor you will find a database objects list. You can drag the objects into the editor or right click the objects to let SQL*XL build template SQL statements.
 
Further reading:
 
SQL*XL help files: SQL editor:
http://www.oraxcel.com/projects/sqlxl/help/dialogs/sql_editor/index.html
Back to top
 
« Last Edit: 01.06.07 at 07:49:11 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1