Quick Learn | FAQ's | Technical Solutions

--**************************************************** --RETRIEVING DATA USING THE SQL SELECT STATEMENT --**************************************************** SELECT * FROM EMP; SELECT * FROM DEPT; --**************************************************** --RESTRICTING AND SORTING DATA --**************************************************** SELECT * FROM EMP WHERE DEPTNO = 10; SELECT * FROM EMP WHERE SAL > 800; SELECT * FROM EMP WHERE SAL >= 800; SELECT * FROM EMP WHERE DEPTNO IN (10,20); SELECT * FROM EMP WHERE MGR IS NULL; SELECT * FROM EMP WHERE HIREDATE BETWEEN '17-DEC-1980' AND '01-MAY-1981'; SELECT * FROM EMP WHERE SAL BETWEEN 1000 AND 2000; SELECT * FROM EMP WHERE ENAME LIKE '%MART%'; SELECT * FROM EMP ORDER BY ENAME DESC; SELECT * FROM EMP ORDER BY ENAME ASC; --**************************************************** --USING SINGLE – ROW FUNCTIONS TO CUSTOMIZE OUTPUT ---DUAL IS A DUMMY TABLE THAT YOU CAN USE TO VIEW RESULTS FROM FUNCTIONS AND CALCULATIONS....

Spring Tools 4 for Eclipse: << Spring Tools 4 is the next generation of Spring tooling for your favorite coding environment. Largely rebuilt from scratch, it provides world-class support for developing Spring-based enterprise applications, whether you prefer Eclipse, Visual Studio Code, or Theia IDE. >> https://spring.io/tools https://download.springsource.com/release/STS4/4.6.1.RELEASE/dist/e4.15/spring-tool-suite-4-4.6.1.RELEASE-e4.15.0-win32.win32.x86_64.self-extracting.jar DOWNLOAD spring suite from above link. Extract the JAR file and open "contents.zip" and click on executable application as "SpringToolSuite4.exe" Note*: You need to install latest JDK to run spring tool suite.

List of frequently  used Git commands: git config git init git clone git add git commit git diff git reset git status git rm git log git show git tag git branch git checkout git merge git remote git push git pull git stash git init Usage:  git init [repository name] This command is used to start a new repository. git clone Usage:  git clone [url]    This command is used to obtain a repository from an existing URL. git add Usage:  git add [file]     This command adds a file to the staging area. Usage:  git add *     This command adds one or more to the staging area. git commit Usage:  git commit -m “[ Type in the commit message]”     This command records or snapshots the file permanently in the version history. Usage:  git commit -a     This command commits any files you’ve added with the git add command and also commits any files you’ve changed since then. git diff Usage:  git diff     Th...

## Development server Run << ng serve >> for a dev server. Navigate to << http://localhost:4200/ >>.  The app will automatically reload if you change any of the source files. ## Code scaffolding Run << ng generate component component-name >> to generate a new component.  You can also use << ng generate directive|pipe|service|class|guard|interface|enum|module >> ## Build Run << ng build >> to build the project. The build artifacts will be stored in the << dist/ >> directory. Use the << -prod >> flag for a production build. ## Running unit tests Run << ng test >> to execute the unit tests via [Karma](https://karma-runner.github.io). ## Running end-to-end tests Run << ng e2e >> to execute the end-to-end tests via [Protractor](http://www.protractortest.org/). Update You Angular CLI globally: npm install -g @angular/cli npm install -g @angular/cli@10.2.1 --GLOBAL PATH C:\User...

////---- Function allow Numeric value only function isNumberOnly(evt){        var charCode = (evt.which) ? evt.which : evt.keyCode     if (charCode &gt; 31 &amp;&amp; ///Special Char ASCII (31~47)        (charCode &lt; 48 || charCode &gt; 57)) ///0-9 Number ASCII (48~57)         return false;     return true; } OR function isNumberOnly(evt){        var charCode = (evt.which) ? evt.which : evt.keyCode     if (charCode > 31 &&  ///Special Char ASCII (31~47)        (charCode < 48 || charCode > 57)) ///0-9 Number ASCII (48~57)         return false;     return true; } function fnValidateNumber() { var strNo, regexpNum; strNo  = document.getElementById(" fldIdMyTxtBox ").value; regexpNum = /^[0-9]*$/; if(! strNo == "") { if(! strNo .match(regexpNum)) { document...