These are some interview question and answer asked during my recent interview. Oracle interview questions are very important during any programming j…
Many time we need SQL query which returns data page by page i.e. 30 or 40 records at a time, which can be specified as page size. In fact, Database p…
One of the most common task while writing SQL queries or stored procedure is to find the length of String. Since most of the columns are VARCHAR, you…
Unlike Java, Microsoft SQL Server 2008, 2012, 2014, and even the latest version don't have a built-in trim() function, which can remove both lea…
There is no doubt that writing code is more art than science, every coder cannot write beautiful code which is both readable and maintainable, even w…
Hello guys, if you are interested in learning SQL with MySQL database and looking for some awesome resources e.g. books, tutorials, and online course…
Hello Guys, you might have heard about how useful the EXISTS clause is helpful in writing sophisticated queries. Still, at the same time, I have also…
The SQL is one of the most important skills for any programmer be it a Java, C++, Python, JavaScript, or Ruby developer. Almost 95% of the Java appli…
PostgreSQL is one of the most popular databases after the big three - Oracle, SQL Server, and MySQL. PostgreSQL is commonly known as Postgres and is …
Hello guys, you might know that along with Oracle and MySQL, Microsoft SQL Server is one of the most popular relational databases in the tech world. …
Hello guys, we are already in the first week of New year and everyone is talking about their goals to improve them as a better person, a better progr…
In last summer, I had to work on a Java project which was using the Oracle database at their backend. The project was a mix of Java code with Oracle …
Write a SQL query to find all duplicate emails in a table named Person. +----+---------+ | Id | Email | +----+---------+ | 1 | a@b.com | | 2 | c@…