"Oracle Application Express SQL Workshop and Utilities Guide 3.2"

需积分: 5 95 浏览量更新于2023-11-23 收藏 899KB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源推荐

Searching For and Browsing Database Objects

1-4 Oracle Application Express SQL Workshop and Utilities Guide

To search for an object name, enter a case insensitive search term in the Search

field.

4. To view all objects, leave the search field blank.

Once you locate the database object you want to view, simply select it. The selected

object displays in the Detail pane. If no object is selected, the Detail pane is blank.

Hiding the Object Selection Pane

You can hide the Object Selection pane by selecting the Hide Objects control. This

control displays on the right side of the Object Selection pane. If the Object Selection

pane appears, selecting this control hides it. Similarly, if the Object Selection pane is

hidden, selecting this control causes the pane to reappear.

Using the Find Tables Icon

The Find Tables icon resembles a flashlight. Click this icon to view tables within the

currently selected schema.

To view tables within the current schema:

1. Navigate to either Object Browser or SQL Commands.

2. From the Schema list, select a schema (optional).

3. Click the Find Tables icon.

The Table Finder appears. A search bar displaying the selected schema displays at

the top of the page and contains the following controls:

■ Search. Search for a table name. Enter case insensitive keywords in the Search

field and click Go. To view all tables, leave the Search field blank and click Go.

■ Rows. Determine how many rows display in the resulting report. To change

the number of rows that display, make a selection from the list and click Go.

■ Views. Select the Views check box and click Go to include views in the

resulting report.

The Table Finder report appears displaying the table name, the number of rows,

last analyzed date, and the object type.

4. Select a table name.

Managing Tables

Managing Database Objects with Object Browser 1-7

■ Populated from an existing sequence - Creates a primary key and creates a

trigger. The selected sequence is used in the trigger to populate the selected

primary key column. The primary key can only be a single column.

■ Not populated - Defines a primary key but does not have the value

automatically populated with a sequence within a trigger. You can also select

this option to define a composite primary key (that is, a primary key made up

of multiple columns).

Next, add foreign keys (optional). A foreign key establishes a relationship between

a column (or columns) in one table and a primary or unique key in another table.

8. To add a foreign key:

a. Name - Enter a name of the foreign key constraint that you are defining.

b. Select Key Column(s) - Select the columns that are part of the foreign key, then

click the Add icon to move them to Key Column(s).

c. References Table - Select the table which is referenced by this foreign key.

Then, select the columns referenced by this foreign key. Once selected, click

the Add icon to move the selected columns to Referenced Column(s).

d. Select the appropriate option:

– Disallow Delete - Blocks the delete of rows from the referenced table

when there are dependent rows in this table.

– Cascade Delete - Deletes the dependent rows from this table when the

corresponding parent table row is deleted.

– Set to Null on Delete - Sets the foreign key column values in this table to

null when the corresponding parent table row is deleted.

e. Click Add.

f. Click Next.

Next, add a constraint (optional). You can create multiple constraints, but you

must add each constraint separately.

9. To add a constraint:

a. Specify the type of constraint (Check or Unique).

A check constraint is a validation check on one or more columns within the

table. No records can be inserted or updated in a table which violates an

enabled check constraint. A unique constraint designates a column or a

combination of columns as a unique key. To satisfy a unique constraint, no two

rows in the table can have the same values for the specified columns.

b. Enter the constraint in the field provided. For unique constraints, select the

column(s) that are to be unique. For check constraints, enter the expression

that should be checked such as flag in ('Y','N').

c. Click Add.

10. Click Finish.

A confirmation page appears. To view the SQL used to create the table, click SQL

Syntax.

11. Click Create.

Note that it is not necessary to follow the steps for creating a table in the order

described in the previous procedure. Instead of navigating through the wizard by

Managing Tables

1-8 Oracle Application Express SQL Workshop and Utilities Guide

clicking the Next and Previous button, you can also access a specific step by

selecting it in the progress indicator on the left side of the page.

Browsing a Table

When you view a table in Object Browser, the table description appears. While

viewing this description, you can add a column, modify a column, rename a column,

drop a column, rename the table, copy the table, drop the table, truncate the table, or

create a lookup table based upon a column in the current table. Additionally, you have

access other reports that offer related information including the table data, indexes,

data model, constraints, grants, statistics, user interface defaults, triggers,

dependencies, and SQL to produce the selected table.

To view a table description:

1. On the Workspace home page, click SQL Workshop and then Object Browser.

Object Browser appears.

2. From the Object list, select Tab le s.

3. From the Object Selection pane, select a table.

The table description appears.

Summary of Available Views

Click the tabs at the top of the page to view different reports about the table. Table 1–1

describes all available views.

See Also: "Using the Table Finder" in Oracle Application Express

Application Builder User's Guide and "Overview of Tables" in Oracle

Database Concepts for information about tables.

Table 1–1 Available Views for Tables

View Description

Table Displays details of the first 31 columns including the column

name, data type, nullable status, default value, and primary key.

While viewing table details you can add, modify, delete, or

rename a column. Additionally, you can drop, rename, copy, or

truncate the table only if the referencing table has no records and

create a lookup table.

To export the data as a comma-delimited file (.csv) file, click the

Download link.

"Oracle Application Express SQL Workshop and Utilities Guide 3.2...

最新资源

"Oracle Application Express SQL Workshop and Utilities Guide 3.2...

Oracle Application Express Administration Guide Release 3.2

如何安装sqlserver客户端工具

怎么在pycharm上安装 SqlServer库

oracle DBMS_DATAPUMP

oracle split

如何使用MySQL Utilities打开一个***.frm文件

centos7 oracle依赖包下载

spark-sql操作hive报错及解决

xv6 and unix utilities

anaconda 安装Utilities

-bash: sqlcmd: command not found

java oracle.spatial两个jar sdoapi sdoutl

Application

ansysmaxwell19.3找不到“Utilities”选项

ipmi-utilities

dotnet.utilities

labview Vision Utilities

文件夹Utilities什么意思？

console application

Mappers,models,services和utilities文件夹都是干什么的

最新资源