SQL> create table employee (employee_id int,
name varchar (100),
city varchar (50),
zipcode varchar (10) null);
Table created.
SQL> insert into employee values (1, 'Javier Martin', 'Madrid', null);
1 row created.
SQL> select name, city || ':' || zipcode from employee;
NAME CITY||':'||ZIPCODE
-------------------------------------------- -------------------
Javier Martin Madrid:
SQL>
CONCAT_NULL_YIELDS_NULL
hdbsql SP4=> select name, city || ':' || zipcode from employee;
> go
NAME,CITY||':'||ZIPCODE
Javier Martin,?
""
1 row selected (overall time 114,776 msec; server time 3207 usec)
hdbsql SP4=> select name, city || ':' || IFNULL (zipcode,'') from employee;
> go
NAME,CITY||':'||IFNULL(ZIPCODE,'')
Javier Martin,Madrid:
""""
1 row selected (overall time 75,223 msec; server time 2801 usec)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
21 | |
16 | |
13 | |
12 | |
11 | |
10 | |
8 | |
8 | |
7 | |
7 |