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 […]
Month: May 2019
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 […]
Start or Stop Oracle XE in Linux
Login to Linux Server as a Root user $sudo su – Root <Start Oracle XE Service> $service oracle-xe start <Stop Oracle XE service> $service oracle-xe stop Ramesh Kunamaneni (RK)Greetings!! This is Ramesh Kunamaneni (RK), I have a decade experience in IT and worked for various MNCs. I am happy to share my knowledge in this […]
