What will be the output of the following query?
SELECT SUBSTRING('987654321', INSTR('foobar', 'o'), 5) from DUAL;
98765
87654
76543
65432
Correct Answer:
Explanation:
Note: This Question is unanswered, help us to find answer for this one
SQL Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More SQL MCQ Questions
SELECT (ROUND(3.5 MOD 4)) from DUAL;
Which query can be used to copy all records from table1 into table2 provided they have the same columns?
Which of the following operators can be used to check if a column contains NULL value?
Which of the following commands is used to explain access to data?
For a table with the following columns:
product_id, product_name, supplier_id, price
Which of the following queries will give you the supplier with the maximum average price of products?
What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()
which of the following is NOT a SQL wildcard
Which of the following KEYWORDS will return the first NON-NULL value from a list of columns?
Which of the following types of triggers can be used with a view?
What is a collation?