Question

Assuming the given text "Informatics Practices Class-XII ", write the SQL statements to do the following:

(i) To print the length of the above string.

(ii) To extract "mat "from the string.

(iii) To print extract "xii "and print it in upper case.

(iv) To print above complete string in upper case.

(v) To print "info "in lower case.

(vi) To check whether "ces "is available in the above string or not.

(vii) To remove the leading and trailing spaces.

Answer

(i)

(ii)

(iii)

(iv)

(v)

(vi)

(vii)

Need a full question paper?

Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.

Start Generating Free