Create Table in oracle db & use it in oracle apex
#Learn_Oracle
#Oracle_apex
How to Create Table in Oracle Database and use it in Oracle Apex
Do Like, Comments, Share & Hit The Bell Icon
Please Subscribe my YouTube Channel for More Update
Like My Facebook page: / learnoracle21
To create a table:
On the Workspace home page, click SQL Workshop and then Object Browser.
Object Browser appears.
Click the Create icon.
From the list of object types, select Table.
Enter a table name.
Table names must conform to Oracle naming conventions.
To have the final table name match the case entered in the Table Name field, click Preserve Case.
Enter column details:
Column Name - Enter the column name.
Type - Select the column type.
Precision - The precision is the number of digits before the decimal point. Not all column types have this setting. Precision must be a positive integer. Only NUMBER, FLOAT, INTERVAL YEAR TO MONTH, and INTERVAL DAY TO SECOND have this setting. For example, if a column of type NUMBER has precision of 4, the column value can be 0 through 9999.
Scale - The function of the scale setting depends on the column type. For NUMBER types, scale is the number of digits after the decimal point. For VARCHAR2 and CHAR types, scale is the number of stored characters. For TIMESTAMP types, scale is the fractional seconds precision and must be a number between 0 and 9. Scale must be a positive number. For example, if a column type TIMESTAMP has a scale of 3, seconds are between .000 seconds and .999 seconds.
Not Null - To specify a column must always have a value, select the Not Null check box.
If running Oracle Database 12c - Select an identity option for NUMBER and FLOAT columns. Options include:
Always - The Oracle Database always uses the sequence generator to assign a value to the column. If you attempt to explicitly assign a value to the column using INSERT or UPDATE, then an error is returned.
Default - The Oracle Database uses the sequence generator to assign a value to the column by default, but you can also explicitly assign a specified value to the column.
Default on Null - The Oracle Database uses the sequence generator to assign a value to the column when a subsequent INSERT statement attempts to assign a value that evaluates to NULL.
Move - Click the Up and Down arrows in the Move column to change the order of previously entered columns.
Add Column - Click Add Column to add additional columns.
Click Next.
For Primary Key, select the appropriate option and click Next:
Select an option:
No Primary Key - No primary key is created.
Populate from a new sequence - Creates a primary key and creates a trigger and a sequence. The sequence is used in the trigger to populate the selected primary key column. The primary key can only be a single column.
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).
If running Oracle Database 12c - Populate By Identity Column - Creates a primary key and a sequence. The sequence is used to populate the selected primary key column.
Click Next.
Add Foreign Key:
Name - Enter a name of the foreign key constraint that you are defining.
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.
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).
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).
Click Add.
Click Next.
Next, add a constraint (optional). You can create multiple constraints, but you must add each constraint separately.
Click Next.
A confirmation page appears.
Click Create.
oracle apex bangla tutorial | learn oracle | 2021
oracle apex
apex online
apex e learning
apex oracle
oracle apex course
oracle application express training
apex certification
apex courses online
online apex
apex video
oracle application express 5.0
oracle apex 5.0
apex online learning
apex learning app
oracle application express demo
oracle apex certification
apex 5 training
oracle apex demo site
oracle apex training
apex online training
oracle apex software
create app tutorial video
apex cloud oracle