For a better value proposition to the reader, I’ll leapfrog to NULL handling after a small introduction to SQL.
PL/SQL stands for Procedural Language/Structured Query Language. 1,025 more words
Did you know that the SQL language allows you to do amazing analysis of data such as aggregate functions?
SELECT t.session_id, t.request_id, SUM(t.user_objects_alloc_page_count) AS UserObjectAllocated, SUM(t.user_objects_dealloc_page_count) AS UserObjectDeallocated FROM sys.dm_db_task_space_usage AS t GROUP BY t.session_id, t.request_id; … 609 more words
A common misconception when writing PL/SQL select …. into … statements is that if it is an aggregation query (a query that is using an aggregation like count, max, min, avg, etc.) then they always return a result – possibly null – so a NO_DATA_FOUND exception will never occur. 639 more words
The SQL language is very intuitive. Until it isn’t.
Over the years, a lot of people have criticised the SQL language for a variety of reasons. 2,735 more words