사용자 계정 만들기
create user user1 IDENTIFIED by 1234;
grant connect, resource to user1;
create user stmanager IDENTIFIED by test09;
grant connect, resource to stmanager;
drop user stmanager cascade;
일반 연산하기
select 34.5678, floor(34.5678) from dual;
select 34.5678, round(34.5678) from dual;
select 1234.56789, round(1234.56789, -1) from dual;
select 34.5678, trunc(34.5678, 2) from dual;
select mod(10, 3) from dual;
select sin(30), cos(30), tan(30) from dual;
select 'Welcome to Oracle' from dual;
select upper('Welcome to Oracle') from dual;
select lower('Welcome to Oracle') from dual;
select initcap('Welcome to Oracle') from dual;
select length ('Welcome to Oracle') from dual;
select lengthb ('안녕하세요') from dual;
select substr('Welcome to Oracle', 4, 3) from dual;
select substrb('Welcome to Oracle', 4, 3) from dual;
select substr(email, 1, instr(email, '@') -1) as email1
from( select '1234@naver.com' as email from dual);
commit;