pskfire007的专栏

Oracle提示错误消息ORA-28001: the password has expired首先，以SYS DBA身份进入sqlpuls 打开sqlpuls SQL->请输入用户名：sys as sysdba SQL->密码： 登录成功以后查询DBA用户状态 SQL->select username,account_status from dba_users; ...

ORA-28000: the account is locked第一步：使用PL/SQL，登录名为system,数据库名称不变，选择类型的时候把Normal修改为Sysdba;第二步：选择myjob,查看users;第三步：选择system,右击点击“编辑”；第四步：修改密码，把“帐户被锁住”的勾去掉；第五步：点击“应用”再点击“关闭”；第六步：重新登录就可以通过验证了；...

[code="java"]DECLARE TYPE varray_type IS VARRAY(10) OF NUMBER; varray varray_type := varray_type(1, 2, 3, 4, 5, 6); TYPE varray_string is VARRAY(10) OF VARCHAR2(5); test_string varray_stri...

[code="java"]DECLARE v_key_ty VARCHAR2(20) := 'COND_OFFER_MSG'; outinfo Order_types.Order_info_tp; v_row master_cd%ROWTYPE; CURSOR test_cur IS select * from master_cd where key_...

[code="pl/sql"]DECLARE v_key_ty VARCHAR2(20) := 'COND_OFFER_MSG'; outinfo Order_types.Order_info_tp; TYPE master_cd_record IS RECORD( m_key_ty master_cd.key_ty%TYPE, m_cd mas...

启动：net start mySql; 进入：mysql -u root -p/mysql -h localhost -u root -p databaseName; 列出数据库：show databases; 选择数据库：use databaseName; 列出表格：show tables； 显示表格列的属性：show columns from tableName；...

[code="java"]package com.pskfire.binTreeExample;// tree.java// demonstrates binary tree// to run this program: C>java TreeAppimport java.io.*;import java.util.*; // for Stack class//////...