oracle 첫날이유

cmd에서 오라클 관리자로 접근할때 명령어

sqlplus / as sysdba

사용자를 만드는 명령어

create user jyp identified by 1234;

권한 부여

grant connect,resource,dba to jyp;

blob(byte), clob(char)

1씩 증가하는 sequence를 생성

create sequence bid start with 1 increment by 1;

쿼리문을 통해 DB에 값을 insert 해줄땐

<insert id="write_ok" parameterType="com.example.demo.vo.BoardVo">
	insert into board (id,title,pwd,name,content,writeday)
	values(bid.nextval << 요롷게,#{title},#{pwd},#{name},#{content},sysdate)
</insert>

sequence를 확인할땐

 select * from user_sequences;

오라클 DB연결

server.port=8088

spring.mvc.view.prefix=/views/
spring.mvc.view.suffix=.jsp

mybatis.mapper-locations=classpath:mapper/**.xml

spring.datasource.url =jdbc:oracle:thin:@//localhost:1521/xe
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.username=jyp
spring.datasource.password=1234