Sarthaks Test
0 votes
in Information Technology by (47.5k points)
closed by

Considering the same string “Preoccupied” 

Write SQL commands to display:

(a) the position of the substring ‘cup’ in the string “Preoccupied” 

(b) the first 4 letters of the string

1 Answer

+1 vote
by (46.3k points)
selected by
Best answer

(a) select instr 'Preoccupied' , ‘ 'cup'));

(b) select left 'Preoccupied',4);

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.