--login
--member : 회사정보테이블
--userinfo : 회원가입정보 테이블
CREATE TABLE member(
empno number(10) NOT NULL PRIMARY KEY,
name varchar2(20) NOT NULL,
email varchar2(50) NOT NULL,
birthdate DATE NOT NULL);
SELECT * FROM member;
insert into member (EMPNO ,name, email, birthdate)
values ('1234567','bini','bini@gmail.com','19921127');
SELECT empno, name, TO_CHAR(birthdate, 'YYYYMMDD') FROM MEMBER WHERE empno = '44556677' and name = 'limi' and birthdate = '19971027';
SELECT empno, email, name, birthdate FROM MEMBER WHERE empno = '44556677';
SELECT birthdate FROM "MEMBER";
select * from v$NLS_PARAMETERS ;
ALTER session SET NLS_DATE_FORMAT='YYYYMMDD' ;
CREATE TABLE userinfo(
id varchar2(20) NOT NULL PRIMARY KEY,
empno number(10) NOT NULL,
pw varchar2(20) NOT NULL,
phoneNum number(10) NOT NULL,
regidate DATE default sysdate NOT NULL);
SELECT * FROM USERINFO;
DELETE from userinfo where id = 'limi';
insert into userinfo (id ,empno, pw, phoneNum)
values ('limi','12345','1234','01040218639');
ALTER TABLE member MODIFY empno VARCHAR2(10);
DELETE FROM USERINFO WHERE EMPNO = 44556677;
SELECT * FROM USERINFO;
DELETE * FROM "MEMBER";
COMMIT;
CREATE USER team IDENTIFIED BY 1234;
GRANT CONNECT, resource, dba TO team;
insert into userinfo (id ,empno, pw, phoneNum) values ('dongdong', '20230426', '1234', '01012341234');
SELECT * FROM user_tables;
COMMIT;
SELECT * FROM MEMBER;
SELECT TO_CHAR(birthdate, 'YYYYMMDD') FROM MEMBER;
SELECT empno, name, TO_CHAR(birthdate, 'YYYYMMDD') FROM MEMBER WHERE empno=11334455;
SELECT empno, name FROM MEMBER WHERE empno = 112233;
SELECT empno, name, TO_CHAR(birthdate, 'YYYYMMDD') FROM MEMBER WHERE empno = '44556677' and name = 'limi' and birthdate = '19971027';
DROP TABLE MEMBER;