Âñå ïîëÿ
SELECT *
FROM phone_list ïîëó÷èòü ñïèñîê ñëóæåáíûõ òåëåôîíîâ
âñåõ ðàáîòíèêîâ ïðåäïðèÿòèÿ
ñî âñåé íåîáõîäèìîé èíôîðìàöèåé
EMP_NO FIRST_NAME LAST_NAME PHONE_EXT LOCATION PHONE_NO
====== ========== ========= ========= ============= ==============
12 Terri Lee 256 Monterey (408) 555-1234
105 Oliver H. Bender 255 Monterey (408) 555-1234
85 Mary S. MacDonald 477 San Francisco (415) 555-1234
127 Michael Yanowski 492 San Francisco (415) 555-1234
2 Robert Nelson 250 Monterey (408) 555-1234
109 Kelly Brown 202 Monterey (408) 555-1234
14 Stewart Hall 227 Monterey (408) 555-1234
...
