Oracle MySQL & PL/SQL Quick Notes
Hi Guys, We come across few queries in oracle and pl/sql on daily development tasks which we forget/wont remember correctly […]
» Read moreTag: oracle
How to Insert Single and Double Quotes in Oracle?
How to Insert Single and Double Quotes in Oracle? Inserting Single quote in oracle: If your query is like this, […]
» 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 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 moreJoining two tables oracle example
student_details table: select * from student_details; id name 1 divya 2 hems 3 chudar student_rank table: select * from student_rank; […]
» Read more[solved] oracle sql developer unable to launch the java virtual machine located at path
oracle sql developer unable to launch the java virtual machine located at path Error: oracle sql developer unable to launch […]
» Read more