ORACLE ERP & APPS TECH

Hello all, When I Google'ed for a quick reference of SQL commands, there was vast amount of data available in different websites to pick, then i wanted to try bring all of them under a single roof. So here are my efforts in the form of "Pocket SQL". I'm just writing this blog to get a fast review of some of the SQL commands utilized in my experience. So, What ever I'm posting here is truly for my reference, which can be utilized by users as per their need. SQL and its featuers SQL is the language used to communicate with the server to access, manipulate and control data. The main features: easy to use. SQL is a non-procedural language. reduces the amount of time required for creating and maintaining system

Query to get comma separated values into each row SELECT TRIM(regexp_substr(:l_comma_code,'[^,]+', 1, level)) Comma_col_value                            FROM dual                      CONNECT BY regexp_substr(:l_comma_code,'[^,]+', 1, level) is not null;

RDBMS is composed of relations, managed by relational operations, and governed by data integrity constraints

The datatypes which hold a simple value like char, varchar, number etc.