EMPL_LAST_NAME||'_'||SALARY
--------------------------------------------------------
King_5000
Jones_2975
Blake_2850
Raimi_2450
Ford_3000
Smith_800
Michaels_1600
Ward_1250
Martin_1250
Scott_3000
Turner_1500
EMPL_LAST_NAME||'_'||SALARY
--------------------------------------------------------
Adams_1100
James_950
Miller_1300
14 rows selected.
Pay Info
----------------------------------------------------------
Adams, $1100
Blake, $2850
Ford, $3000
James, $950
Jones, $2975
King, $5000
Martin, $1250
Michaels, $1600
Miller, $1300
Raimi, $2450
Scott, $3000
Pay Info
----------------------------------------------------------
Smith, $800
Turner, $1500
Ward, $1250
14 rows selected.
SYSDATE
---------
17-NOV-10
TO_CHAR(SYSDATE,'MONTH')
------------------------------------
NOVEMBER
TO_CHAR(HIREDATE,'MONTH')
------------------------------------
NOVEMBER
APRIL
MAY
JUNE
DECEMBER
DECEMBER
FEBRUARY
FEBRUARY
SEPTEMBER
NOVEMBER
SEPTEMBER
TO_CHAR(HIREDATE,'MONTH')
------------------------------------
SEPTEMBER
DECEMBER
JANUARY
14 rows selected.
Employee Month of Hiring
--------------- ---------------
Smith December 1990
Michaels February 1991
Ward February 1991
Jones April 1991
Blake May 1991
Raimi June 1991
Turner September 1991
Adams September 1991
Martin September 1991
Scott November 1991
King November 1991
Employee Month of Hiring
--------------- ---------------
Ford December 1991
James December 1991
Miller January 1992
14 rows selected.
INITCAP(TO_CHAR(HIREDATE,'DAY'))
------------------------------------
Sunday
Tuesday
Wednesday
Sunday
Tuesday
Monday
Wednesday
Friday
Saturday
Saturday
Sunday
INITCAP(TO_CHAR(HIREDATE,'DAY'))
------------------------------------
Monday
Tuesday
Thursday
14 rows selected.
Hiredate
-----------------------------------------------------------------------------
Sunday , November 91
Tuesday , April 91
Wednesday, May 91
Sunday , June 91
Tuesday , December 91
Monday , December 90
Wednesday, February 91
Friday , February 91
Saturday , September 91
Saturday , November 91
Sunday , September 91
Hiredate
-----------------------------------------------------------------------------
Monday , September 91
Tuesday , December 91
Thursday , January 92
14 rows selected.
UGLY
-----------------------
4 17 321 08 20 45 55 PM
LPAD(EMPL_LAST_NAME,12,'.')
------------------------------------------------
........King
.......Jones
.......Blake
.......Raimi
........Ford
.......Smith
....Michaels
........Ward
......Martin
.......Scott
......Turner
LPAD(EMPL_LAST_NAME,12,'.')
------------------------------------------------
.......Adams
.......James
......Miller
14 rows selected.
RPAD(EMPL_LAST_NAME,12,'')
------------------------------------------------
King
Jones
Blake
Raimi
Ford
Smith
Michaels
Ward
Martin
Scott
Turner
RPAD(EMPL_LAST_NAME,12,'')
------------------------------------------------
Adams
James
Miller
14 rows selected.
Hiredate
--------------------------------------------------------------------------------
Sunday , November 91
Tuesday , April 91
Wednesday, May 91
Sunday , June 91
Tuesday , December 91
Monday , December 90
Wednesday, February 91
Friday , February 91
Saturday , September 91
Saturday , November 91
Sunday , September 91
Hiredate
--------------------------------------------------------------------------------
Monday , September 91
Tuesday , December 91
Thursday , January 92
14 rows selected.
LOOKY
-----
Silly
LOWER(EMPL_LAST UPPER(EMPL_LAST
--------------- ---------------
king KING
DOTS
------------------------------------------------
HUH
------------------------------------------------------------
MAYBE_RIGHT_JUSTIFD
------------------------------------------------
........King
King?!?!?!?!?!?
King
.......Jones
Jones?!?!?!?!?!
Jones
DOTS
------------------------------------------------
HUH
------------------------------------------------------------
MAYBE_RIGHT_JUSTIFD
------------------------------------------------
.......Blake
Blake?!?!?!?!?!
Blake
.......Raimi
Raimi?!?!?!?!?!
DOTS
------------------------------------------------
HUH
------------------------------------------------------------
MAYBE_RIGHT_JUSTIFD
------------------------------------------------
Raimi
........Ford
Ford?!?!?!?!?!?
Ford
.......Smith
DOTS
------------------------------------------------
HUH
------------------------------------------------------------
MAYBE_RIGHT_JUSTIFD
------------------------------------------------
Smith?!?!?!?!?!
Smith
....Michaels
Michaels?!?!?!?
Michaels
DOTS
------------------------------------------------
HUH
------------------------------------------------------------
MAYBE_RIGHT_JUSTIFD
------------------------------------------------
........Ward
Ward?!?!?!?!?!?
Ward
......Martin
Martin?!?!?!?!?
Martin
DOTS
------------------------------------------------
HUH
------------------------------------------------------------
MAYBE_RIGHT_JUSTIFD
------------------------------------------------
.......Scott
Scott?!?!?!?!?!
Scott
......Turner
Turner?!?!?!?!?
DOTS
------------------------------------------------
HUH
------------------------------------------------------------
MAYBE_RIGHT_JUSTIFD
------------------------------------------------
Turner
.......Adams
Adams?!?!?!?!?!
Adams
.......James
DOTS
------------------------------------------------
HUH
------------------------------------------------------------
MAYBE_RIGHT_JUSTIFD
------------------------------------------------
James?!?!?!?!?!
James
......Miller
Miller?!?!?!?!?
Miller
14 rows selected.
LFTCH RTCHO
----- -----
NICER
--------------------------------------------------------------------------------
Hi Hi
Wednesday, November 17, 2010
LFTCH RTCHO
----- -----
NICER
--------------------------------------------------------------------------------
Hi Hi
Sunday, November 17, 1991
Hi Hi
Tuesday, April 02, 1991
Hi Hi
Wednesday, May 01, 1991
LFTCH RTCHO
----- -----
NICER
--------------------------------------------------------------------------------
Hi Hi
Sunday, June 09, 1991
Hi Hi
Tuesday, December 03, 1991
Hi Hi
Monday, December 17, 1990
LFTCH RTCHO
----- -----
NICER
--------------------------------------------------------------------------------
Hi Hi
Wednesday, February 20, 1991
Hi Hi
Friday, February 22, 1991
Hi Hi
Saturday, September 28, 1991
LFTCH RTCHO
----- -----
NICER
--------------------------------------------------------------------------------
Hi Hi
Saturday, November 09, 1991
Hi Hi
Sunday, September 08, 1991
Hi Hi
Monday, September 23, 1991
LFTCH RTCHO
----- -----
NICER
--------------------------------------------------------------------------------
Hi Hi
Tuesday, December 03, 1991
Hi Hi
Thursday, January 23, 1992
14 rows selected.
EMPL_LAST_NAME LENGTH ABB
--------------- ---------- ------------
REST
----------------------------------------------------
King 4 Kin
ng
Jones 5 Jon
nes
Blake 5 Bla
ake
EMPL_LAST_NAME LENGTH ABB
--------------- ---------- ------------
REST
----------------------------------------------------
Raimi 5 Rai
imi
Ford 4 For
rd
Smith 5 Smi
ith
EMPL_LAST_NAME LENGTH ABB
--------------- ---------- ------------
REST
----------------------------------------------------
Michaels 8 Mic
chaels
Ward 4 War
rd
Martin 6 Mar
rtin
EMPL_LAST_NAME LENGTH ABB
--------------- ---------- ------------
REST
----------------------------------------------------
Scott 5 Sco
ott
Turner 6 Tur
rner
Adams 5 Ada
ams
EMPL_LAST_NAME LENGTH ABB
--------------- ---------- ------------
REST
----------------------------------------------------
James 5 Jam
mes
Miller 6 Mil
ller
14 rows selected.
TO_NUMBER('0001')+3
-------------------
4
Table dropped.
Table created.
1 row created.
1 row created.
PLAY_ID TO_CH
---------- -----
1 09:30
2 10:29
SYSDATE+1
---------
18-NOV-10
TO_DATE('
---------
01-JAN-09
TO_DATE('
---------
29-FEB-08
TO_DATE('
---------
01-MAR-09
NEXT_DAY(
---------
23-NOV-10
NEXT_DAY(
---------
24-NOV-10
ONE_MONTH DIFF1 DIFF2
--------- ---------- ----------
28-FEB-09 3 -1.5483871