Oracle - Understanding SQL DDL Statements for Oracle

Understanding SQL DDL Statements for Oracle

Q

Where to find answers to frequently asked questions on SQL DDL Statements for Oracle? I want to start creating tables.

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL DDL Statements for Oracle. Clear answers are provided with tutorial exercises on creating, altering and dropping tables, indexes, and views.

What Are DDL Statements in Oracle

Create a New Table in Oracle

Create a New Table with SELECT Statements in Oracle

ALTER TABLE - Add a New Column in Oracle

ALTER TABLE - Delete a Column in Oracle

DROP TABLE Statement in Oracle

CREATE INDEX - Create a Table Index in Oracle

ALTER INDEX - Rename an Index in Oracle

Drop an Existing Index in Oracle

Create a New View in Oracle

Drop an Existing View in Oracle

Sample scripts used in this FAQ assumes that you are connected to the server with the HR user account on the default database instance XE. See other FAQ collections on how to connect to the server.

⇒⇒Oracle Database Tutorials

2016-10-17, 587👍, 0💬

What Is NULL Value in Oracle
What Is NULL Value in Oracle? NULL is a special value representing "no value" in all data types. NULL can be used on in operations like other values. But most operations has special rules when NULL is involved. The tutorial exercise below shows you some examples: SET NULL 'NULL'; -- Make sure NULL i... 2019-12-02, 640👍, 0💬

Group Functions Used with Non-group Selection Fields in Oracle
Can Group Functions Be Mixed with Non-group Selection Fields in Oracle? If a group function is used in the SELECT clause, all other selection fields must be group level fields. Non-group fields can not be mixed with group fields in the SELECT clause. The script below gives you an example of invalid ... 2019-11-21, 625👍, 0💬

Divide Query Output into Groups in Oracle
How To Divide Query Output into Groups in Oracle? You can divide query output into multiple groups with the GROUP BY clause. It allows you specify a column as the grouping criteria, so that rows with the same value in the column will be considered as a single group. When the GROUP BY clause is speci... 2019-11-21, 622👍, 0💬

Use NULL as Conditions in Oracle
How To Use NULL as Conditions in Oracle? If you want to compare values against NULL as conditions, you should use the "IS NULL" or "IS NOT NULL" operator. Do not use "=" or "<>" against NULL. The sample script below shows you some good examples: SELECT 'A' IS NULL FROM DUAL; -- Error: ... 2019-12-02, 606👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.