Autocomplete using jQuery, PHP and MySQL
Autocomplete is a basic mandatory functionality in any web development. It will help user to find the correct item just […]
» Read moreCategory: Database
Java With MySQL Select Example
Download the users_test table:Users_test table – Mysql download Loading the Mysql connection: Fetching the records: [Select] Mysql With Select Full […]
» Read moreselect with timestamp or date in oracle
select with timestamp or date in oracle: If you want to select the date field or timestamp field with the […]
» Read morecount of max in mysql example query
Count: Count is an aggregate function which returns the count of rows with respect to our query conditions. Max: Max […]
» Read moreAuto increment alter mysql example
Auto increment: If any of your primary field need to be auto incremented. You can alter the column like below […]
» Read moreLISTAGG EXAMPLE IN ORACLE
LISTAGG EXAMPLE IN ORACLE: LISTAGG can be used to get all the row values in single row. Example: [STUDENT_TABLE] Student_id […]
» Read moreOracle Date Formats examples
The below are the mostly used oracle date formats: MM/DD/YYYY HH.MI.SS – 01/23/2014 08.41.56 MM/DD/YYYY HH24.MI.SSFF – 01/23/2014 08.41.56066000 MM/DD/YYYY […]
» Read moreDifference Between to_char and to_date with example
to_char: to_char converts a date to string. Query: Select to_char(sysdate) from dual; Output: 25-NOV-13 Query: Select to_char(sysdate,’DD-MM-YYYY’) from dual; Output: […]
» Read moreEnter the full pathname for java.exe
Enter the full pathname for java.exe Error: Enter the full pathname for java.exe in sql developer. Solution: Path Given: D:\Naveen\jdk1.6.0_45 […]
» Read moreDate format in oracle example
Date format in oracle: oracle 24 hour date format: to_char(sysdate,’MM/DD/YYYY HH24:MM:SS’) oracle 12 hour date format: to_char(sysdate,’MM/DD/YYYY HH:MM:SS’) Sample Query: […]
» Read more