'Drop column' diaporamas de présentation

Database Applications and Web-Enabled Databases

1.01k views • 67 slides

Lecture 7 Manage Schema Objects Manipulating Data

ORACLE. Lecture 7 Manage Schema Objects Manipulating Data. Objectives. After completing this lesson, you should be able to do the following: Add constraints Create indexes Create indexes using the CREATE TABLE statement Creating function-based indexes

724 views • 62 slides

Structured Query Language (SQL)

Structured Query Language (SQL). SQL Statements Versus SQL* Plus Commands. SQL*Plus: DOS, Windows, and browser iSQL*Plus. DOS SQL*Plus Editing Commands. DOS SQL*Plus Editing Commands. Default: DEFINE _EDITOR = "Notepad". SQL Statements. Database. CREATE DATABASE sample

704 views • 46 slides

Managing Schema Objects

Managing Schema Objects. Objectives. After completing this lesson, you should be able to do the following: Add constraints Create indexes Create indexes using the CREATE TABLE statement Create function-based indexes Drop columns and set columns as UNUSED Perform FLASHBACK operations

494 views • 40 slides

Manage Schema Objects

Manage Schema Objects. Objectives. After completing this lesson, you should be able to do the following: Add constraints Create indexes Create indexes using the CREATE TABLE statement Creating function-based indexes Drop columns and set column UNUSED Perform FLASHBACK operations

344 views • 31 slides

Structured Query Language - SQL

Structured Query Language - SQL. Carol Wolf Computer Science. SQL . Used for relational databases, which consist of rows and columns. SQL is not case sensitive. Queries are usually in all upper case. These slides will use upper case only for the first letter.

183 views • 9 slides