Oracle SQL 编程最佳实践

11g for application developee.. enjoy

下面实例在C#中连接Oracle数据库(Name),从表(TableName)中读取数据,并写入Excel。(following examples in C# Oracle database connectivity (Name), (TableName) to access data, and write Excel.)

说明：  oracle高级sql培训和讲解文档，内容都是干货(Oracle advanced SQL training and explain the document, the content is dry goods)

链接oracle数据库,使用proc方法，进行过测试，不过我是新手不能配置成功(Link oracle database, use the proc method has been tested, but I can not be configured novice)

说明：  国家统计局的省市区镇村五级联动数据库表sql脚本(SQL script of five-level database tables for towns and villages in provinces, municipalities and cities of the State Statistical Bureau)

oracle 拼音码函数，能提取汉子拼音的首字母，全部拼音等。(oracle phonetic code function, can extract the man the first letter of the alphabet, all Pinyin.)

Oracle Database 10g PLSQL程序设计源代码(Oracle Database 10g PLSQL code)

仓库管理系统，使用access完成，大学课程设计，具有登陆功能，在进入系统后可进行仓库数据维护、查询等功能。(Warehouse management system, using access to complete design of university courses, with a visit, warehouse data maintenance, query and other functions into the system.)

说明：  主要介绍了数据库的相关使用介绍，非常实用。(This paper mainly introduces the related usage of database, which is very practical.)

数据库同步程序，能够自动更新远程数据库与本地数据库数据，保持同步。(Database synchronization program to automatically update the remote database with local database data, and to keep pace.)