Fundamentals
Oracle PL/SQL:CREATE TABLE statement: create a table with primary key.
Continue reading about Oracle PL/SQL:CREATE TABLE statement: create a table with primary key.
CREATE TABLE statement is used to create table objects in database.You can create tables with different column data types.It is possible to add CONSTRAINTS like primary key ,foreign key etc while creating the table or can be added after the table creation
The purpose of TO_DATE in Oracle pl/sql is to convert char of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 data type to a value of DATE datatype.Or more generically the Oracle to_date function is used to change a test string (or variable) into an internal date format.
Continue reading about oracle to_date | Oracle/PLSQL: To_Date Function
What is schema?
Schema is a collection of schema objects.Schema objects are nothing but a collection of logical structures of dataA schema is owned by a database user and has the same name as that user.
Continue reading about Database Schema | Oracle Schema Objects | What is database schema?
The data in oracle is stored logically in tablespaces and physically in datafiles.
Tablespaces collectively store all of the database’s data.
Continue reading about Oracle Tablespace, and Datafiles – Introduction
An overview of PL/SQL type characters,identifires,keywords,literals and usage of comments are explained here. Type CharactersLetters A-Z, a-zDigits 0-9Symbols ~ ! @ # $ % & * ( ) _ – + = | [ ] { } : ; ” ‘ < > , . ? /White space Tab, space, carriage return PL/SQL is not [...]
PL/SQL (Procedural Language/Structured Query Language) is Oracle’s proprietary server-based proceduralextension to the SQL database language.The PL/SQL and SQL languages are tightly integrated.PL/SQL supports all the SQL datatypes and the non-value NULL.PL/SQL is a block-structured language. Main Features of PL/SQL Variables and constants. PL/SQL allows you to declare and use variables and constants in sql as [...]