SQL> --Calisma Sorulari SQL> --Soru 2: 100 no’lu bölümde çalisanlarin soyadlarini gösteren bir sorgu yaziniz SQL> select last_name 2 from employees 3 where department_id=100 4 ; LAST_NAME ------------------------- Greenberg Faviet Chen Sciarra Urman Popp 6 rows selected. SQL> --Soru3: SQL> ed Wrote file afiedt.buf 1 select first_name,last_name 2 from employees 3* where department_id=100 and salary>3500 SQL> r 1 select first_name,last_name 2 from employees 3* where department_id=100 and salary>3500 FIRST_NAME LAST_NAME -------------------- ------------------------- Nancy Greenberg Daniel Faviet John Chen Ismael Sciarra Jose Manuel Urman Luis Popp 6 rows selected. SQL> --Soru 4 SQL> ed Wrote file afiedt.buf 1 select first_name,last_name 2 from employees 3* where department_id=100 or salary>3500 SQL> r 1 select first_name,last_name 2 from employees 3* where department_id=100 or salary>3500 FIRST_NAME LAST_NAME -------------------- ------------------------- Steven King Neena Kochhar Lex De Haan Alexander Hunold Bruce Ernst David Austin Valli Pataballa Diana Lorentz Nancy Greenberg Daniel Faviet John Chen FIRST_NAME LAST_NAME -------------------- ------------------------- Ismael Sciarra Jose Manuel Urman Luis Popp Den Raphaely Matthew Weiss Adam Fripp Payam Kaufling Shanta Vollman Kevin Mourgos Renske Ladwig John Russell FIRST_NAME LAST_NAME -------------------- ------------------------- Karen Partners Alberto Errazuriz Gerald Cambrault Eleni Zlotkey Peter Tucker David Bernstein Peter Hall Christopher Olsen Nanette Cambrault Oliver Tuvault Janette King FIRST_NAME LAST_NAME -------------------- ------------------------- Patrick Sully Allan McEwen Lindsey Smith Louise Doran Sarath Sewall Clara Vishney Danielle Greene Mattea Marvins David Lee Sundar Ande Amit Banda FIRST_NAME LAST_NAME -------------------- ------------------------- Lisa Ozer Harrison Bloom Tayler Fox William Smith Elizabeth Bates Sundita Kumar Ellen Abel Alyssa Hutton Jonathon Taylor Jack Livingston Kimberely Grant FIRST_NAME LAST_NAME -------------------- ------------------------- Charles Johnson Nandita Sarchand Alexis Bull Kelly Chung Jennifer Dilly Sarah Bell Britney Everett Jennifer Whalen Michael Hartstein Pat Fay Susan Mavris FIRST_NAME LAST_NAME -------------------- ------------------------- Hermann Baer Shelley Higgins William Gietz 69 rows selected. SQL> l 1 select first_name,last_name 2 from employees 3* where department_id=100 or salary>3500 SQL> SQL> --Soru 5: SQL> select last_name,salary 2 from employees 3 where salary not between 5000 and 12000; LAST_NAME SALARY ------------------------- ---------- King 24000 Kochhar 17000 De Haan 17000 Austin 4800 Pataballa 4800 Lorentz 4200 Greenberg 12008 Khoo 3100 Baida 2900 Tobias 2800 Himuro 2600 LAST_NAME SALARY ------------------------- ---------- Colmenares 2500 Nayer 3200 Mikkilineni 2700 Landry 2400 Markle 2200 Bissot 3300 Atkinson 2800 Marlow 2500 Olson 2100 Mallin 3300 Rogers 2900 LAST_NAME SALARY ------------------------- ---------- Gee 2400 Philtanker 2200 Ladwig 3600 Stiles 3200 Seo 2700 Patel 2500 Rajs 3500 Davies 3100 Matos 2600 Vargas 2500 Russell 14000 LAST_NAME SALARY ------------------------- ---------- Partners 13500 Taylor 3200 Fleaur 3100 Sullivan 2500 Geoni 2800 Sarchand 4200 Bull 4100 Dellinger 3400 Cabrio 3000 Chung 3800 Dilly 3600 LAST_NAME SALARY ------------------------- ---------- Gates 2900 Perkins 2500 Bell 4000 Everett 3900 McCain 3200 Jones 2800 Walsh 3100 Feeney 3000 OConnell 2600 Grant 2600 Whalen 4400 LAST_NAME SALARY ------------------------- ---------- Hartstein 13000 Higgins 12008 57 rows selected. SQL> --alternatif cozum SQL> ed Wrote file afiedt.buf 1 select last_name,salary 2 from employees 3* where salary<5000 and salary>12000 SQL> r 1 select last_name,salary 2 from employees 3* where salary<5000 and salary>12000 no rows selected SQL> ed Wrote file afiedt.buf 1 select last_name,salary 2 from employees 3* where salary<5000 or salary>12000 SQL> r 1 select last_name,salary 2 from employees 3* where salary<5000 or salary>12000 LAST_NAME SALARY ------------------------- ---------- King 24000 Kochhar 17000 De Haan 17000 Austin 4800 Pataballa 4800 Lorentz 4200 Greenberg 12008 Khoo 3100 Baida 2900 Tobias 2800 Himuro 2600 LAST_NAME SALARY ------------------------- ---------- Colmenares 2500 Nayer 3200 Mikkilineni 2700 Landry 2400 Markle 2200 Bissot 3300 Atkinson 2800 Marlow 2500 Olson 2100 Mallin 3300 Rogers 2900 LAST_NAME SALARY ------------------------- ---------- Gee 2400 Philtanker 2200 Ladwig 3600 Stiles 3200 Seo 2700 Patel 2500 Rajs 3500 Davies 3100 Matos 2600 Vargas 2500 Russell 14000 LAST_NAME SALARY ------------------------- ---------- Partners 13500 Taylor 3200 Fleaur 3100 Sullivan 2500 Geoni 2800 Sarchand 4200 Bull 4100 Dellinger 3400 Cabrio 3000 Chung 3800 Dilly 3600 LAST_NAME SALARY ------------------------- ---------- Gates 2900 Perkins 2500 Bell 4000 Everett 3900 McCain 3200 Jones 2800 Walsh 3100 Feeney 3000 OConnell 2600 Grant 2600 Whalen 4400 LAST_NAME SALARY ------------------------- ---------- Hartstein 13000 Higgins 12008 57 rows selected. SQL> l 1 select last_name,salary 2 from employees 3* where salary<5000 or salary>12000 SQL> --Soru 6: SQL> select first_name,last_name 2 from employees 3 order by last_name; FIRST_NAME LAST_NAME -------------------- ------------------------- Ellen Abel Sundar Ande Mozhe Atkinson David Austin Hermann Baer Shelli Baida Amit Banda Elizabeth Bates Sarah Bell David Bernstein Laura Bissot FIRST_NAME LAST_NAME -------------------- ------------------------- Harrison Bloom Alexis Bull Anthony Cabrio Gerald Cambrault Nanette Cambrault John Chen Kelly Chung Karen Colmenares Curtis Davies Lex De Haan Julia Dellinger FIRST_NAME LAST_NAME -------------------- ------------------------- Jennifer Dilly Louise Doran Bruce Ernst Alberto Errazuriz Britney Everett Daniel Faviet Pat Fay Kevin Feeney Jean Fleaur Tayler Fox Adam Fripp FIRST_NAME LAST_NAME -------------------- ------------------------- Timothy Gates Ki Gee Girard Geoni William Gietz Douglas Grant Kimberely Grant Nancy Greenberg Danielle Greene Peter Hall Michael Hartstein Shelley Higgins FIRST_NAME LAST_NAME -------------------- ------------------------- Guy Himuro Alexander Hunold Alyssa Hutton Charles Johnson Vance Jones Payam Kaufling Alexander Khoo Janette King Steven King Neena Kochhar Sundita Kumar FIRST_NAME LAST_NAME -------------------- ------------------------- Renske Ladwig James Landry David Lee Jack Livingston Diana Lorentz Jason Mallin Steven Markle James Marlow Mattea Marvins Randall Matos Susan Mavris FIRST_NAME LAST_NAME -------------------- ------------------------- Samuel McCain Allan McEwen Irene Mikkilineni Kevin Mourgos Julia Nayer Donald OConnell Christopher Olsen TJ Olson Lisa Ozer Karen Partners Valli Pataballa FIRST_NAME LAST_NAME -------------------- ------------------------- Joshua Patel Randall Perkins Hazel Philtanker Luis Popp Trenna Rajs Den Raphaely Michael Rogers John Russell Nandita Sarchand Ismael Sciarra John Seo FIRST_NAME LAST_NAME -------------------- ------------------------- Sarath Sewall Lindsey Smith William Smith Stephen Stiles Martha Sullivan Patrick Sully Jonathon Taylor Winston Taylor Sigal Tobias Peter Tucker Oliver Tuvault FIRST_NAME LAST_NAME -------------------- ------------------------- Jose Manuel Urman Peter Vargas Clara Vishney Shanta Vollman Alana Walsh Matthew Weiss Jennifer Whalen Eleni Zlotkey 107 rows selected. SQL> l 1 select first_name,last_name 2 from employees 3* order by last_name SQL> ed Wrote file afiedt.buf 1 select first_name,last_name 2 from employees 3* order by last_name desc SQL> r 1 select first_name,last_name 2 from employees 3* order by last_name desc FIRST_NAME LAST_NAME -------------------- ------------------------- Eleni Zlotkey Jennifer Whalen Matthew Weiss Alana Walsh Shanta Vollman Clara Vishney Peter Vargas Jose Manuel Urman Oliver Tuvault Peter Tucker Sigal Tobias FIRST_NAME LAST_NAME -------------------- ------------------------- Winston Taylor Jonathon Taylor Patrick Sully Martha Sullivan Stephen Stiles William Smith Lindsey Smith Sarath Sewall John Seo Ismael Sciarra Nandita Sarchand FIRST_NAME LAST_NAME -------------------- ------------------------- John Russell Michael Rogers Den Raphaely Trenna Rajs Luis Popp Hazel Philtanker Randall Perkins Joshua Patel Valli Pataballa Karen Partners Lisa Ozer FIRST_NAME LAST_NAME -------------------- ------------------------- TJ Olson Christopher Olsen Donald OConnell Julia Nayer Kevin Mourgos Irene Mikkilineni Allan McEwen Samuel McCain Susan Mavris Randall Matos Mattea Marvins FIRST_NAME LAST_NAME -------------------- ------------------------- James Marlow Steven Markle Jason Mallin Diana Lorentz Jack Livingston David Lee James Landry Renske Ladwig Sundita Kumar Neena Kochhar Steven King FIRST_NAME LAST_NAME -------------------- ------------------------- Janette King Alexander Khoo Payam Kaufling Vance Jones Charles Johnson Alyssa Hutton Alexander Hunold Guy Himuro Shelley Higgins Michael Hartstein Peter Hall FIRST_NAME LAST_NAME -------------------- ------------------------- Danielle Greene Nancy Greenberg Kimberely Grant Douglas Grant William Gietz Girard Geoni Ki Gee Timothy Gates Adam Fripp Tayler Fox Jean Fleaur FIRST_NAME LAST_NAME -------------------- ------------------------- Kevin Feeney Pat Fay Daniel Faviet Britney Everett Alberto Errazuriz Bruce Ernst Louise Doran Jennifer Dilly Julia Dellinger Lex De Haan Curtis Davies FIRST_NAME LAST_NAME -------------------- ------------------------- Karen Colmenares Kelly Chung John Chen Nanette Cambrault Gerald Cambrault Anthony Cabrio Alexis Bull Harrison Bloom Laura Bissot David Bernstein Sarah Bell FIRST_NAME LAST_NAME -------------------- ------------------------- Elizabeth Bates Amit Banda Shelli Baida Hermann Baer David Austin Mozhe Atkinson Sundar Ande Ellen Abel 107 rows selected. SQL> l 1 select first_name,last_name 2 from employees 3* order by last_name desc SQL> ed Wrote file afiedt.buf 1 select first_name,last_name 2 from employees 3* order by 2 asc SQL> r 1 select first_name,last_name 2 from employees 3* order by 2 asc FIRST_NAME LAST_NAME -------------------- ------------------------- Ellen Abel Sundar Ande Mozhe Atkinson David Austin Hermann Baer Shelli Baida Amit Banda Elizabeth Bates Sarah Bell David Bernstein Laura Bissot FIRST_NAME LAST_NAME -------------------- ------------------------- Harrison Bloom Alexis Bull Anthony Cabrio Gerald Cambrault Nanette Cambrault John Chen Kelly Chung Karen Colmenares Curtis Davies Lex De Haan Julia Dellinger FIRST_NAME LAST_NAME -------------------- ------------------------- Jennifer Dilly Louise Doran Bruce Ernst Alberto Errazuriz Britney Everett Daniel Faviet Pat Fay Kevin Feeney Jean Fleaur Tayler Fox Adam Fripp FIRST_NAME LAST_NAME -------------------- ------------------------- Timothy Gates Ki Gee Girard Geoni William Gietz Douglas Grant Kimberely Grant Nancy Greenberg Danielle Greene Peter Hall Michael Hartstein Shelley Higgins FIRST_NAME LAST_NAME -------------------- ------------------------- Guy Himuro Alexander Hunold Alyssa Hutton Charles Johnson Vance Jones Payam Kaufling Alexander Khoo Janette King Steven King Neena Kochhar Sundita Kumar FIRST_NAME LAST_NAME -------------------- ------------------------- Renske Ladwig James Landry David Lee Jack Livingston Diana Lorentz Jason Mallin Steven Markle James Marlow Mattea Marvins Randall Matos Susan Mavris FIRST_NAME LAST_NAME -------------------- ------------------------- Samuel McCain Allan McEwen Irene Mikkilineni Kevin Mourgos Julia Nayer Donald OConnell Christopher Olsen TJ Olson Lisa Ozer Karen Partners Valli Pataballa FIRST_NAME LAST_NAME -------------------- ------------------------- Joshua Patel Randall Perkins Hazel Philtanker Luis Popp Trenna Rajs Den Raphaely Michael Rogers John Russell Nandita Sarchand Ismael Sciarra John Seo FIRST_NAME LAST_NAME -------------------- ------------------------- Sarath Sewall Lindsey Smith William Smith Stephen Stiles Martha Sullivan Patrick Sully Jonathon Taylor Winston Taylor Sigal Tobias Peter Tucker Oliver Tuvault FIRST_NAME LAST_NAME -------------------- ------------------------- Jose Manuel Urman Peter Vargas Clara Vishney Shanta Vollman Alana Walsh Matthew Weiss Jennifer Whalen Eleni Zlotkey 107 rows selected. SQL> ed Wrote file afiedt.buf 1 select first_name,last_name,salary 2 from employees 3* order by 3 desc SQL> r 1 select first_name,last_name,salary 2 from employees 3* order by 3 desc FIRST_NAME LAST_NAME SALARY -------------------- ------------------------- ---------- Steven King 24000 Neena Kochhar 17000 Lex De Haan 17000 John Russell 14000 Karen Partners 13500 Michael Hartstein 13000 Nancy Greenberg 12008 Shelley Higgins 12008 Alberto Errazuriz 12000 Lisa Ozer 11500 Den Raphaely 11000 FIRST_NAME LAST_NAME SALARY -------------------- ------------------------- ---------- Gerald Cambrault 11000 Ellen Abel 11000 Eleni Zlotkey 10500 Clara Vishney 10500 Janette King 10000 Peter Tucker 10000 Hermann Baer 10000 Harrison Bloom 10000 Tayler Fox 9600 Danielle Greene 9500 David Bernstein 9500 FIRST_NAME LAST_NAME SALARY -------------------- ------------------------- ---------- Patrick Sully 9500 Peter Hall 9000 Alexander Hunold 9000 Allan McEwen 9000 Daniel Faviet 9000 Alyssa Hutton 8800 Jonathon Taylor 8600 Jack Livingston 8400 William Gietz 8300 Adam Fripp 8200 John Chen 8200 FIRST_NAME LAST_NAME SALARY -------------------- ------------------------- ---------- Matthew Weiss 8000 Lindsey Smith 8000 Christopher Olsen 8000 Payam Kaufling 7900 Jose Manuel Urman 7800 Ismael Sciarra 7700 Louise Doran 7500 Nanette Cambrault 7500 William Smith 7400 Elizabeth Bates 7300 Mattea Marvins 7200 FIRST_NAME LAST_NAME SALARY -------------------- ------------------------- ---------- Oliver Tuvault 7000 Kimberely Grant 7000 Sarath Sewall 7000 Luis Popp 6900 David Lee 6800 Susan Mavris 6500 Shanta Vollman 6500 Sundar Ande 6400 Charles Johnson 6200 Amit Banda 6200 Sundita Kumar 6100 FIRST_NAME LAST_NAME SALARY -------------------- ------------------------- ---------- Pat Fay 6000 Bruce Ernst 6000 Kevin Mourgos 5800 Valli Pataballa 4800 David Austin 4800 Jennifer Whalen 4400 Nandita Sarchand 4200 Diana Lorentz 4200 Alexis Bull 4100 Sarah Bell 4000 Britney Everett 3900 FIRST_NAME LAST_NAME SALARY -------------------- ------------------------- ---------- Kelly Chung 3800 Jennifer Dilly 3600 Renske Ladwig 3600 Trenna Rajs 3500 Julia Dellinger 3400 Jason Mallin 3300 Laura Bissot 3300 Julia Nayer 3200 Samuel McCain 3200 Winston Taylor 3200 Stephen Stiles 3200 FIRST_NAME LAST_NAME SALARY -------------------- ------------------------- ---------- Alexander Khoo 3100 Alana Walsh 3100 Jean Fleaur 3100 Curtis Davies 3100 Kevin Feeney 3000 Anthony Cabrio 3000 Shelli Baida 2900 Timothy Gates 2900 Michael Rogers 2900 Sigal Tobias 2800 Vance Jones 2800 FIRST_NAME LAST_NAME SALARY -------------------- ------------------------- ---------- Girard Geoni 2800 Mozhe Atkinson 2800 John Seo 2700 Irene Mikkilineni 2700 Guy Himuro 2600 Douglas Grant 2600 Donald OConnell 2600 Randall Matos 2600 Karen Colmenares 2500 James Marlow 2500 Randall Perkins 2500 FIRST_NAME LAST_NAME SALARY -------------------- ------------------------- ---------- Peter Vargas 2500 Martha Sullivan 2500 Joshua Patel 2500 Ki Gee 2400 James Landry 2400 Hazel Philtanker 2200 Steven Markle 2200 TJ Olson 2100 107 rows selected. SQL> ed Wrote file afiedt.buf 1 select last_name,salary,department_id 2 from employees 3* order by 3 asc, 2 desc SQL> r 1 select last_name,salary,department_id 2 from employees 3* order by 3 asc, 2 desc LAST_NAME SALARY DEPARTMENT_ID ------------------------- ---------- ------------- Whalen 4400 10 Hartstein 13000 20 Fay 6000 20 Raphaely 11000 30 Khoo 3100 30 Baida 2900 30 Tobias 2800 30 Himuro 2600 30 Colmenares 2500 30 Mavris 6500 40 Fripp 8200 50 LAST_NAME SALARY DEPARTMENT_ID ------------------------- ---------- ------------- Weiss 8000 50 Kaufling 7900 50 Vollman 6500 50 Mourgos 5800 50 Sarchand 4200 50 Bull 4100 50 Bell 4000 50 Everett 3900 50 Chung 3800 50 Dilly 3600 50 Ladwig 3600 50 LAST_NAME SALARY DEPARTMENT_ID ------------------------- ---------- ------------- Rajs 3500 50 Dellinger 3400 50 Mallin 3300 50 Bissot 3300 50 Taylor 3200 50 Nayer 3200 50 Stiles 3200 50 McCain 3200 50 Davies 3100 50 Walsh 3100 50 Fleaur 3100 50 LAST_NAME SALARY DEPARTMENT_ID ------------------------- ---------- ------------- Cabrio 3000 50 Feeney 3000 50 Rogers 2900 50 Gates 2900 50 Atkinson 2800 50 Jones 2800 50 Geoni 2800 50 Mikkilineni 2700 50 Seo 2700 50 Matos 2600 50 OConnell 2600 50 LAST_NAME SALARY DEPARTMENT_ID ------------------------- ---------- ------------- Grant 2600 50 Perkins 2500 50 Marlow 2500 50 Sullivan 2500 50 Patel 2500 50 Vargas 2500 50 Gee 2400 50 Landry 2400 50 Markle 2200 50 Philtanker 2200 50 Olson 2100 50 LAST_NAME SALARY DEPARTMENT_ID ------------------------- ---------- ------------- Hunold 9000 60 Ernst 6000 60 Austin 4800 60 Pataballa 4800 60 Lorentz 4200 60 Baer 10000 70 Russell 14000 80 Partners 13500 80 Errazuriz 12000 80 Ozer 11500 80 Abel 11000 80 LAST_NAME SALARY DEPARTMENT_ID ------------------------- ---------- ------------- Cambrault 11000 80 Zlotkey 10500 80 Vishney 10500 80 Bloom 10000 80 Tucker 10000 80 King 10000 80 Fox 9600 80 Bernstein 9500 80 Sully 9500 80 Greene 9500 80 Hall 9000 80 LAST_NAME SALARY DEPARTMENT_ID ------------------------- ---------- ------------- McEwen 9000 80 Hutton 8800 80 Taylor 8600 80 Livingston 8400 80 Olsen 8000 80 Smith 8000 80 Cambrault 7500 80 Doran 7500 80 Smith 7400 80 Bates 7300 80 Marvins 7200 80 LAST_NAME SALARY DEPARTMENT_ID ------------------------- ---------- ------------- Tuvault 7000 80 Sewall 7000 80 Lee 6800 80 Ande 6400 80 Johnson 6200 80 Banda 6200 80 Kumar 6100 80 King 24000 90 Kochhar 17000 90 De Haan 17000 90 Greenberg 12008 100 LAST_NAME SALARY DEPARTMENT_ID ------------------------- ---------- ------------- Faviet 9000 100 Chen 8200 100 Urman 7800 100 Sciarra 7700 100 Popp 6900 100 Higgins 12008 110 Gietz 8300 110 Grant 7000 107 rows selected. SQL> SQL> l 1 select last_name,salary,department_id 2 from employees 3* order by 3 asc, 2 desc SQL> --Soru 10: SQL> --. Soyadi "A" ile baslayan tüm çalisanlarin isim ve soyadlarini gösteren bir sorgu yaziniz. SQL> select first_name,last_name 2 from employees 3 where upper(last_name)='A'; no rows selected SQL> ed Wrote file afiedt.buf 1 select first_name,last_name 2 from employees 3* where upper(last_name)='A%' SQL> r 1 select first_name,last_name 2 from employees 3* where upper(last_name)='A%' no rows selected SQL> ed Wrote file afiedt.buf 1 select first_name,last_name 2 from employees 3* where upper(last_name) like 'A%' SQL> r 1 select first_name,last_name 2 from employees 3* where upper(last_name) like 'A%' FIRST_NAME LAST_NAME -------------------- ------------------------- Ellen Abel Sundar Ande Mozhe Atkinson David Austin SQL> ed Wrote file afiedt.buf 1 select first_name,last_name 2 from employees 3* where upper(last_name) like 'A_K%' SQL> r 1 select first_name,last_name 2 from employees 3* where upper(last_name) like 'A_K%' FIRST_NAME LAST_NAME -------------------- ------------------------- Mozhe Atkinson SQL> --Soyisiminin 5.karakteri 'N' olan calisanlari bulalim SQL> ed Wrote file afiedt.buf 1 select first_name,last_name 2 from employees 3* where upper(last_name) like '____N%' SQL> r 1 select first_name,last_name 2 from employees 3* where upper(last_name) like '____N%' FIRST_NAME LAST_NAME -------------------- ------------------------- Mozhe Atkinson Louise Doran Nancy Greenberg Danielle Greene Jack Livingston Diana Lorentz Donald OConnell Christopher Olsen TJ Olson Karen Partners Jose Manuel Urman FIRST_NAME LAST_NAME -------------------- ------------------------- Clara Vishney 12 rows selected. SQL> set pagesize 107 SQL> set linesize 107 SQL> r 1 select first_name,last_name 2 from employees 3* where upper(last_name) like '____N%' FIRST_NAME LAST_NAME -------------------- ------------------------- Mozhe Atkinson Louise Doran Nancy Greenberg Danielle Greene Jack Livingston Diana Lorentz Donald OConnell Christopher Olsen TJ Olson Karen Partners Jose Manuel Urman Clara Vishney 12 rows selected. SQL> --85*3/2 SQL> select 85*3/2 2 from employees; 85*3/2 ---------- 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 127.5 85*3/2 ---------- 127.5 127.5 127.5 107 rows selected. SQL> ed Wrote file afiedt.buf 1 select 85*3/2 2* from dual SQL> r 1 select 85*3/2 2* from dual 85*3/2 ---------- 127.5 SQL> select first_name,salary*10000 "YENI MAAS" 2 from emmployees; from emmployees * ERROR at line 2: ORA-00942: table or view does not exist SQL> ed Wrote file afiedt.buf 1 select first_name,salary*10000 "YENI MAAS" 2* from employees SQL> r 1 select first_name,salary*10000 "YENI MAAS" 2* from employees FIRST_NAME YENI MAAS -------------------- ---------- Steven 240000000 Neena 170000000 Lex 170000000 Alexander 90000000 Bruce 60000000 David 48000000 Valli 48000000 Diana 42000000 Nancy 120080000 Daniel 90000000 John 82000000 Ismael 77000000 Jose Manuel 78000000 Luis 69000000 Den 110000000 Alexander 31000000 Shelli 29000000 Sigal 28000000 Guy 26000000 Karen 25000000 Matthew 80000000 Adam 82000000 Payam 79000000 Shanta 65000000 Kevin 58000000 Julia 32000000 Irene 27000000 James 24000000 Steven 22000000 Laura 33000000 Mozhe 28000000 James 25000000 TJ 21000000 Jason 33000000 Michael 29000000 Ki 24000000 Hazel 22000000 Renske 36000000 Stephen 32000000 John 27000000 Joshua 25000000 Trenna 35000000 Curtis 31000000 Randall 26000000 Peter 25000000 John 140000000 Karen 135000000 Alberto 120000000 Gerald 110000000 Eleni 105000000 Peter 100000000 David 95000000 Peter 90000000 Christopher 80000000 Nanette 75000000 Oliver 70000000 Janette 100000000 Patrick 95000000 Allan 90000000 Lindsey 80000000 Louise 75000000 Sarath 70000000 Clara 105000000 Danielle 95000000 Mattea 72000000 David 68000000 Sundar 64000000 Amit 62000000 Lisa 115000000 Harrison 100000000 Tayler 96000000 William 74000000 Elizabeth 73000000 Sundita 61000000 Ellen 110000000 Alyssa 88000000 Jonathon 86000000 Jack 84000000 Kimberely 70000000 Charles 62000000 Winston 32000000 Jean 31000000 Martha 25000000 Girard 28000000 Nandita 42000000 Alexis 41000000 Julia 34000000 Anthony 30000000 Kelly 38000000 Jennifer 36000000 Timothy 29000000 Randall 25000000 Sarah 40000000 Britney 39000000 Samuel 32000000 Vance 28000000 Alana 31000000 Kevin 30000000 Donald 26000000 Douglas 26000000 Jennifer 44000000 Michael 130000000 Pat 60000000 Susan 65000000 FIRST_NAME YENI MAAS -------------------- ---------- Hermann 100000000 Shelley 120080000 William 83000000 107 rows selected. SQL> l 1 select first_name,salary*10000 "YENI MAAS" 2* from employees SQL> desc employees Name Null? Type --------------------------------------------------------- -------- --------------------------------------- EMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCHAR2(20) LAST_NAME NOT NULL VARCHAR2(25) EMAIL NOT NULL VARCHAR2(25) PHONE_NUMBER VARCHAR2(20) HIRE_DATE NOT NULL DATE JOB_ID NOT NULL VARCHAR2(10) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(2,2) MANAGER_ID NUMBER(6) DEPARTMENT_ID NUMBER(4) SQL> ed Wrote file afiedt.buf 1 select first_name,salary*10000 "YENI MAAS" 2 from employees 3* where upper(job_id)='IT_PROG' SQL> r 1 select first_name,salary*10000 "YENI MAAS" 2 from employees 3* where upper(job_id)='IT_PROG' FIRST_NAME YENI MAAS -------------------- ---------- Alexander 90000000 Bruce 60000000 David 48000000 Valli 48000000 Diana 42000000 SQL> desc employees Name Null? Type --------------------------------------------------------- -------- --------------------------------------- EMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCHAR2(20) LAST_NAME NOT NULL VARCHAR2(25) EMAIL NOT NULL VARCHAR2(25) PHONE_NUMBER VARCHAR2(20) HIRE_DATE NOT NULL DATE JOB_ID NOT NULL VARCHAR2(10) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(2,2) MANAGER_ID NUMBER(6) DEPARTMENT_ID NUMBER(4) SQL> --Soru 13: SQL> select first_name,last_name,salary 2 from employees 3 where hire_date>='01-JAN-2010'; no rows selected SQL> select hire_date from employees| 2 SQL> ed Wrote file afiedt.buf 1* select hire_date from employees SQL> r 1* select hire_date from employees HIRE_DATE --------- 17-JUN-03 21-SEP-05 13-JAN-01 03-JAN-06 21-MAY-07 25-JUN-05 05-FEB-06 07-FEB-07 17-AUG-02 16-AUG-02 28-SEP-05 30-SEP-05 07-MAR-06 07-DEC-07 07-DEC-02 18-MAY-03 24-DEC-05 24-JUL-05 15-NOV-06 10-AUG-07 18-JUL-04 10-APR-05 01-MAY-03 10-OCT-05 16-NOV-07 16-JUL-05 28-SEP-06 14-JAN-07 08-MAR-08 20-AUG-05 30-OCT-05 16-FEB-05 10-APR-07 14-JUN-04 26-AUG-06 12-DEC-07 06-FEB-08 14-JUL-03 26-OCT-05 12-FEB-06 06-APR-06 17-OCT-03 29-JAN-05 15-MAR-06 09-JUL-06 01-OCT-04 05-JAN-05 10-MAR-05 15-OCT-07 29-JAN-08 30-JAN-05 24-MAR-05 20-AUG-05 30-MAR-06 09-DEC-06 23-NOV-07 30-JAN-04 04-MAR-04 01-AUG-04 10-MAR-05 15-DEC-05 03-NOV-06 11-NOV-05 19-MAR-07 24-JAN-08 23-FEB-08 24-MAR-08 21-APR-08 11-MAR-05 23-MAR-06 24-JAN-06 23-FEB-07 24-MAR-07 21-APR-08 11-MAY-04 19-MAR-05 24-MAR-06 23-APR-06 24-MAY-07 04-JAN-08 24-JAN-06 23-FEB-06 21-JUN-07 03-FEB-08 27-JAN-04 20-FEB-05 24-JUN-06 07-FEB-07 14-JUN-05 13-AUG-05 11-JUL-06 19-DEC-07 04-FEB-04 03-MAR-05 01-JUL-06 17-MAR-07 24-APR-06 23-MAY-06 21-JUN-07 13-JAN-08 17-SEP-03 17-FEB-04 17-AUG-05 07-JUN-02 HIRE_DATE --------- 07-JUN-02 07-JUN-02 07-JUN-02 107 rows selected. SQL> select first_name,last_name,salary 2 from employees 3 where hire_date>='01-JAN-2005'; FIRST_NAME LAST_NAME SALARY -------------------- ------------------------- ---------- Neena Kochhar 17000 Alexander Hunold 9000 Bruce Ernst 6000 David Austin 4800 Valli Pataballa 4800 Diana Lorentz 4200 John Chen 8200 Ismael Sciarra 7700 Jose Manuel Urman 7800 Luis Popp 6900 Shelli Baida 2900 Sigal Tobias 2800 Guy Himuro 2600 Karen Colmenares 2500 Adam Fripp 8200 Shanta Vollman 6500 Kevin Mourgos 5800 Julia Nayer 3200 Irene Mikkilineni 2700 James Landry 2400 Steven Markle 2200 Laura Bissot 3300 Mozhe Atkinson 2800 James Marlow 2500 TJ Olson 2100 Michael Rogers 2900 Ki Gee 2400 Hazel Philtanker 2200 Stephen Stiles 3200 John Seo 2700 Joshua Patel 2500 Curtis Davies 3100 Randall Matos 2600 Peter Vargas 2500 Karen Partners 13500 Alberto Errazuriz 12000 Gerald Cambrault 11000 Eleni Zlotkey 10500 Peter Tucker 10000 David Bernstein 9500 Peter Hall 9000 Christopher Olsen 8000 Nanette Cambrault 7500 Oliver Tuvault 7000 Lindsey Smith 8000 Louise Doran 7500 Sarath Sewall 7000 Clara Vishney 10500 Danielle Greene 9500 Mattea Marvins 7200 David Lee 6800 Sundar Ande 6400 Amit Banda 6200 Lisa Ozer 11500 Harrison Bloom 10000 Tayler Fox 9600 William Smith 7400 Elizabeth Bates 7300 Sundita Kumar 6100 Alyssa Hutton 8800 Jonathon Taylor 8600 Jack Livingston 8400 Kimberely Grant 7000 Charles Johnson 6200 Winston Taylor 3200 Jean Fleaur 3100 Martha Sullivan 2500 Girard Geoni 2800 Alexis Bull 4100 Julia Dellinger 3400 Anthony Cabrio 3000 Kelly Chung 3800 Jennifer Dilly 3600 Timothy Gates 2900 Randall Perkins 2500 Britney Everett 3900 Samuel McCain 3200 Vance Jones 2800 Alana Walsh 3100 Kevin Feeney 3000 Donald OConnell 2600 Douglas Grant 2600 Pat Fay 6000 83 rows selected. SQL> --Q14 SQL> ed Wrote file afiedt.buf 1 select first_name,last_name,salary 2 from employees 3* where hire_date between '01-JAN-2006' and '31-DEC-2006' SQL> r 1 select first_name,last_name,salary 2 from employees 3* where hire_date between '01-JAN-2006' and '31-DEC-2006' FIRST_NAME LAST_NAME SALARY -------------------- ------------------------- ---------- Alexander Hunold 9000 Valli Pataballa 4800 Jose Manuel Urman 7800 Guy Himuro 2600 Irene Mikkilineni 2700 Michael Rogers 2900 John Seo 2700 Joshua Patel 2500 Randall Matos 2600 Peter Vargas 2500 Christopher Olsen 8000 Nanette Cambrault 7500 Sarath Sewall 7000 Harrison Bloom 10000 Tayler Fox 9600 Jonathon Taylor 8600 Jack Livingston 8400 Winston Taylor 3200 Jean Fleaur 3100 Julia Dellinger 3400 Timothy Gates 2900 Samuel McCain 3200 Alana Walsh 3100 Kevin Feeney 3000 24 rows selected. SQL> ed Wrote file afiedt.buf 1 select first_name,last_name,salary 2 from employees 3* where hire_date>='01-JAN-2006' and hire_date<='31-DEC-2006' SQL> r 1 select first_name,last_name,salary 2 from employees 3* where hire_date>='01-JAN-2006' and hire_date<='31-DEC-2006' FIRST_NAME LAST_NAME SALARY -------------------- ------------------------- ---------- Alexander Hunold 9000 Valli Pataballa 4800 Jose Manuel Urman 7800 Guy Himuro 2600 Irene Mikkilineni 2700 Michael Rogers 2900 John Seo 2700 Joshua Patel 2500 Randall Matos 2600 Peter Vargas 2500 Christopher Olsen 8000 Nanette Cambrault 7500 Sarath Sewall 7000 Harrison Bloom 10000 Tayler Fox 9600 Jonathon Taylor 8600 Jack Livingston 8400 Winston Taylor 3200 Jean Fleaur 3100 Julia Dellinger 3400 Timothy Gates 2900 Samuel McCain 3200 Alana Walsh 3100 Kevin Feeney 3000 24 rows selected. SQL> --Soru 18 SQL> desc employees Name Null? Type --------------------------------------------------------- -------- --------------------------------------- EMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCHAR2(20) LAST_NAME NOT NULL VARCHAR2(25) EMAIL NOT NULL VARCHAR2(25) PHONE_NUMBER VARCHAR2(20) HIRE_DATE NOT NULL DATE JOB_ID NOT NULL VARCHAR2(10) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(2,2) MANAGER_ID NUMBER(6) DEPARTMENT_ID NUMBER(4) SQL> select last_name,manager_id 2 from employees 3 where manager_id =null; no rows selected SQL> ed Wrote file afiedt.buf 1 select last_name,manager_id 2 from employees 3* where manager_id is null SQL> r 1 select last_name,manager_id 2 from employees 3* where manager_id is null LAST_NAME MANAGER_ID ------------------------- ---------- King SQL> select first_name,last_name,salary_commission_pct 2 from employees 3 where commission_pct is not null 4 SQL> ed Wrote file afiedt.buf 1 select first_name,last_name,salary,commission_pct 2 from employees 3* where commission_pct is not null SQL> r 1 select first_name,last_name,salary,commission_pct 2 from employees 3* where commission_pct is not null FIRST_NAME LAST_NAME SALARY COMMISSION_PCT -------------------- ------------------------- ---------- -------------- John Russell 14000 .4 Karen Partners 13500 .3 Alberto Errazuriz 12000 .3 Gerald Cambrault 11000 .3 Eleni Zlotkey 10500 .2 Peter Tucker 10000 .3 David Bernstein 9500 .25 Peter Hall 9000 .25 Christopher Olsen 8000 .2 Nanette Cambrault 7500 .2 Oliver Tuvault 7000 .15 Janette King 10000 .35 Patrick Sully 9500 .35 Allan McEwen 9000 .35 Lindsey Smith 8000 .3 Louise Doran 7500 .3 Sarath Sewall 7000 .25 Clara Vishney 10500 .25 Danielle Greene 9500 .15 Mattea Marvins 7200 .1 David Lee 6800 .1 Sundar Ande 6400 .1 Amit Banda 6200 .1 Lisa Ozer 11500 .25 Harrison Bloom 10000 .2 Tayler Fox 9600 .2 William Smith 7400 .15 Elizabeth Bates 7300 .15 Sundita Kumar 6100 .1 Ellen Abel 11000 .3 Alyssa Hutton 8800 .25 Jonathon Taylor 8600 .2 Jack Livingston 8400 .2 Kimberely Grant 7000 .15 Charles Johnson 6200 .1 35 rows selected. SQL> select count(*),min(salary),max(salary),avg(salary),sum(salary) 2 from employees; COUNT(*) MIN(SALARY) MAX(SALARY) AVG(SALARY) SUM(SALARY) ---------- ----------- ----------- ----------- ----------- 107 2100 24000 6461.83178 691416 SQL> --30 no'lu bolumdeki calisan sayisi nedir? SQL> select count(*) 2 from employees 3 where department_id=30; COUNT(*) ---------- 6 SQL> select first_name,last_name 2 from employees; FIRST_NAME LAST_NAME -------------------- ------------------------- Ellen Abel Sundar Ande Mozhe Atkinson David Austin Hermann Baer Shelli Baida Amit Banda Elizabeth Bates Sarah Bell David Bernstein Laura Bissot Harrison Bloom Alexis Bull Anthony Cabrio Gerald Cambrault Nanette Cambrault John Chen Kelly Chung Karen Colmenares Curtis Davies Lex De Haan Julia Dellinger Jennifer Dilly Louise Doran Bruce Ernst Alberto Errazuriz Britney Everett Daniel Faviet Pat Fay Kevin Feeney Jean Fleaur Tayler Fox Adam Fripp Timothy Gates Ki Gee Girard Geoni William Gietz Douglas Grant Kimberely Grant Nancy Greenberg Danielle Greene Peter Hall Michael Hartstein Shelley Higgins Guy Himuro Alexander Hunold Alyssa Hutton Charles Johnson Vance Jones Payam Kaufling Alexander Khoo Janette King Steven King Neena Kochhar Sundita Kumar Renske Ladwig James Landry David Lee Jack Livingston Diana Lorentz Jason Mallin Steven Markle James Marlow Mattea Marvins Randall Matos Susan Mavris Samuel McCain Allan McEwen Irene Mikkilineni Kevin Mourgos Julia Nayer Donald OConnell Christopher Olsen TJ Olson Lisa Ozer Karen Partners Valli Pataballa Joshua Patel Randall Perkins Hazel Philtanker Luis Popp Trenna Rajs Den Raphaely Michael Rogers John Russell Nandita Sarchand Ismael Sciarra John Seo Sarath Sewall Lindsey Smith William Smith Stephen Stiles Martha Sullivan Patrick Sully Jonathon Taylor Winston Taylor Sigal Tobias Peter Tucker Oliver Tuvault Jose Manuel Urman Peter Vargas Clara Vishney Shanta Vollman Alana Walsh FIRST_NAME LAST_NAME -------------------- ------------------------- Matthew Weiss Jennifer Whalen Eleni Zlotkey 107 rows selected. SQL> l 1 select first_name,last_name 2* from employees SQL> --First name ve last name sutunlarini tek bir sutun altinda birlestiriniz SQL> --sutunun basligini CALISANLAR olarak degistiriniz. SQL> SQL> -- || --> birlestirme (concatenation) operatoru SQL> select first_name||last_name CALISANLAR 2 from employees; CALISANLAR --------------------------------------------- EllenAbel SundarAnde MozheAtkinson DavidAustin HermannBaer ShelliBaida AmitBanda ElizabethBates SarahBell DavidBernstein LauraBissot HarrisonBloom AlexisBull AnthonyCabrio GeraldCambrault NanetteCambrault JohnChen KellyChung KarenColmenares CurtisDavies LexDe Haan JuliaDellinger JenniferDilly LouiseDoran BruceErnst AlbertoErrazuriz BritneyEverett DanielFaviet PatFay KevinFeeney JeanFleaur TaylerFox AdamFripp TimothyGates KiGee GirardGeoni WilliamGietz DouglasGrant KimberelyGrant NancyGreenberg DanielleGreene PeterHall MichaelHartstein ShelleyHiggins GuyHimuro AlexanderHunold AlyssaHutton CharlesJohnson VanceJones PayamKaufling AlexanderKhoo JanetteKing StevenKing NeenaKochhar SunditaKumar RenskeLadwig JamesLandry DavidLee JackLivingston DianaLorentz JasonMallin StevenMarkle JamesMarlow MatteaMarvins RandallMatos SusanMavris SamuelMcCain AllanMcEwen IreneMikkilineni KevinMourgos JuliaNayer DonaldOConnell ChristopherOlsen TJOlson LisaOzer KarenPartners ValliPataballa JoshuaPatel RandallPerkins HazelPhiltanker LuisPopp TrennaRajs DenRaphaely MichaelRogers JohnRussell NanditaSarchand IsmaelSciarra JohnSeo SarathSewall LindseySmith WilliamSmith StephenStiles MarthaSullivan PatrickSully JonathonTaylor WinstonTaylor SigalTobias PeterTucker OliverTuvault Jose ManuelUrman PeterVargas ClaraVishney ShantaVollman AlanaWalsh CALISANLAR --------------------------------------------- MatthewWeiss JenniferWhalen EleniZlotkey 107 rows selected. SQL> l 1 select first_name||last_name CALISANLAR 2* from employees SQL> ed Wrote file afiedt.buf 1 select first_name||' '||last_name CALISANLAR 2* from employees SQL> r 1 select first_name||' '||last_name CALISANLAR 2* from employees CALISANLAR ---------------------------------------------- Ellen Abel Sundar Ande Mozhe Atkinson David Austin Hermann Baer Shelli Baida Amit Banda Elizabeth Bates Sarah Bell David Bernstein Laura Bissot Harrison Bloom Alexis Bull Anthony Cabrio Gerald Cambrault Nanette Cambrault John Chen Kelly Chung Karen Colmenares Curtis Davies Lex De Haan Julia Dellinger Jennifer Dilly Louise Doran Bruce Ernst Alberto Errazuriz Britney Everett Daniel Faviet Pat Fay Kevin Feeney Jean Fleaur Tayler Fox Adam Fripp Timothy Gates Ki Gee Girard Geoni William Gietz Douglas Grant Kimberely Grant Nancy Greenberg Danielle Greene Peter Hall Michael Hartstein Shelley Higgins Guy Himuro Alexander Hunold Alyssa Hutton Charles Johnson Vance Jones Payam Kaufling Alexander Khoo Janette King Steven King Neena Kochhar Sundita Kumar Renske Ladwig James Landry David Lee Jack Livingston Diana Lorentz Jason Mallin Steven Markle James Marlow Mattea Marvins Randall Matos Susan Mavris Samuel McCain Allan McEwen Irene Mikkilineni Kevin Mourgos Julia Nayer Donald OConnell Christopher Olsen TJ Olson Lisa Ozer Karen Partners Valli Pataballa Joshua Patel Randall Perkins Hazel Philtanker Luis Popp Trenna Rajs Den Raphaely Michael Rogers John Russell Nandita Sarchand Ismael Sciarra John Seo Sarath Sewall Lindsey Smith William Smith Stephen Stiles Martha Sullivan Patrick Sully Jonathon Taylor Winston Taylor Sigal Tobias Peter Tucker Oliver Tuvault Jose Manuel Urman Peter Vargas Clara Vishney Shanta Vollman Alana Walsh CALISANLAR ---------------------------------------------- Matthew Weiss Jennifer Whalen Eleni Zlotkey 107 rows selected. SQL> l 1 select first_name||' '||last_name CALISANLAR 2* from employees SQL> --concat(sutun1,sutun2) SQL> SQL> ed Wrote file afiedt.buf 1 select concat(first_name,last_name) CALISANLAR 2* from employees SQL> r 1 select concat(first_name,last_name) CALISANLAR 2* from employees CALISANLAR --------------------------------------------- EllenAbel SundarAnde MozheAtkinson DavidAustin HermannBaer ShelliBaida AmitBanda ElizabethBates SarahBell DavidBernstein LauraBissot HarrisonBloom AlexisBull AnthonyCabrio GeraldCambrault NanetteCambrault JohnChen KellyChung KarenColmenares CurtisDavies LexDe Haan JuliaDellinger JenniferDilly LouiseDoran BruceErnst AlbertoErrazuriz BritneyEverett DanielFaviet PatFay KevinFeeney JeanFleaur TaylerFox AdamFripp TimothyGates KiGee GirardGeoni WilliamGietz DouglasGrant KimberelyGrant NancyGreenberg DanielleGreene PeterHall MichaelHartstein ShelleyHiggins GuyHimuro AlexanderHunold AlyssaHutton CharlesJohnson VanceJones PayamKaufling AlexanderKhoo JanetteKing StevenKing NeenaKochhar SunditaKumar RenskeLadwig JamesLandry DavidLee JackLivingston DianaLorentz JasonMallin StevenMarkle JamesMarlow MatteaMarvins RandallMatos SusanMavris SamuelMcCain AllanMcEwen IreneMikkilineni KevinMourgos JuliaNayer DonaldOConnell ChristopherOlsen TJOlson LisaOzer KarenPartners ValliPataballa JoshuaPatel RandallPerkins HazelPhiltanker LuisPopp TrennaRajs DenRaphaely MichaelRogers JohnRussell NanditaSarchand IsmaelSciarra JohnSeo SarathSewall LindseySmith WilliamSmith StephenStiles MarthaSullivan PatrickSully JonathonTaylor WinstonTaylor SigalTobias PeterTucker OliverTuvault Jose ManuelUrman PeterVargas ClaraVishney ShantaVollman AlanaWalsh CALISANLAR --------------------------------------------- MatthewWeiss JenniferWhalen EleniZlotkey 107 rows selected. SQL> l 1 select concat(first_name,last_name) CALISANLAR 2* from employees SQL> ed Wrote file afiedt.buf 1 select concat(first_name,concat(' ',last_name)) CALISANLAR 2* from employees SQL> e SP2-0042: unknown command "e" - rest of line ignored. SQL> r 1 select concat(first_name,concat(' ',last_name)) CALISANLAR 2* from employees CALISANLAR ---------------------------------------------- Ellen Abel Sundar Ande Mozhe Atkinson David Austin Hermann Baer Shelli Baida Amit Banda Elizabeth Bates Sarah Bell David Bernstein Laura Bissot Harrison Bloom Alexis Bull Anthony Cabrio Gerald Cambrault Nanette Cambrault John Chen Kelly Chung Karen Colmenares Curtis Davies Lex De Haan Julia Dellinger Jennifer Dilly Louise Doran Bruce Ernst Alberto Errazuriz Britney Everett Daniel Faviet Pat Fay Kevin Feeney Jean Fleaur Tayler Fox Adam Fripp Timothy Gates Ki Gee Girard Geoni William Gietz Douglas Grant Kimberely Grant Nancy Greenberg Danielle Greene Peter Hall Michael Hartstein Shelley Higgins Guy Himuro Alexander Hunold Alyssa Hutton Charles Johnson Vance Jones Payam Kaufling Alexander Khoo Janette King Steven King Neena Kochhar Sundita Kumar Renske Ladwig James Landry David Lee Jack Livingston Diana Lorentz Jason Mallin Steven Markle James Marlow Mattea Marvins Randall Matos Susan Mavris Samuel McCain Allan McEwen Irene Mikkilineni Kevin Mourgos Julia Nayer Donald OConnell Christopher Olsen TJ Olson Lisa Ozer Karen Partners Valli Pataballa Joshua Patel Randall Perkins Hazel Philtanker Luis Popp Trenna Rajs Den Raphaely Michael Rogers John Russell Nandita Sarchand Ismael Sciarra John Seo Sarath Sewall Lindsey Smith William Smith Stephen Stiles Martha Sullivan Patrick Sully Jonathon Taylor Winston Taylor Sigal Tobias Peter Tucker Oliver Tuvault Jose Manuel Urman Peter Vargas Clara Vishney Shanta Vollman Alana Walsh CALISANLAR ---------------------------------------------- Matthew Weiss Jennifer Whalen Eleni Zlotkey 107 rows selected. SQL> l 1 select concat(first_name,concat(' ',last_name)) CALISANLAR 2* from employees SQL> SQL> --Calisanlarin isim, bolum ve maaslarini asagida verilen formatta listeleyiniz. SQL> --Oliver 30 no'lu bolumde calsir ve 5000 TL maas alir SQL> select first_name||' '||department_id||' nolu bolumde calisir ve '||salary||' TL maas alir.' CALISNALARIN DETAYLARI" 2 from employees 3 ed 4 SQL> ed Wrote file afiedt.buf 1 select first_name||' '||department_id||' nolu bolumde calisir ve '||salary||' TL maas alir.' "CALISANLARIN DETAYLARI" 2* from employees 3 r 4 SQL> ed Wrote file afiedt.buf 1 select first_name||' '||department_id||' nolu bolumde calisir ve '||salary||' TL maas alir.' "CALISANLARIN DETAYLARI" 2* from employees SQL> r 1 select first_name||' '||department_id||' nolu bolumde calisir ve '||salary||' TL maas alir.' "CALISANLARIN DETAYLARI" 2* from employees CALISANLARIN DETAYLARI ----------------------------------------------------------------------------------------------------------- Steven 90 nolu bolumde calisir ve 24000 TL maas alir. Neena 90 nolu bolumde calisir ve 17000 TL maas alir. Lex 90 nolu bolumde calisir ve 17000 TL maas alir. Alexander 60 nolu bolumde calisir ve 9000 TL maas alir. Bruce 60 nolu bolumde calisir ve 6000 TL maas alir. David 60 nolu bolumde calisir ve 4800 TL maas alir. Valli 60 nolu bolumde calisir ve 4800 TL maas alir. Diana 60 nolu bolumde calisir ve 4200 TL maas alir. Nancy 100 nolu bolumde calisir ve 12008 TL maas alir. Daniel 100 nolu bolumde calisir ve 9000 TL maas alir. John 100 nolu bolumde calisir ve 8200 TL maas alir. Ismael 100 nolu bolumde calisir ve 7700 TL maas alir. Jose Manuel 100 nolu bolumde calisir ve 7800 TL maas alir. Luis 100 nolu bolumde calisir ve 6900 TL maas alir. Den 30 nolu bolumde calisir ve 11000 TL maas alir. Alexander 30 nolu bolumde calisir ve 3100 TL maas alir. Shelli 30 nolu bolumde calisir ve 2900 TL maas alir. Sigal 30 nolu bolumde calisir ve 2800 TL maas alir. Guy 30 nolu bolumde calisir ve 2600 TL maas alir. Karen 30 nolu bolumde calisir ve 2500 TL maas alir. Matthew 50 nolu bolumde calisir ve 8000 TL maas alir. Adam 50 nolu bolumde calisir ve 8200 TL maas alir. Payam 50 nolu bolumde calisir ve 7900 TL maas alir. Shanta 50 nolu bolumde calisir ve 6500 TL maas alir. Kevin 50 nolu bolumde calisir ve 5800 TL maas alir. Julia 50 nolu bolumde calisir ve 3200 TL maas alir. Irene 50 nolu bolumde calisir ve 2700 TL maas alir. James 50 nolu bolumde calisir ve 2400 TL maas alir. Steven 50 nolu bolumde calisir ve 2200 TL maas alir. Laura 50 nolu bolumde calisir ve 3300 TL maas alir. Mozhe 50 nolu bolumde calisir ve 2800 TL maas alir. James 50 nolu bolumde calisir ve 2500 TL maas alir. TJ 50 nolu bolumde calisir ve 2100 TL maas alir. Jason 50 nolu bolumde calisir ve 3300 TL maas alir. Michael 50 nolu bolumde calisir ve 2900 TL maas alir. Ki 50 nolu bolumde calisir ve 2400 TL maas alir. Hazel 50 nolu bolumde calisir ve 2200 TL maas alir. Renske 50 nolu bolumde calisir ve 3600 TL maas alir. Stephen 50 nolu bolumde calisir ve 3200 TL maas alir. John 50 nolu bolumde calisir ve 2700 TL maas alir. Joshua 50 nolu bolumde calisir ve 2500 TL maas alir. Trenna 50 nolu bolumde calisir ve 3500 TL maas alir. Curtis 50 nolu bolumde calisir ve 3100 TL maas alir. Randall 50 nolu bolumde calisir ve 2600 TL maas alir. Peter 50 nolu bolumde calisir ve 2500 TL maas alir. John 80 nolu bolumde calisir ve 14000 TL maas alir. Karen 80 nolu bolumde calisir ve 13500 TL maas alir. Alberto 80 nolu bolumde calisir ve 12000 TL maas alir. Gerald 80 nolu bolumde calisir ve 11000 TL maas alir. Eleni 80 nolu bolumde calisir ve 10500 TL maas alir. Peter 80 nolu bolumde calisir ve 10000 TL maas alir. David 80 nolu bolumde calisir ve 9500 TL maas alir. Peter 80 nolu bolumde calisir ve 9000 TL maas alir. Christopher 80 nolu bolumde calisir ve 8000 TL maas alir. Nanette 80 nolu bolumde calisir ve 7500 TL maas alir. Oliver 80 nolu bolumde calisir ve 7000 TL maas alir. Janette 80 nolu bolumde calisir ve 10000 TL maas alir. Patrick 80 nolu bolumde calisir ve 9500 TL maas alir. Allan 80 nolu bolumde calisir ve 9000 TL maas alir. Lindsey 80 nolu bolumde calisir ve 8000 TL maas alir. Louise 80 nolu bolumde calisir ve 7500 TL maas alir. Sarath 80 nolu bolumde calisir ve 7000 TL maas alir. Clara 80 nolu bolumde calisir ve 10500 TL maas alir. Danielle 80 nolu bolumde calisir ve 9500 TL maas alir. Mattea 80 nolu bolumde calisir ve 7200 TL maas alir. David 80 nolu bolumde calisir ve 6800 TL maas alir. Sundar 80 nolu bolumde calisir ve 6400 TL maas alir. Amit 80 nolu bolumde calisir ve 6200 TL maas alir. Lisa 80 nolu bolumde calisir ve 11500 TL maas alir. Harrison 80 nolu bolumde calisir ve 10000 TL maas alir. Tayler 80 nolu bolumde calisir ve 9600 TL maas alir. William 80 nolu bolumde calisir ve 7400 TL maas alir. Elizabeth 80 nolu bolumde calisir ve 7300 TL maas alir. Sundita 80 nolu bolumde calisir ve 6100 TL maas alir. Ellen 80 nolu bolumde calisir ve 11000 TL maas alir. Alyssa 80 nolu bolumde calisir ve 8800 TL maas alir. Jonathon 80 nolu bolumde calisir ve 8600 TL maas alir. Jack 80 nolu bolumde calisir ve 8400 TL maas alir. Kimberely nolu bolumde calisir ve 7000 TL maas alir. Charles 80 nolu bolumde calisir ve 6200 TL maas alir. Winston 50 nolu bolumde calisir ve 3200 TL maas alir. Jean 50 nolu bolumde calisir ve 3100 TL maas alir. Martha 50 nolu bolumde calisir ve 2500 TL maas alir. Girard 50 nolu bolumde calisir ve 2800 TL maas alir. Nandita 50 nolu bolumde calisir ve 4200 TL maas alir. Alexis 50 nolu bolumde calisir ve 4100 TL maas alir. Julia 50 nolu bolumde calisir ve 3400 TL maas alir. Anthony 50 nolu bolumde calisir ve 3000 TL maas alir. Kelly 50 nolu bolumde calisir ve 3800 TL maas alir. Jennifer 50 nolu bolumde calisir ve 3600 TL maas alir. Timothy 50 nolu bolumde calisir ve 2900 TL maas alir. Randall 50 nolu bolumde calisir ve 2500 TL maas alir. Sarah 50 nolu bolumde calisir ve 4000 TL maas alir. Britney 50 nolu bolumde calisir ve 3900 TL maas alir. Samuel 50 nolu bolumde calisir ve 3200 TL maas alir. Vance 50 nolu bolumde calisir ve 2800 TL maas alir. Alana 50 nolu bolumde calisir ve 3100 TL maas alir. Kevin 50 nolu bolumde calisir ve 3000 TL maas alir. Donald 50 nolu bolumde calisir ve 2600 TL maas alir. Douglas 50 nolu bolumde calisir ve 2600 TL maas alir. Jennifer 10 nolu bolumde calisir ve 4400 TL maas alir. Michael 20 nolu bolumde calisir ve 13000 TL maas alir. Pat 20 nolu bolumde calisir ve 6000 TL maas alir. Susan 40 nolu bolumde calisir ve 6500 TL maas alir. CALISANLARIN DETAYLARI ----------------------------------------------------------------------------------------------------------- Hermann 70 nolu bolumde calisir ve 10000 TL maas alir. Shelley 110 nolu bolumde calisir ve 12008 TL maas alir. William 110 nolu bolumde calisir ve 8300 TL maas alir. 107 rows selected. SQL> l 1 select first_name||' '||department_id||' nolu bolumde calisir ve '||salary||' TL maas alir.' "CALISANLARIN DETAYLARI" 2* from employees SQL> spool off