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 […]

How to open popup window in javascript

Sometimes we need to open new popup window (browser) through javascript without disturbing main window. Popup windows are different to simply opening a new browser window. Here I am sharing different types of popup windows with different properties. Popup window javascript syntax window.open(“url”, “window-Name”, “window-Features”); url: Page url to open new windows, window-Name : name […]

Latest Info

List of Latest Categories Database General Git Hibernate Concepts Java java Java Basics Java Collections Java Concepts Java Exceptions Java Keywords Java Log4j Java OpenCSV Java Security Java Spring Java Struts Java Thread Concepts Java-XML JavaScript Linux-Unix Oracle OWASP SCJP – Collection Framework SCJP- Operators And Assignments SCJP- Static Import Servers Spring SQL Queries Struts2 […]

How to delete folder in GitHub repository and local git repository

Delete folder form GitBash

Sometimes we want to delete folders from GitHub but there is no option in GitHub to delete folder directly. If you want to delete folder from GitHub then we need to open the folder and delete all files one by one and then the folder will be automatically disappeared / deleted. In git repository, the […]

How to install google chrome browser in Ubuntu

By default Ubuntu linux mint having Mozilla Firefox browser so no need to install it externally but google chrome browser will not be installed by default along with Ubuntu installation so we need to install externally by download from google website. Both browsers are very famous, useful and important, without these browsers no system and […]

Version 1.7.0_67 of the JVM is not suitable for this product. Version 1.8 or greater is required

System Environment PATH Variable Setup for JAVA

Eclipse Jee 2018-09 will be launched by using java 1.8 and above. So we need to install java 1.8 or above versions, either 32 bit or 64 bit according your system supports. After installing, you need to set system environment PATH variable of JDK path like C:\Program Files\Java\jdk<version>\jre\bin Error Screen Go to –> Right Click […]

No compiler is provided in this environment

Installed JRE - JDK Selection Eclipse

No compiler is provided in this environment. Perhaps you are running on a JRE rather than a JDK? Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.8.0:compile (default-compile) on project <project-name>: Compilation failure No compiler is provided in this environment. Perhaps you are running on a JRE rather than a JDK? Solution Go to Windows –> Preferences –> Java […]

Java compiler level does not match the version of the installed Java project facet

Java compiler level does not match the version of the installed Java project facet

Java compiler version and project facet selected java version not matching. So we need to change java project facets version according java compiler. Solution Change java project facets java version according java compiler. Select Project –> Right Click –> Project Facets –> Select version in version drop down.