분류 전체보기528 [DB] Upper Usage How can we use the Upper method? That's easy! Method AND UPPER(TRIM(MANAGE_CODE)) LIKE ('%'||#{SERCHKEYWORD}||'%') 다음과 같이 두면 f -> F 가 작동되질 않는다. Resolve AND UPPER(TRIM(MANAGE_CODE)) LIKE UPPER('%'||#{SERCHKEYWORD}||'%') // 변수 명에도 괄호로 닫고 UPPER로 감싸주면 작동이 가능하다. To be continued.. 2023. 2. 15. [Career] Search tips 보호되어 있는 글 입니다. 2023. 2. 15. [DB] DataBase Multiple Query Select Usage As working The query stopped my work. So I have to figure out what the problem It is. If we wanna make multiple columns like this COLUMNAME IN ('COLUMN1', 'COLUMN2', 'COLUMN3') Why should we do like this way? Because we use it Search function so we are recommended this method. UPPER means "Capitalizes lowercase letters." where FCLTY_TYPE_CODE IN ('FCT003', 'FCT004', 'FCT005') AND UPPER(REPLACE(M.. 2023. 2. 15. [Dbeaver] Dbeaver Searching Usage Search and Db Full-Text click Type and Click And Search You can see this To be continued.. 2023. 2. 9. [PostgreSQL] PostgreSQL Numbering ROW_NUMBER() We can number in postgreSQL on ROW_NUMBER(); Method (ROW_NUMBER() OVER()), example SELECT (ROW_NUMBER() OVER()), A.MANAGE_CODE, A.ROAD_ADDRESS, A.LATITUDE, A.LONGITUDE, B.CDE_LAB FROM CMT_FCLTY_INF A LEFT JOIN MAN_SYS_CDE B ON A.FCLTY_TYPE_CODE = B.CDE_VAL ORDER BY MANAGE_CODE ASC To be continued.. 2023. 2. 8. [IT] Postman Usage Many Developers had heard about Postman But They didn't know How can use it? I'll show you How to use Postman easily kkk. If you send an address on your Controller.java They will operate normally. So ,The server on And doesn't matter on your prj You can find the data without searching like this. send the postman Now you can see data! we can check the data without searching! And We can see log! T.. 2023. 2. 8. [Jquery] Jquery function List var() : HTML 에 해당한 Elements 의 Value를 회수한다. To be continued.. 2023. 2. 7. [IT] Chrome Developer Mode Tips You can chnage css style immediately. If your mouse cursor put on the style. You gain an authority about changing style, you can change px style by using up key and down key. You see this image that you can change the data immediately. To be continued.. 2023. 2. 7. 이전 1 ··· 16 17 18 19 20 21 22 ··· 66 다음
