Question 15 Suppose that you have the following table created as CREATE TABLE TAB1 (NAME VARCHAR2 (100) ); INSERT INTO TAB1 VALUES ('Ahmed Raoof Hasan'); Use one SELECT statement to decompose the NAME...

Question 15<br>Suppose that you have the following table created as<br>CREATE TABLE TAB1 (NAME VARCHAR2 (100) );<br>INSERT INTO TAB1 VALUES ('Ahmed Raoof Hasan');<br>Use one SELECT statement to decompose the NAME into first, second, and last names.<br>e.g.<br>Name: Ahmed Raoof Hasan<br>1. first: Ahmed<br>2. second: Raoof<br>3. last: Hasan<br>Hint: use the following syntax if needed:<br>INSTR (string, substring, start position, occurrences)<br>SUBSTR (string, start_pos,<br>length)<br>Usethe editor to format your.answer<br>

Extracted text: Question 15 Suppose that you have the following table created as CREATE TABLE TAB1 (NAME VARCHAR2 (100) ); INSERT INTO TAB1 VALUES ('Ahmed Raoof Hasan'); Use one SELECT statement to decompose the NAME into first, second, and last names. e.g. Name: Ahmed Raoof Hasan 1. first: Ahmed 2. second: Raoof 3. last: Hasan Hint: use the following syntax if needed: INSTR (string, substring, start position, occurrences) SUBSTR (string, start_pos, length) Usethe editor to format your.answer

Jun 09, 2022

SOLUTION.PDF

Question 15 Suppose that you have the following table created as CREATE TABLE TAB1 (NAME VARCHAR2 (100) ); INSERT INTO TAB1 VALUES ('Ahmed Raoof Hasan'); Use one SELECT statement to decompose the NAME...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment