OracleSQL get substring of variable as new variable

Question

I have a column and I would like to get a new column using only the first two characters. I would have assumed the following should work, but it throws FROM keyword not found where expected error

SELECT *,
       SUBSTR(PHONE_NUMBER , 1,2) AS MY_PHONE_NUMBER
FROM PHONE_NOS;

Try it here

forpas · Accepted Answer · 2020-06-18 08:02:41Z

2

Alias the table and use it in the statement:

SELECT p.*,
       SUBSTR(p.PHONE_NUMBER, 1, 2) AS MY_PHONE_NUMBER
FROM PHONE_NOS p;

answered Jun 18, 2020 at 8:02

forpas

165k10 gold badges51 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

safex Over a year ago

rookie mistake... thanks! Leaving the post online, since it does not appear to be a duplicate and possibly others look for the same information

Collectives™ on Stack Overflow

OracleSQL get substring of variable as new variable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related