Topic / oracle
Technical notes related to oracle.
01 / notes
Technical notes with examples, code, context, and stable individual URLs.
Have you ever wondered how to handle dates and times efficiently in Oracle? Oracle date and time functions are essential for performing temporal calculations and managing time-based data in your databases.
Read note
This article reveals the secrets of Oracle Job Scheduler, from basic concepts to advanced features, with practical examples to help you master this essential tool.
Read note
Aggregate functions are essential for summarizing and analyzing large data sets. This article guides you from basic to advanced concepts, exploring how to use them with GROUP BY.
Read note
Have you ever needed to find specific data in an Oracle database but were unsure how to do it effectively? The LIKE statement is a powerful tool for flexible searches.
Read note
Have you ever felt that your Oracle queries are slower than they should be? Indexes might be the solution you are looking for. This article explains how to use and optimize them.
Read note
The Oracle TRUNC function is a powerful tool that many database professionals underestimate. Have you ever wondered how to simplify complex data, such as dates and numbers, to create clearer and more accurate reports?
Read note
Subqueries are a fundamental tool in Oracle databases, allowing you to perform complex queries and obtain precise results. This article explains single-value and multi-value subqueries.
Read note
Have you ever felt like a juggler trying to untangle your data in Oracle SQL? Do not worry!
Read noteHave you ever experienced the frustration of running SQL queries that consume too many resources in your Oracle database?
Read noteWhen working with Oracle SQL, you may find yourself needing to combine the results of several queries into a single output.
Read note02 / map
A clear structure for finding answers without losing the context.
