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..

Search and Db Full-Text click Type and Click And Search You can see this To be continued..

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..

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..

var() : HTML 에 해당한 Elements 의 Value를 회수한다. To be continued..