how to create table in oracle sql syntax example and foreign key

CREATE TABLE hr.admin_emp (
         empno      NUMBER(5) PRIMARY KEY,
         ename      VARCHAR2(15) NOT NULL,
         ssn        NUMBER(9) ENCRYPT,
         job        VARCHAR2(10),
         mgr        NUMBER(5),
         hiredate   DATE DEFAULT (sysdate),
         photo      BLOB,
         sal        NUMBER(7,2),
         hrly_rate  NUMBER(7,2) GENERATED ALWAYS AS (sal/2080),
         comm       NUMBER(7,2),
         deptno     NUMBER(3) NOT NULL
                     CONSTRAINT admin_dept_fkey REFERENCES hr.departments
                     (department_id))

Add Own solution

Log in, to leave a comment

Are there any code examples left?

Find Add Code snippet

New code examples in category SQL

SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
SQL 2022-03-27 19:20:41 sql is not null
SQL 2022-03-27 19:20:39 sql group by error
SQL 2022-03-27 18:35:10 replace null with 0 in sql
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
SQL 2022-03-27 16:45:07 kill a pid redshift
SQL 2022-03-27 16:00:09 joins in sql server

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

how to add foreign key after creating table in oracle explain oracle foreign key constraint oracle sql foreign key create table query to add foreign key constraint in oracle how to create table with foreign key oracle how to insert foreign key oracle how to create a foreign key in oracle sql developer oracle constraint foreign key oracle sql add foreign key constraint how to create foreign key table in oracle foreign key on table oracle foreign key in create table oracle foreign key syntax in oracle primary key foreign key table in oracle database with example foreign key syntax in oracle sql FOREIGN KEY ORACLE ADD oracle foreign key table add foreign key in oracle sql adding foreign key in oracle how to insert foreign key in oracle sql create foreign key oracle foreign key syntax oracle oracle create table primary key is foreign key oracle sql add foreign key oracle foreign key constraint define foreign key in oracle oracle foreign key example oracle alter table foreign key example how to add foreign key into table in oracle database oracle sql foreign key syntax create table in oracle with primary key and foreign key create foreign key in oracle how to create foreign key in oracle using table command oracle foreign key constraint query oracle foreign key foreign key oracle create table oracle foreign key add foreign key constraint oracle sql oracle create table foreign key oracle table with foreign key foreign key in oracle sql how to create table oracle in foreign key create foreign key oracle sql oracle sql create table with foreign key oracle add constraint foreign key create table oracle sql foreign key How to add a foreign key in oracle sql create table with foreign key oracle declare foreign key in oracle create table foreign key oracle create constraint oracle foreign key how to add foreign key in oracle how to constraint foreign key in oracle foreign key oracle sql foreign key in oracle example how to create foreign key in oracle foreign key constraint in oracle oracle sql foreign key constraint oracle foreign key reference table foreign key create table oracle oracle sql foreign key in table oracle sql foreign key sql oracle create foreign key oracle create foreign key foreign key in oracle how to make foreign key in oracle oracle add foreign key statement pl sql add constraint foreign key add foreign key oracle alter table add foreign key oracle creating foreign key in oracle alter table create foreign key oracle constraint fk oracle oracle create table foreign key oracle create table with foreign key sql foreign key on create table oracle how to create table in oracle sql syntax example and foreign key

Made with love

Welcome Back!

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Create a Free Account

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Creating a new code example