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
DateFormat 'J' Option is
Julian day; the number of days since January 1, 4712 BC. Number specified with J must be integers.
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.
'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|