SQL Database Video 8: SQL STRING FUNCTIONS | Apex Oracle

Veröffentlicht am: 15 Januar 2021
auf dem Kanal: The CS Revelation

678

learn how to use SQL String Functions. Apex Oracle .

UPPER() - Converts a field to upper case
LOWER() - Converts a field to lower case
SUBSTR - Extract characters from a text field
LENGTH() - Returns the length of a text field
SOUNDEX() - returns a character string containing the phonetic representation of char.
SYSDATE() - Returns the current system date and time
REVERSE() - Returns the reverse order of a string value.
INITCAP() - Returns a character expression, with the first letter of each word in uppercase, all other letters in lowercase.
REPLACE() - Replaces all occurrences of a specified string value with another string value.

Other lectures:

INSERT INTO:    • SQL Database Video 2: Insert Rows INTO Tab...
   • APEX Oracle SQL Insert rows into Tables
Other lectures:
****** Video 1: CREATE TABLE:    • SQL Database Video 1: Create tables | Apex...
****** Video 2: INSERT INTO:    • SQL Database Video 2: Insert Rows INTO Tab...
****** Video 3: ALTER TABLE:    • SQL Database Video 3 : SQL Alter Table (Ad...
****** Video 4: UPDATE TABLE:    • SQL Database Video 4:  UPDATE Table with A...
****** Video 5: SELECT FROM TABLE :    • SQL Database Video 5:  SELECT  FROM table ...
****** Video 6: ORDER BY :    • SQL Database Video 6: ORDER BY to sort row...
****** Video 7: AGGREGATE FUNCTIONS:    • SQL Database Video 7:  SQL AGGREGATE FUNCT...
****** Video 8: STRING FUNCTIONS:   • SQL Database Video 8:  SQL STRING FUNCTION...

CREATE DATABASE CODE:
-- Step1: CREATE all tables one by one in this order
CREATE TABLE Department_T (
Department_No NUMBER (2) PRIMARY KEY,
Department_Name VARCHAR(15)
);
CREATE TABLE Employee_T(
Employee_No NUMBER (6) PRIMARY KEY,
Employee_Name VARCHAR(20),
Department_No NUMBER (2) REFERENCES Department_T (Department_No)
);
CREATE TABLE Project_T(
Project_Code NUMBER (3) PRIMARY KEY,
Project_Title VARCHAR (25),
Project_Manager VARCHAR (20),
Project_Budget DECIMAL (8,2)
);
CREATE TABLE Participation_T (
Employee_No NUMBER (6) REFERENCES Employee_T(Employee_No),
Project_Code NUMBER (3) REFERENCES Project_T(Project_Code),
Hourly_Rate DECIMAL (6,4),
PRIMARY KEY (Employee_No, Project_Code)
);
-- Step2: INSERT DATA INTO tables one by one in this order

INSERT CODE HERE in description :    • SQL Database Video 7:  SQL AGGREGATE FUNCT...

Auf dieser Seite können Sie das Online-Video SQL Database Video 8: SQL STRING FUNCTIONS | Apex Oracle mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer The CS Revelation 15 Januar 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 678 Mal angesehen und es wurde von 12 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!