Question

What are the results of this query?

Data in the table blof:

ofcbldg
--------------------
Building K #112
#115 K
Office K#114

Query:
SQL>  SELECT SUBSTR(ofcbldg,instr(ofcbldg,'#')+1,3) 
  2 FROM blof;

Answer 1

SELECT SUBSTR(ofcbldg,instr(ofcbldg,'#')+1,3) 2 FROM blof;

instr(ofcbldg,'#') will find the position of # character in the ofcbldg column

instr(ofcbldg,'#') + 1 is the first argument of SUBSTR function and second argument is 3

So SUBSTR will extract the 3 characters from the column ofcbldg starting from the character after # character

There are 3 rows in the column ,so values extracted will be :

112

115

114

and the new calculated column name is 2

2

----

112

115

114

Do ask if any doubt. Please upvote.