Oracle11g入门的教程PPT.ppt

1 目 录 Oracle ERP系统开发工具及开发过程 3 开放式接口 / 应用编程接口(API) 5 如何在系统中注册表单 4 如何在系统中注册报表 6 其它 2 Oracle ERP系统结构 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 1. 三层逻辑体系结构 User Interface Application logic Database logic 客户端 应用服务器 数据库服务器 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 客户端 Use a web browser Netscape Internet Explorer On Windows Macintosh To display Java HTML Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 应用服务器层 Application Server 9i .2 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 数据库服务器层: 8i 9i 9iR2 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Stored Procedures PL/SQL 运行原理 应用服务器 数据库服务器 Web Applications Dictionary Listener Data Browser PL/SQL Gateway 客户端 Workflow Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Java code downloaded as needed Applet cached on client Forms Network Traffic Browser running Forms java applet Data Server Forms Server Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 系统灵活性 历史记录和诊断、检查 用户可以看到当前记录来源于哪个表(视图)、哪个字段和最后一查询的SQL语句等其它的信息。这对客户化开发有极大的帮助。 Custom.pll 开发人员只需客户化此文件，而不需要修改Oracle 的标准程序来达到客户化的目的。用户自已在FORM中定义字段，来保存其它的附加信息。 弹性域 用户自已在FORM中定义字段，来保存其它的附加信息。 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 附件 对每一记录能附上文件、文本信息或Web Page的大容量信息. 修改Forms 界面的文件功能或Show隐藏字段 用户能显示自已想要显示的字段，并能调整顺序 Export 用户能用export功能从Form 中export数据到文件中。 通常用来转换到Excel文件中。 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 2. Oracle 开发工具及开发过程 -Form (See AVI File) - Report (See AVI File) - Discoverer (See AVI Fi