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 […]
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…
How to delete folder in GitHub repository and local git repository
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…
Evaluation Order of Java Operand
Evaluation Order of Java Operand Before applying any operator, all the Operands should be evaluated from left to right.
Precedence Of Java Operator
Precedence Of Java Operators Uniary Operators :- [ 1st level [ ], x++, x– ], [ 2nd level ++x, –x, ~, ! ], [ 3rd level new, <type> ]. Arithmetic Operators:- *, /, %, +, – . Shift Operators:- >>,…
New Operator New operator can be used for the creation of Object. Note:- There is no delete operator in java, Destruction of useless Objects will take care by Garbage Collector.
The only ternary operator available in java is conditional operator. int a = ( 10<20 ) ? 30 : 40 ; System.out.println( a) ; // 30 Nesting of conditional operator is also allowed in java. int x = ( 100>200…
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 […]
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
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 […]
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 […]
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. 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 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.