SQL Database Video 8: SQL STRING FUNCTIONS | Apex Oracle
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...
На этой странице сайта вы можете посмотреть видео онлайн SQL Database Video 8: SQL STRING FUNCTIONS | Apex Oracle длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь The CS Revelation 15 Январь 2021, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 678 раз и оно понравилось 12 зрителям. Приятного просмотра!
