Alias Complete
Oracle queries need your help - had 29 questions and did not want to ask for help.?
I have 8 queries that I can not figure out - here are four - I did complete the rest.
1. Write a query using the emp_details_view to display the DEPARTMENT_NAME in upper case, the JOB_TITLE in lower case and the REGION_NAME with the first letter capitalized and all other letters lowercase and the length of the COUNTRY_NAME .
2. Modify #10 to order the results by the employee’s last name.
3. Create a query that will display the EMPLOYEE ID, LAST_NAME and MANAGER_ID of employees in the employee table. If the employee does not have a manger put “No Manger is Listed”. Create an alias for the column.
4. Write query using the em_details_view that displays a job title of all employees based on the value of the column department_id as follows:
10 Finance
30 Purchasing
50 Shipping
80 Sales
My teacher is lazy and bad! He copy and paste a query - teaching myself!
Can Not Afford Tutor!
http://www.w3schools.com/sql/default.asp has all the answers...
Read it, try it and THEN ask questions if you do not understand something...
 Alias The Complete First Season DVD 2003 6 Disc Set  US $10.00
|
 Alias The Complete Fourth Season DVD 6 Disc Set US $10.55
|
 Alias The Complete First Season DVD 2009 6 Disc Set US $8.32
|
 Alias The Complete Second Season DVD 2009 6 Disc Set US $14.50
|
 Alias The Complete Collection DVD 2006 29 Disc Set US $98.37
|
 Alias The Complete Third Season DVD 2006 6 Disc Set US $17.00
|
 Alias The Complete Third Season 6 DVD Set US $14.99
|
 Alias The Complete Third Season DVD 2009 6 Disc Set US $24.51
|
 Alias The Complete Fourth Season DVD 2009 6 Disc Set US $24.51
|
 Alias Complete Second Season US $12.99
|
 Alias Complete Season Three US $12.99
|
 3 DVD SetsAlias season 2 West Wing season 1 and 24 season 1 complete US $19.99
|
 ALIAS Season 1 and Season 2 Complete sets US $34.99
|
 Alias The Complete Fourth Season DVD 2005 6 Disc Set US $15.00 |
 Alias The Complete Fifth Season DVD 2006 4 Disc Set US $22.00 |
![ALIAS THE COMPLETE FIFTH SEASON 4 DISCS] DVD NEW]](http://www.dvd-guys.com/images/e/130678805531_0.jpg)
 ALIAS THE COMPLETE SECOND SEASON NEW DVD BOXSET US $23.29
|
 ALIAS SMITH AND JONES COMPLETE SERIES New Sealed 10 DVD US $40.01
|
 Alias The Complete Fourth Season DVD 2009 6 Disc Set DVD 2009 US $23.45
|
![ALIAS THE COMPLETE FOURTH SEASON 6 DISCS] DVD NEW]](http://www.dvd-guys.com/images/e/140726914516_0.jpg)
 Alias The Complete Fifth Season DVD 2006 4 Disc US $39.72
|
 ALIAS COMPLETE SECOND SEASON 6PC DVD US $111.64
|
 Alias Smith and Jones The Complete Series DVD 2010 10 Disc Set US $59.00
|
 Alias The Complete First Season DVD 2003 6 Disc Set MINT SHAPE WIDE US $16.91
|
 Alias The Complete First Season DVD 6DISC SET J GARNER US $20.99
|
 Alias The Complete First Season US $8.30 |
 Alias Season 1 DVD COMPLETE Box Set Gently Used Jennifer Garner CIA Action 2003 US $14.99
|
 Alias The Complete First Season DVD 2003 6 Di US $34.99
|
 ALIAS COMPLETE THIRD SEASON 6PC FULL DVD US $108.25
|
 Alias Season 3 DVD COMPLETE Box Set Gently Used Jennifer Garner CIA Action 2003 US $14.99
|
 Alias The Complete Second Season DVD NEW SEALED US $24.99
|
 ALIAS COMPLETE FOURTH SEASON 6PC DVD US $105.23
|
 ALIAS SMITH AND JONES COMPLETE SERIES 1 2 3 New 10 DVD US $45.49
|
 Alias The Complete First Season DVD 2003 6 Disc Set US $14.45
|
 Alias The Complete Second Season 2 DVD 2003 6 Disc Set US $15.75
|
| Powered by phpBay Pro |
 |
The Notebook of Anna Magdalena Bach
 |
DescriptionThese small pieces are what survive of two volumes compiled in the Bach household for the pleasure of Bach's second wife, herself a professional musician, and for her use in teaching music to their children... |
 |
Very Rare Evening
List Price: |
DescriptionAll products are BRAND NEW and Factory Sealed. Fast shipping and 100% Satisfaction Guaranteed. |
 |
Arrested Development: The Complete Series (Seasons 1-3 Bundle)
List Price: |
DescriptionSeason Two In this five-time Emmy®-winning comedy's hilarious Second Season, Michael Bluth, once again determined to be free of his dysfunctional family, packs up the car and his son George-Michael and heads for Arizona... Features
|
 |
The Complete Thin Man Collection (The Thin Man / After the Thin Man / Another Thin Man / Shadow of the Thin Man / The Thin Man Goes Home / Song of the Thin Man / Alias Nick and Nora)
List Price: |
DescriptionAlmost as welcome as a shaker full of martinis, The Complete Thin Man Collection represents an eagerly awaited DVD milestone for fans of the fizzy MGM movie series. The best film in the series came first: The Thin Man (1934), W... Features
|
 |
Arrested Development - Season One
List Price: |
DescriptionWinner of the Outstanding Comedy Series Emmy its first year out, Arrested Development is the kind of sitcom that gives you hope for television. A mockumentary-style exploration of the beleaguered Bluth family, it's one of those idiosyncratic shows that doesn't rely on a laugh track or a studio audience; it's shot more like a TV drama, albeit with an omniscient narrator (executive producer Ron Howard) overseeing the proceedings... |
 |
Alias Season 3 Trading Cards Complete 3 Card Betrayal Chase Set
|
DescriptionFor Sale Is A Complete Trading Card Chase Set. Features
|
 |
Alias Season 1 Trading Cards Complete 9 Card Secret Lives Chase Set
|
DescriptionFor Sale Is A Complete Trading Card Chase Set. Features
|
 |
Alias Season 2 Trading Cards Complete 3 Card Family Deceptions Chase Set
|
DescriptionFor Sale Is A Complete Trading Card Chase Set. Features
|
 |
Premium Accessory Power Pack for your Samsung Alias 2 Phone! Kit includes : (1) A Days Tech Charging USB Data Cable, (1) Travel AC/Wall Charger with Folding Blades, (1) Car Charger DC/Vehicle with rapid charger & fuse protection. (II)
List Price: |
DescriptionPremium Accessory Power Pack for your Samsung Alias 2 Phone! Kit includes : (1) A Days Tech Charging USB Data Cable, (1) Travel AC/Wall Charger with Folding Blades, (1) Car Charger DC/Vehicle with rapid charger & fuse protection... Features
|
 |
How to Cheat in Maya 2012: Tools and Techniques for Character Animation
List Price: |
DescriptionThe Maya guide for animators, How to Cheat in Maya 2012 presents everything you need to know about character animation in Maya. Fully updated for the latest revision of Maya, this book provides you with complete, step-by-step walkthroughs of essential animation techniques to increase your efficiency and speed... |
Ken Olin as David McNeal in Alias
Dig Eng
Child Dvd
Ben Stiller
What You
Action Free
Super Vhs
Good Night
Children Men
John Candy
Dvd Factory