oraclestudy.com ADD_MONTHS(SYSDATE, -1) by admin|Published September 24, 2017 This is a typical error that many students do: The right answer is “07-MAY-1996”. The time component will not be displayed
Published February 1, 2018 IN vs EXISTS Both techniques are going to be tested during the exam. IN and EXISTS are not the same. And they work absolutely differently. IN picks […]
Published April 13, 2018 You can have only one LONG field per table Oracle won’t let you create a table with more than one LONG data type. Only one LONG is allowed per table. And […]
Published May 4, 2019 IN NULL vs IS NULL This is one more common mistake the one can make when it comes to NULL engaged with comparison Consider these two statements, […]
Published January 26, 2018 SUBQUERY within VALUES clause? The common perception is that SUBQUERY can’t be used inside the VALUES clause. And frankly speaking, there are many situations on the […]