We all know that != operator is equivalent to <> operator. But there is another one, less known, which is ^=
Be prepared, this question can be on the exam.
select * from employees where first_name <> last_name; select * from employees where first_name != last_name; select * from employees where first_name ^= last_name;
All three statements will produce the same results
The sequence keywords CURVAL and NEXTVAL can’t be used in: the condition of a CHECK constraint the DEFAULT value of a table column […]
Time. Candidates often either run out of time before finishing every question or have to rush to answer later questions. Time management and […]
It is a new feature in 12c – now you can use sequence while creating a column. In the example below, the sequence […]
You can’t apply a TO_CHAR() function to an argument with CHAR data type because 10-JAN-16 is already a CHAR literal. It will generate an […]
