Month: May 2019

Oracle query to find alphanumeric data in column

Sample Data SELECT ‘3874’ col FROM DUAL UNION ALL SELECT ’74’ col FROM DUAL UNION ALL SELECT ‘123’ col FROM DUAL UNION ALL SELECT ’22FRE’ col FROM DUAL UNION ALL SELECT ‘ABCD’ col FROM DUAL UNION ALL SELECT ‘AB33FRE’ col FROM DUAL Query Syntax SELECT COLUMN_NAME FROM TABLE_NAME WHERE REGEXP_LIKE(COLUMN_NAME,'[[:alpha:]]’) AND REGEXP_INSTR(COLUMN_NAME,'[0-9]’)>0; Output COLUMN_NAME 22FRE […]

How to Create a JAR file in Linux

Create a Jar File Created 3 sample files as file1.txt, file2.txt and file3.txt -bash-4.1$ ls file1.txt file2.txt file3.txt -bash-4.1$ jar -cvf test.jar * added manifest adding: file1.txt(in = 5) (out= 7)(deflated -40%) adding: file2.txt(in = 5) (out= 7)(deflated -40%) adding: file3.txt(in = 5) (out= 7)(deflated -40%) -bash-4.1$ ls file1.txt file2.txt file3.txt test.jar Unjar a Jar […]