文件列表:

emproc.sql (166, 1997-05-26)
main.dfm (10626, 1997-05-26)
main.pas (11040, 1997-05-26)
ora.dof (478, 1997-05-25)
ora.dpr (181, 1997-05-25)
ora.res (876, 1997-05-25)
Ora32.cfg (502, 1997-05-26)
orademo.dof (478, 1997-05-26)
orademo.dpr (185, 1997-05-25)
orademo.dsk (3424, 1997-05-26)
orademo.res (876, 1997-05-25)

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

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：