| �ｿｽ�ｿｽ�ｿｽt�ｿｽf�ｿｽ[�ｿｽ^�ｿｽ作す�ｿｽ�ｿｽ |
|
�ｿｽV�ｿｽX�ｿｽe�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽt�ｿｽ�ｿｽ�ｿｽ謫ｾ�ｿｽ�ｿｽ�ｿｽ�ｿｽi SYSDATE�ｿｽASYSTIMESTAMP �ｿｽj |
|
�ｿｽV�ｿｽX�ｿｽe�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽt�ｿｽ�ｿｽ�ｿｽ謫ｾ�ｿｽ�ｿｽ�ｿｽ�ｿｽi CURRENT_DATE�ｿｽACURRENT_TIMESTAMP �ｿｽj |
|
�ｿｽJ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽg�ｿｽZ�ｿｽb�ｿｽV�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌタ�ｿｽC�ｿｽ�ｿｽ�ｿｽ]�ｿｽ[�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ謫ｾ�ｿｽ�ｿｽ�ｿｽ�ｿｽi SESSIONTIMEZONE �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽt�ｿｽf�ｿｽ[�ｿｽ^�ｿｽ^�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽf�ｿｽ[�ｿｽ^�ｿｽﾌ変奇ｿｽ�ｿｽi TO_DATE�ｿｽATO_CHAR�ｿｽATO_TIMESTAMP �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽﾉゑｿｽ�ｿｽﾌ会ｿｽ�ｿｽZ�ｿｽ^�ｿｽ�ｿｽ�ｿｽZ |
|
�ｿｽ�ｿｽ�ｿｽﾔの会ｿｽ�ｿｽZ�ｿｽ^�ｿｽ�ｿｽ�ｿｽZ |
|
�ｿｽ�ｿｽ�ｿｽﾌ会ｿｽ�ｿｽZ�ｿｽ^�ｿｽ�ｿｽ�ｿｽZ�ｿｽi ADD_MONTHS �ｿｽj |
|
�ｿｽw�ｿｽ�ｿｽ�ｿｽ�ｿｽt�ｿｽ�ｿｽ�ｿｽ邇滂ｿｽﾌ指�ｿｽ�ｿｽj�ｿｽ�ｿｽ�ｿｽﾌ難ｿｽ�ｿｽt�ｿｽ�ｿｽ�ｿｽ謫ｾ�ｿｽ�ｿｽ�ｿｽ�ｿｽi NEXT_DAY �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽt�ｿｽf�ｿｽ[�ｿｽ^�ｿｽﾌ丸め／�ｿｽﾘ捨て（ ROUND�ｿｽATRUNC �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽN�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ迪ｻ�ｿｽﾝの年�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾟゑｿｽi MONTHS_BETWEEN �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽt�ｿｽ�ｿｽ�ｿｽ謫ｾ�ｿｽ�ｿｽ�ｿｽ�ｿｽi LAST_DAY �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽt�ｿｽﾌ和�ｿｽ�ｿｽ^�ｿｽ�ｿｽ�ｿｽ�ｿｽﾏ奇ｿｽ |
| �ｿｽX�ｿｽ|�ｿｽ�ｿｽ�ｿｽT�ｿｽ[�ｿｽh�ｿｽ@�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽN |
|
|
| SELECT�ｿｽ�ｿｽ�ｿｽﾊゑｿｽ�ｿｽw�ｿｽl�ｿｽk�ｿｽ`�ｿｽ�ｿｽ�ｿｽﾅ出�ｿｽﾍゑｿｽ�ｿｽ�ｿｽ |
|
�ｿｽ�ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽﾊに撰ｿｽ�ｿｽ`�ｿｽ�ｿｽ�ｿｽ�ｿｽXMLtype�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽ^�ｿｽ�ｿｽ�ｿｽX�ｿｽ�ｿｽ�ｿｽo�ｿｽﾍゑｿｽ�ｿｽ�ｿｽi SYS_XMLGEN �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽ�ｿｽ�ｿｽP�ｿｽ�ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽﾉまとめゑｿｽ�ｿｽ�ｿｽ�ｿｽ`�ｿｽ�ｿｽ�ｿｽ�ｿｽXMLtype�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽ^�ｿｽ�ｿｽ�ｿｽX�ｿｽ�ｿｽ�ｿｽo�ｿｽﾍゑｿｽ�ｿｽ�ｿｽi SYS_XMLAGG�ｿｽASYS_XMLGEN �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽﾊゑｿｽXMLtype�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽ^�ｿｽ�ｿｽ�ｿｽX�ｿｽ�ｿｽ�ｿｽo�ｿｽﾍゑｿｽ�ｿｽ�ｿｽP�ｿｽi XMLCONCAT�ｿｽAXMLELEMENT �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽﾊゑｿｽXMLtype�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽ^�ｿｽ�ｿｽ�ｿｽX�ｿｽ�ｿｽ�ｿｽo�ｿｽﾍゑｿｽ�ｿｽ�ｿｽQ�ｿｽi XMLFOREST �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽ�ｿｽ1�ｿｽ�ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽﾉまとめゑｿｽXMLtype�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽ^�ｿｽ�ｿｽ�ｿｽX�ｿｽ�ｿｽ�ｿｽo�ｿｽﾍゑｿｽ�ｿｽ�ｿｽi XMLAGG�ｿｽAXMLELEMENT �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽw�ｿｽ閧ｵ�ｿｽﾄ��ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽﾊゑｿｽXMLtype�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽ^�ｿｽ�ｿｽ�ｿｽX�ｿｽ�ｿｽ�ｿｽo�ｿｽﾍゑｿｽ�ｿｽ�ｿｽP�ｿｽi XMLATTRIBUTES�ｿｽAXMLELEMENT �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽw�ｿｽ閧ｵ�ｿｽﾄ��ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽﾊゑｿｽXMLtype�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽ^�ｿｽ�ｿｽ�ｿｽX�ｿｽ�ｿｽ�ｿｽo�ｿｽﾍゑｿｽ�ｿｽ�ｿｽQ�ｿｽi XMLCOLATTVAL �ｿｽj |
| �ｿｽk�ｿｽn�ｿｽa�ｿｽf�ｿｽ[�ｿｽ^�ｿｽ作す�ｿｽ�ｿｽ |
|
�ｿｽb�ｿｽk�ｿｽn�ｿｽa�ｿｽA�ｿｽa�ｿｽk�ｿｽn�ｿｽa�ｿｽf�ｿｽ[�ｿｽ^�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽi EMPTY_CLOB�ｿｽAEMPTY_BLOB �ｿｽj |
| �ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ\�ｿｽ�用�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
|
�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ( INNER JOIN ) |
|
�ｿｽO�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽi OUTER JOIN�ｿｽA(+) �ｿｽj |
|
�ｿｽC�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽC�ｿｽ�ｿｽ�ｿｽr�ｿｽ�ｿｽ�ｿｽ[�ｿｽﾌ暦ｿｽ�ｿｽp |
|
�ｿｽ�ｿｽ�ｿｽG�ｿｽﾈＳ�ｿｽp�ｿｽk�ｿｽﾌ可読撰ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾟゑｿｽiWITH�ｿｽ�ｿｽj |
|
�ｿｽX�ｿｽJ�ｿｽ�ｿｽ�ｿｽ[�ｿｽ�ｿｽ�ｿｽ竝��ｿｽ�ｿｽ |
|
�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽSELECT�ｿｽ�ｿｽ�ｿｽﾌ鯉ｿｽ�ｿｽﾊゑｿｽ�ｿｽ}�ｿｽ[�ｿｽW�ｿｽ�ｿｽ�ｿｽ�ｿｽi UNION�ｿｽAUNION ALL �ｿｽj |
|
�ｿｽQ�ｿｽﾂゑｿｽSELECT�ｿｽ�ｿｽ�ｿｽﾌ鯉ｿｽ�ｿｽﾊの搾ｿｽ�ｿｽﾙゑｿｽ�ｿｽ謫ｾ�ｿｽ�ｿｽ�ｿｽ�ｿｽi MINUS �ｿｽj |
|
�ｿｽQ�ｿｽﾂゑｿｽSELECT�ｿｽ�ｿｽ�ｿｽﾌ鯉ｿｽ�ｿｽﾊの重�ｿｽ�ｿｽ�ｿｽf�ｿｽ[�ｿｽ^�ｿｽ�ｿｽ�ｿｽ謫ｾ�ｿｽ�ｿｽ�ｿｽ�ｿｽi INTERSECT �ｿｽj |
| �ｿｽ�ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽﾌ追会ｿｽ�ｿｽ^�ｿｽX�ｿｽV�ｿｽiINSERT�ｿｽAUPDATE�ｿｽADELETE�ｿｽj |
|
SELECT�ｿｽﾌ鯉ｿｽ�ｿｽﾊゑｿｽINSERT�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
|
SELECT�ｿｽﾌ鯉ｿｽ�ｿｽﾊゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾉゑｿｽ�ｿｽAINSERT�ｿｽ�ｿｽ�ｿｽ�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽ�ｿｽU�ｿｽ阨ｪ�ｿｽ�ｿｽ�ｿｽ�ｿｽ( INSERT�ｿｽ`WHEN ) |
|
SELECT�ｿｽﾅ取得�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽl�ｿｽ�ｿｽUPDATE�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
|
�ｿｽX�ｿｽV�ｿｽ�ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽﾌデ�ｿｽ[�ｿｽ^�ｿｽﾉゑｿｽ�ｿｽ�ｿｽﾄ、UPDATE�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽe�ｿｽ�ｿｽﾏ更�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
|
�ｿｽ�ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾝゑｿｽ�ｿｽﾈゑｿｽ�ｿｽ�ｿｽ�ｿｽINSERT�ｿｽA�ｿｽ�ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾝゑｿｽ�ｿｽ�ｿｽ�ｿｽU�ｿｽoDATE�ｿｽ�ｿｽ�ｿｽ�ｿｽi MERGE �ｿｽj |
|
SELECT�ｿｽﾅ取得�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽl�ｿｽ�ｿｽ�ｿｽL�ｿｽ[�ｿｽ�ｿｽDELETE�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
|
�ｿｽd�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽ�ｿｽDELETE�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
| �ｿｽX�ｿｽ|�ｿｽ�ｿｽ�ｿｽT�ｿｽ[�ｿｽh�ｿｽ@�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽN |
|
|
| �ｿｽV�ｿｽX�ｿｽe�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
|
�ｿｽ�ｿｽ�ｿｽﾝのセ�ｿｽb�ｿｽV�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ謫ｾ�ｿｽ�ｿｽ�ｿｽ�ｿｽi USERENV �ｿｽj |
|
�ｿｽc�ｿｽa�ｿｽ�ｿｽ�ｿｽA�ｿｽ�ｿｽ�ｿｽ[�ｿｽU�ｿｽA�ｿｽh�ｿｽo�ｿｽA�ｿｽh�ｿｽ�ｿｽ�ｿｽX�ｿｽA�ｿｽz�ｿｽX�ｿｽg�ｿｽﾈどのシ�ｿｽX�ｿｽe�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ謫ｾ�ｿｽ�ｿｽ�ｿｽ�ｿｽi SYS_CONTEXT �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽ[�ｿｽU�ｿｽ[�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ謫ｾ�ｿｽ�ｿｽ�ｿｽ�ｿｽi USER �ｿｽj |
| �ｿｽ�ｿｽ�ｿｽﾌ托ｿｽ |
|
�ｿｽV�ｿｽ[�ｿｽP�ｿｽ�ｿｽ�ｿｽX�ｿｽi�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽj�ｿｽﾌ取得�ｿｽi SEQUENCE �ｿｽj |
|
SELECT�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽs�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽb�ｿｽN�ｿｽ�ｿｽ�ｿｽ�ｿｽi SELECT�ｿｽ`FOR UPDATE �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾃ搾ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽINSERT�ｿｽEUPDATE�ｿｽ�ｿｽ�ｿｽ�ｿｽ/�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽSELECT�ｿｽ�ｿｽ�ｿｽ�ｿｽi10g�ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽﾚのバ�ｿｽC�ｿｽg�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ謫ｾ�ｿｽ�ｿｽ�ｿｽ�ｿｽi VSIZE �ｿｽj |
|
�ｿｽg�ｿｽD�ｿｽﾌ階�ｿｽw�ｿｽ\�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽo�ｿｽﾍゑｿｽ�ｿｽ�ｿｽi SYS_CONNECT_BY_PATH �ｿｽj |
|
SELECT�ｿｽ�ｿｽ�ｿｽﾊゑｿｽ�ｿｽ�ｿｽ�ｿｽ竄ｷ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽi CHR �ｿｽj |
|
�ｿｽf�ｿｽ[�ｿｽ^�ｿｽﾌダ�ｿｽ�ｿｽ�ｿｽv�ｿｽ�ｿｽ�ｿｽ謫ｾ�ｿｽ�ｿｽ�ｿｽ�ｿｽi DUMP �ｿｽj |
|
|
