Posts Tagged ‘sql examples’

SQL Queries

1) SQL Query to write ‘ORACLE’ string vertically Query: SELECT SUBSTR(‘ORACLE’, ROWNUM, 1)FROM DUAL CONNECT BY LEVEL <= LENGTH(‘ORACLE’) 2) Display 1 to 10 numbers using DUAL table Query: SELECT ROWNUM FROM DUAL CONNECT BY LEVEL <= 10

Find the countries that have two “o” characters separated by two others.

answer: SELECT name FROM world WHERE name LIKE ‘%O__O%’;

Powered by k2schools