请选择 进入手机版 | 继续访问电脑版
楼主: ReneeBK
1487 1

Oracle Application Express 4 Recipes [推广有奖]

  • 1关注
  • 62粉丝

VIP

学术权威

14%

还不是VIP/贵宾

-

TA的文库  其他...

R资源总汇

Panel Data Analysis

Experimental Design

威望
1
论坛币
49392 个
通用积分
51.6904
学术水平
370 点
热心指数
273 点
信用等级
335 点
经验
57815 点
帖子
4006
精华
21
在线时间
582 小时
注册时间
2005-5-8
最后登录
2023-11-26

ReneeBK 发表于 2015-7-11 23:48:01 |显示全部楼层 |坛友微信交流群

+2 论坛币
k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群
赵安豆老师微信:zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

感谢您参与论坛问题回答

经管之家送您两个论坛币!

+2 论坛币

  • Oracle Application Express 4 Recipes
  • By: Edmund Zehoo

  • Publisher: Apress

  • Pub. Date: June 27, 2011

  • Print ISBN: 978-1-430-23506-4

  • Web ISBN: 1-430235-06-3

  • Pages in Print Edition: 354

  • Subscriber Rating: [1 Rating] Subscriber Reviews


二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

关键词:Application Recipes express Xpress Recipe Oracle

本帖被以下文库推荐

ReneeBK 发表于 2015-7-11 23:50:50 |显示全部楼层 |坛友微信交流群
2.1. Creating a Database Application
2.1.1. Problem

You need to create a database application that contains a data entry form to manage a master list of customers and their details.

2.1.2. Solution

It's best to approach this problem in two parts. First, create the customer table. Then create the application, including a data entry form.

2.1.2.1. Creating the Customers Table

Here's how to create the customers table:

  • Login to an existing APEX workspace as a developer.

  • You will now need to create the Customers table. Click on the SQL Workshop Object Browser menu item. In the ensuing window, click the Create button in the top right corner, and choose the Table menu item.

  • You will be presented with a window that allows you to define your database table. Specify a name for the table and define a few fields for the table. You may create a mix of NVARCHAR2, NUMBER, and DATE fields.

  • Click the Next button to continue. You can define a primary key in this screen, if needed. Set the primary key to the ID field of your table.

  • Click the Next button. The next page allows you to define a foreign key (if available). Since there isn't one at the moment, skip this page and click the Next button again. In the next page, you can define constraints on your table. You may, for example not want to have duplicate records (two records of a particular company with the same name). Choose to create a unique constraint on the Name field.

  • Click the Next button. You can see a summary of the table that will be created. Click the Create button to confirm the request, after which your table will be generated. If you browse your list of tables, you should see the Customers table appear in that list






使用道具

您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注cda
拉您进交流群

京ICP备16021002-2号 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问:王进律师 知识产权保护声明   免责及隐私声明

GMT+8, 2024-3-29 01:44