|
-
SQL> desc football
Name Null? Type
----------------------------------------- -------- ----------------------------
PLAYER_LAST_NAME NOT NULL VARCHAR2(40)
PLAYER_FIRST_NAME NOT NULL VARCHAR2(40)
AGENT_NAME VARCHAR2(50)
SIGN_DATE NOT NULL DATE
TEAM_NAME NOT NULL VARCHAR2(40)
PARTITION_NAME HIGH_VALUE
------------------------------ ----------------------------------------
XFL_APR2001 TO_DATE(' 2001-05-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
XFL_AUG2000 TO_DATE(' 2000-09-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
XFL_AUG2001 TO_DATE(' 2001-09-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
PARTITION_NAME HIGH_VALUE
------------------------------ ----------------------------------------
XFL_DEC2000 TO_DATE(' 2001-01-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
XFL_DEC2001 TO_DATE(' 2002-01-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
XFL_JUN2000 TO_DATE(' 2000-07-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
PARTITION_NAME HIGH_VALUE
------------------------------ ----------------------------------------
N')
XFL_FEB2001 TO_DATE(' 2001-03-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
XFL_JUL2000 TO_DATE(' 2000-08-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
XFL_JUL2001 TO_DATE(' 2001-08-01 00:00:00', 'SYYYY-M
PARTITION_NAME HIGH_VALUE
------------------------------ ----------------------------------------
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
XFL_JUN2001 TO_DATE(' 2001-07-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
XFL_MAR2001 TO_DATE(' 2001-04-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
PARTITION_NAME HIGH_VALUE
------------------------------ ----------------------------------------
XFL_MAY2001 TO_DATE(' 2001-06-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
XFL_NOV2000 TO_DATE(' 2000-12-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
XFL_NOV2001 TO_DATE(' 2001-12-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
PARTITION_NAME HIGH_VALUE
------------------------------ ----------------------------------------
XFL_OCT2000 TO_DATE(' 2000-11-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
XFL_OCT2001 TO_DATE(' 2001-11-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
XFL_SEP2000 TO_DATE(' 2000-10-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
PARTITION_NAME HIGH_VALUE
------------------------------ ----------------------------------------
N')
XFL_SEP2001 TO_DATE(' 2001-10-01 00:00:00', 'SYYYY-M
M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
N')
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|