Month: November 2023

average in sql oracle

How to Use Average in SQL Oracle: 5 Simple Examples

The average in SQL Oracle function is an aggregate and analytic function taking an average of a set of numeric value lists. The AVG() function is able to average DISTINCT ...

Asiri Gunasena

November 27, 2023

oracle order by index

Oracle ORDER BY Index | How to Perform? | 6 Examples

Oracle order by index is a good option to sort data by improving performance. Sorting is used when you want to order the data in a specific manner but if ...

Asiri Gunasena

November 20, 2023

oracle order by performance

Ultimate Guide To Oracle Order By Performance 10 Tips

Oracle order by performance is considered more often when doing performance improvements. There are lots of techniques are help in tuning and sorting queries but it depends on several factors ...

Asiri Gunasena

November 13, 2023

Case vs Decode in Oracle Performance

How to Change Case vs Decode in Oracle Performance

How to change case vs decode in Oracle performance? Performance change oracle decode vs case is simple and easy. DECODE was introduced in early Oracle release but CASE was introduced ...

Asiri Gunasena

November 6, 2023

ennicode

Address: 89/1 Rabbegamuwa, Handessa, Kandy, Central, Sri Lanka

Email to: Primary: [email protected]

Services

Company Websites

Support and Configuration work

Banners, Covers, and Post

Web Development & Configurations

Content Writing and Marketing

Resources

Developer Center

Contact