摘要:
public class TestNewInstance { // 菱形单词: Rhombus public static void main(String[] args) { TestNewInstance r = new TestNewInstance(); r.run(6); r.runx(7); } public void run(int level) { // 菱形... 阅读全文
摘要:
CREATE OR REPLACE TRIGGER check_emp BEFORE update OR insert OR delete ON emp --BEFORE 和AFTER指出触发器的触发时序分别为前触发和后触发方式 REFERENCING new AS nn old AS oo FOR 阅读全文
摘要:
查询各个部门工资范围,按照1000~2000,2000~3000.。。。这样的格式显示人数select * from (select job,count(*) as "1000~2000" from (select sal,job from empwhere sal<=2000 and sal>=1 阅读全文
摘要:
CREATE OR REPLACE PROCEDURE fangfa(job_j varchar2,con_c out NUmBER,sal_s out NUmBER) IS BEGIN SELECT SUM(sal), COUNT(*) INTO con_c, sal_s FROM emp WHE 阅读全文
摘要:
package com.chinasoft.thr.shop;import java.sql.*;public class JDBC { public static final String DRIVER = "com.mysql.jdbc.Driver"; public static final 阅读全文
摘要:
create table duo( --创建表格 v_xuhao number(3), v_name varchar2(10), v_job varchar2(10), v_time date);insert into duo values (001, --添加内容 '李颖', '经理', to_d 阅读全文
摘要:
create table yyy(s# number(2) primary key, --创建 行name varchar2(6), age NUMBER(2),sex varchar2(2),post varchar2(6));insert into yyy values (01,'赵倩','26 阅读全文