JAVA 레코드 이동 예제

package pack.db; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JTextField; public class DbTest6Rec..

• format_list_bulleted DEV
• · 2018. 1. 19.
• textsms

SQL select 명령어 및 데이터 정렬 예제

-- select [distinct] db명. 소유자명. 테이블명.칼럼명 [as 별명] -- [into 테이블명] from 테이블명... -- where 조건... order by 기준키 [asc / desc] select * from buser; select * from sawon; alter session set nls_date_format='YYYY-MM-DD'; select sawon_no,sawon_name,sawon_pay from sawon; select sawon_pay,sawon_no,sawon_name from sawon; select sawon_no as 사번, sawon_name as 직원명, sawon_pay 연봉 from s..

• format_list_bulleted DATA
• · 2018. 1. 12.
• textsms