Slide 74
Slide 74 text
Step 7: generate a CSV le - verify
$
$ head
head -n
-n 2
2 employees.csv
employees.csv
11523
11523,
,"1953-01-25"
"1953-01-25",
,"Yuguang"
"Yuguang",
,"Pezzoli"
"Pezzoli",
,"F"
"F",
,"1992-12-23"
"1992-12-23"
11524
11524,
,"1955-10-26"
"1955-10-26",
,"Xiadong"
"Xiadong",
,"Standera"
"Standera",
,"M"
"M",
,"1988-09-20"
"1988-09-20"
SQL
SQL >
> select
select *
* from
from employees
employees limit
limit 2
2;
;
+
+--------+------------+------------+-----------+--------+------------+
--------+------------+------------+-----------+--------+------------+
|
| emp_no
emp_no |
| birth_date
birth_date |
| first_name
first_name |
| last_name
last_name |
| gender
gender |
| hire_date
hire_date |
|
+
+--------+------------+------------+-----------+--------+------------+
--------+------------+------------+-----------+--------+------------+
|
| 10001
10001 |
| 1953
1953-
-09
09-
-02
02 |
| Georgi
Georgi |
| Facello
Facello |
| M
M |
| 1986
1986-
-06
06-
-26
26 |
|
|
| 10002
10002 |
| 1964
1964-
-06
06-
-02
02 |
| Bezalel
Bezalel |
| Simmel
Simmel |
| F
F |
| 1985
1985-
-11
11-
-21
21 |
|
+
+--------+------------+------------+-----------+--------+------------+
--------+------------+------------+-----------+--------+------------+
Remember we used an unsorted tablespace le.
Copyright @ 2025 Oracle and/or its affiliates.
$ grep Facello employees
$ grep Facello employees.
.csv
csv |
| grep Georgi
grep Georgi
55649
55649,
,"1956-01-23"
"1956-01-23",
,"Georgi"
"Georgi",
,"Facello"
"Facello",
,"M"
"M",
,"1988-05-04"
"1988-05-04"
10001
10001,
,"1953-09-02"
"1953-09-02",
,"Georgi"
"Georgi",
,"Facello"
"Facello",
,"M"
"M",
,"1986-06-26"
"1986-06-26"
45