Oracle

Hi everyone, today i introduce to you a Bus System database in which a passenger can ride a bus in specific date.

Driver Table:

CREATE TABLE Driver (
driver_id DECIMAL(12) NOT NULL PRIMARY KEY,
first_name VARCHAR(64) NOT NULL,
last_name VARCHAR(64) NOT NULL);

Passenger Table

CREATE TABLE Passenger (
passenger_id DECIMAL(12) NOT NULL PRIMARY KEY,
first_name VARCHAR(64) NOT NULL,
last_name VARCHAR(64) NOT NULL,
street1 VARCHAR(64) NOT NULL,
city VARCHAR(64) NOT NULL,
state VARCHAR(64) NOT NULL,
postal_code VARCHAR(64) NOT NULL);

Ride Date Table

Hi everyone, I will share with you a schema.

This schema have multiple tables with primary key and foreign key.

this is about a delivery system which deliver food item to the foodbank on a specific route on specific date.

First Create the tables in Oracle

Food_bank Table:

CREATE TABLE FOOD_BANK     (	
FOODBANKNO NUMBER(10,0) NOTNULL ,  
NAME VARCHAR2(50)  NOTNULL ,  
STRADDR VARCHAR2(100) NOTNULL ,  	
CITY VARCHAR2(50) NOTNULL ,  	
COUNTY VARCHAR2(50) NOTNULL ,  
PHONE NUMBER(10,0) NOTNULL ,  	 
CONSTRAINT FOODBANK_PK PRIMARYKEY ( FOODBANKNO)

we update it later

Hi,

Today we discuss about Analytic function.

Oracle analytic functions calculate an aggregate value based on a group of rows and return multiple rows for each group.

1. FIRST_VALUE()

It that allows you to get the first value in an ordered set of value

The following illustrates the syntax of the Oracle FIRST_VALUE() function: