📄 readme.txt
字号:
Author Huet Bartels
Verion Delphi CS 2.0
Date 27/05/97
Purpose To show you how to uses some of the Oracle Functions,
Stored Procedures,and standard Select Statements.
Mail Huet1Cix@Compulink.co.uk (Home)
Mail Huet1@mdx.ac.uk (Work)
This demo is freeware, do what ever you what with it.
I would like feedback, to keep this demo upto date, if
you have any examples of functions or routines I have not used
please mail me them so I can add them to the demo.
Or just email me your thoughts about the demo anyway.
Thankyou
Huet
-----------------------------------------------------------------------
What does the demo show.
1) It shows 3 queries
a) A simple select statement
b) A simple join statement
c) A simple join & where clause statement
2) It shows some of the Oracle Functions
a) USERENV
b) TO_CHAR/TO_DATE
c) INITCAP/LOWER/UPPER
d) LAST_DAY/NEXT_DAY
e) COS/COSH/SIN/SINH
3) It show how to execute a stored procedure
-----------------------------------------------------------------------
How to get the demo work.
You will need the C/S version of Delphi.
You will need to config the BDE you use the Oracle Driver
I have include a BDE CFG file, if you use the ORA32.CFG you will
need to change the following fields.
1) Server Name. **If you are using SQL*NET 2 make sure you
have the .WORLD added after the server name
2) NET PROTCOL should be TNS if using SQL*NET V2 otherwise TCP/IP or
what ever you default protocol is
3) VENDOR INIT Change it to match you version of Oracle ie ORA72
is for Oracle Version 7.2 ORA73 is version 7.3....
You will also need to execute the Stored Proecdure script named emproc.sql
included with this demo in the SCOTT/TIGER ACCOUNT
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -