Create Table In Oracle

CREATING TABLE IN ORACLE DATABASE: -  Table is the combination of rows and columns, it is object of user or schema. In database the data is stored in the form of Tables. To create table in Oracle: - Syntax: - CREATE TABLE <tablename> ( colname datatype (size), colname datatype (size), ---------------------); Rules that...

Read More

Oracle Data Types

DATA TYPES IN ORACLE A data type specifies type of the data allowed in a column and also amount of memory allocated for that column. CHAR (Size): - It allows character data and it is recommended only for fixed length columns. EXAMPLE: - Name char(20) S A C H I N ...

Read More

Creating User in Oracle

Creating User / Schema / Account in Oracle Database ○ Only DBA (Database Administrator) can create new user. While installing Oracle software it asks a password for admin system. So here the database administrator is SYSTEM and password which we provided at the time of installation. (Username: SYSTEM and Password: MANAGER) Syntax: - CREATE USER <NAME> IDENTIFIED BY <PASSWORD> ○...

Read More

SQL

SQL Structured Query Language used to communicate with Oracle server, user communicates with Oracle server by sending commands/ instructions called queries. A query is command or instruction submitted to Oracle server by the user to perform some operation over database. This SQL language is introduced...

Read More

Oracle 11g 12c

General Information About Oracle Oracle is a brand it has Databases, Application Development Tools, ERP’s (Enterprise Resource Planning Tools), Data Warehouse and so on. Below are examples for Database, Application Development Tools, ERP’s and Data Warehouse Tools Database’s Application...

Read More