oracleDB XE11g R2, DBeaver 21.2.3
wihdow10
SELECT CONCAT('Hello', 'bye'), CONCAT('good', 'bye')
FROM dual
;
SELECT CONCAT('good', 'bye') concats,
'good' || 'bad' operators
FROM dual
;
SELECT INITCAP('good morning')
FROM dual
;
SELECT INITCAP('GOOD MORNING')
FROM dual
;
SELECT LOWER('GOOD'), UPPER('GOOD')
FROM dual
;
SELECT LPAD('good', 6) "LPAD1",
LPAD('good', 7, '#') "LPAD1",
LPAD('good', 8, 'L') "LPAD3"
FROM dual
;
SELECT RPAD('good', 6) "RPAD1",
RPAD('good', 7, '#') "RPAD1",
RPAD('good', 8, 'L') "RPAD3"
FROM dual
;
SELECT LTRIM('goodbye', 'g'),
LTRIM('goodbye', 'o'),
LTRIM('goodbye', 'go'),
LTRIM('goooooooodbye', 'go')
FROM dual
;
SELECT RTRIM('goodbye', 'e'),
RTRIM('goodbye', 'i')
FROM dual
;
SELECT SUBSTR('good morning john', 1, 4)
FROM dual
;
SELECT SUBSTR('good morning john', 8, 4)
FROM dual
;
SELECT SUBSTR('good morning john', 8)
FROM dual
;
SELECT SUBSTR('good morning john', -4)
FROM dual
;
SELECT REPLACE('good morning tom', 'morning', 'evening')
FROM dual
;
SELECT REPLACE('You are not alone', 'You', 'We')
FROM dual
;
SELECT TRANSLATE('You are not alone uuuuuu', 'You', 'Wei'),
TRANSLATE('You are not alone uuooYY', 'You', 'Wei'),
TRANSLATE('You are not alone uuuu', 'You', 'Wei')
FROM dual
;
SELECT SYSDATE FROM dual;
;
SELECT ADD_MONTHS(SYSDATE, 7) FROM dual;
;
SELECT LAST_DAY(SYSDATE) FROM dual;
SELECT SYSDATE + (INTERVAL '1' YEAR),
SYSDATE + (INTERVAL '1' MONTH),
SYSDATE + (INTERVAL '1' DAY),
SYSDATE + (INTERVAL '1' HOUR),
SYSDATE + (INTERVAL '1' MINUTE),
SYSDATE + (INTERVAL '1' SECOND),
SYSDATE
FROM dual
;
SELECT SYSDATE,
TO_CHAR(SYSDATE, 'yyyy/mm/dd'),
TO_CHAR(SYSDATE, 'yyyy-mm-dd'),
TO_CHAR(SYSDATE, 'yyyymmdd'),
TO_CHAR(SYSDATE, 'yyyy-mm-dd HH24:MI:SS'),
TO_CHAR(SYSDATE, 'yyyy-mm-dd HH12:MI:SS'),
FROM dual
;
SELECT FIRST_NAME, LAST_NAME, COMMISSION_PCT,
NVL(COMMISSION_PCT, 0) commition
FROM EMPLOYEES e
;
SELECT DEPARTMENTS_ID,
DECODE(DEPARTMENTS_ID, 20, 'MA', 60, 'IT', 90, 'EX', 'ETC')
FROMA DEPATRMENTS d
;