Oracle SQL

Index of Oracle SQL Tutorials
    1. Create Schema in Oracle Database 11g
    2. Create new schema in Oracle database that have its own tablespace 
    3. Display column values in a row as semicolon separated values (Use of LISTAGG Function) 
    4. Display second highest salary from the table 
    5. Convert number into words using Oracle SQL 
    6. Combine output of two tables and than filter the final output using & 
    7. Query to display 5th to 7th rows from a table
    8. Query to delete duplicate rows from the table in Oracle
    9. Query to display MAXIMUM SALARY of each DEPARTMENT after joining two similar tables
    10. Oracle SQL Query to find duplicate rows in the table.
    11. Oracle SQL Query to find the number of columns in a table
    12. Unlock HR Schema of the Oracle Database
    13. Sorting Alphanumeric values in Varchar2 column in Oracle SQL
    14. Grant CREATE Table privileges to USER in Oracle - ORA-01031: insufficient privileges
    15. Get the version of the installed Oracle Database
    16. ORA-01033: ORACLE initialization or shutdown in progress
    17. ORA-01157: cannot identify/lock data file
    18. ORA-01031: insufficient privileges
    19. ORA-01950: no privileges on tablespace 'USERS'
    20. ORA-04091: table XXX is mutating, trigger/function may not see it
    21. To start Oracle SQL and connect to the database from the Windows Start menu
    22. Display list of available schema in Oracle Database
    23. Change the password for the Oracle Database Schema
    24. Retrieve the nth highest or nth lowest column value from a table




No comments :

Post a Comment