PinnedBiljana JelićHow to delete duplicate rows from a table using the ROW_NUMBER function in SQL?ROW_NUMBER()is one of the SQL’s most useful functions which can be leveraged for many advanced scenarios and use cases. Some of those…4 min read·Sep 13, 2022----
Biljana JelićEASY WAY TO CREATE A VIEW FROM THE TABLE IN SQLI came across a challenge that required creating a view from a very complex table with 30+ columns. The goal was to create a view almost…3 min read·Jan 26, 2024----
Biljana JelićSQL COLLATION ISSUESIf you’ve ever encountered the ‘Cannot resolve the collation conflict’ error message while working in SQL Server Management Studio (SSMS)…4 min read·May 9, 2023--1--1
Biljana JelićSQL function we could use more often — ASCII () function with examplesASCII is an abbreviation for American Standard Code for Information Interchange, and to make things a bit more clear it is a character…6 min read·Apr 8, 2021----
Biljana JelićHow to create a batch script and a task scheduler on Windows server 2012A batch file is a script file which contains series of commands that get executed one after the other, in sequence. A batch file is…4 min read·Feb 11, 2020----
Biljana JelićOracle APEX — Basic authorization for REST servicesRoles, privileges and privilege mapping4 min read·Oct 10, 2019--1--1
Biljana JelićHow to install ORDS and rename it to APEXwww.mydomain.com/apex5 min read·Apr 9, 2019--1--1