🎴 Flashcard Mode
IMS Database and Oracle SQL Functions
Card1 / 19
Mastered0
Review0
QuestionClick to flip
what does the query select * from table_abc where column_xyz like '%oracle%'
AnswerClick to flip back
A
selects all the rows from the table having the column_xyz value containing the word oracle
💡 Explanation:
The % wildcard matches any sequence of characters (including zero characters). '%oracle%' means match any value that contains 'oracle' anywhere - before, after, or in between. It would match 'My oracle database', 'oracle', or '123oracle456'.