I want Oracle to return a value that belongs to a particular column to a blank character.

This is a rudimentary question, but what syntax can you think of if you want to get the following results from SQL?

No Name Address Tel
1 test + 81
2 hoge+81
3 hoge+81

Normally, a value is entered in the address, but I would like to leave the column itself and replace the value with empty characters to obtain the result.

Please let me know if there is any good way.

sql oracle

2022-09-30 14:40

1 Answers

As far as I can read your question,

SELECT No, Name, 'AS Address, Tel FROM the_table;

I think it would be good to write like this.Please let me know if there is anything I can't do.

2022-09-30 14:40

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656