There is a code snippet in the query that I don't understand, but i write them down. ^^;
SELECT TO_CHAR(TO_DATE(ROWNUM+2454832, 'J'), 'YYYYMMDD') AAA
FROM (
SELECT LEVEL M FROM DUAL
CONNECT BY LEVEL <= 2556
)
ORDER BY AAA
Result :
DateFormat 'J' Option is
Julian day; the number of days since January 1, 4712 BC. Number specified with J must be integers.
https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm#i34924
Format Models
The total length of a datetime format model cannot exceed 22 characters. The default datetime formats are specified either explicitly with the initialization parameter NLS_DATE_FORMAT or implicitly with the initialization parameter NLS_TERRITORY. You can c
docs.oracle.com
What is the principle of this snippet?
SELECT LEVEL M FROM DUAL
CONNECT BY LEVEL <= 2556
I can guess why, but I don't understand the principle.
Is there anyone who can teach me? ^^;
There is a saying in Korea.
If you don't understand, calm down and read(memorize) it.
^^;
be the happy Gosu.
woojja ))*
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
'DATABASE > ORACLE' 카테고리의 다른 글
[ORACLE] Error - oracle input pattern or replacement parameters exceed 32K size limit (0) | 2022.01.14 |
---|---|
[ORACLE] The maximum number of columns allowed in a table of ORACLE (0) | 2022.01.14 |
[ORACLE] Table 생성 및 Synonym (0) | 2021.07.21 |
[ORACLE] Windows 7 64Bit 에 Oracle Client 설치하기 (2) | 2010.09.15 |
[ORACLE] Oracle Bulk Insert (0) | 2010.03.19 |