Sql stands for Structured Query Language. is the language to communicate with the rdbms. plsql is the programming part of sql
Oracle sql and plsql are the languages which are widely used. They are easy to learn and apply. Here I would be listing out all the articles on Oracle sql and plsql
I am starting the basics so it is very helpful for the beginners to run sql and plsql here
We often need to find and delete duplicate rows from the Oracle table due to many reasons in the database. We need to delete to clear off the data issues often. There are many ways to delete duplicate rows but keep the original.I will be showing off a few faster methods to achieve it in …
delete duplicate rows from Oracle Read More »
As part of learning the Oracle SQL tutorial, Here is good detail on the group by Oracle Group by Oracle We use Group by in the select statement to group rows into summary rows using column or expression. We often used aggregate or group functions on the group to obtain the summary rows Syntax SELECT col1, …
This is part of the Oracle SQL tutorial and has good examples and explanations of the Oracle LISTAGG Function. Oracle LISTAGG function Oracle LISTAGG function is an analytical function that allows us to concatenate the strings for measure_column for each GROUP based on the order_by_clause. This is present in Oracle from 11gR2 The syntax for the LISTAGG …
Question 1. What is a table Cluster?Answer: A table Cluster is a group of related tables that share common columns are store related data in the same block. Question 2. What is EXISTS usage in SQL? Answer “exists” statement helps us to do the job of the If statement. The main query will get executed if …
This is part of the Oracle SQL tutorial and has good examples and explanations on Regexp in Oracle. regexp in oracle The following functions have been introduced REGEXP_LIKE: Similar to the LIKE operator, but performs regular expression matchinginstead of simple pattern-matchingREGEXP_REPLACE: Searches for a regular expression pattern and replaces it with areplacement stringREGEXP_INSTR: Searches for a given …
Regexp in oracle : functions ,Regular expression Read More »
ORA-00937: not a single-group group function is one of the common messages we often get while aggregating data. Causes of ORA-00937: not a single-group group function This error happens when you are using a mixture of individual columns and aggregate functions in the same select statement without using any group by clause with that individual …
ORA-00937: not a single-group group function Read More »
