泡泡乐园

一：无返回值的存储过程调用存储过程：CREATE OR REPLACE PROCEDURE PRO_1(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2) AS BEGIN INSERT INTO DBO.EMP (ID,NAME) VALUES (PARA1, PARA2);END PRO_1;Java代码：package com.icesoft.service;import java.sql.*;import java.sql.ResultSet;public class CallProcedureTest1 {public CallProcedureTest1() Read More

CREATE OR REPLACE PACKAGE typesAS TYPE ref_cursor IS REF CURSOR;END;/CREATE TABLE STOCK_PRICES( RIC VARCHAR(6) PRIMARY KEY, PRICE NUMBER(7,2), UPDATED DATE );/CREATE OR REPLACE FUNCTION sp_get_stocks(v_price IN NUMBER) RETURN types.ref_cursorAS stock_cursor types.ref_cursor;BEGIN OPEN stock_cursor F Read More

由于刚装好，默认数据库的字符集是AL32UTF8 公司用的字符集是ZHS16GBK，于是用下面方法改了字符集 sqlplus sys_name/sys_password as sysdba shutdown immediate; startup mount alter system enable restricted session; alter database open; alter database character set internal_use ZHS16GBK; shutdown immediate startup 字符集是改好了，结果发现附带的APEX变成乱码了。解决办法：修 Read More

import java.util.*;/** * This program demonstrates the equals method. * @version 1.11 2004-02-21 * @author Cay Horstmann */public class EqualsTest{ public static void main(String[] args) { Employee alice1 = new Employee("Alice Adams", 75000, 1987, 12, 15); Employee alice2 = alice1; Employe Read More

Itried to install EntityFramework 4.1 on VS 2010 through NuGet. I searched and found the package through "Tools > Library Package Manager > Add Library Package Reference" tool and I got this error: "This package (or one of its dependencies) contains powershell scripts and needs Read More