Posts Tagged ‘sql queries’

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

Powered by k2schools