KnowledgeBoat Logo

Informatics Practices

Consider the string: "Database Management System". Write suitable SQL queries for the following:

I. To extract and display "Manage" from the string.

II. Display the position of the first occurrence of "base" in the given string.

SQL Queries

2 Likes

Answer

I. SELECT SUBSTRING('Database Management System', 10, 6);

II. SELECT INSTR('Database Management System', 'base');

Answered By

1 Like

Related Questions