wj8298332的专栏

安装完oracle，用PL/sql登陆不进去，报ora-12514的错误。解决办法：1. 打开/network/admin/listener.ora文件，找到：SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = PLSExtProc)(ORACLE_HOME

存储过程创建语法：       create or replace procedure 存储过程名（param1 in type，param2 out type）as 变量1 类型（值范围）;变量2 类型（值范围）;Begin    Select count(*) into 变量1 from 表A where列名=param1；    If (判断条件) then

一、安装1. Start the installer ‘Setup.exe’. Wait till ask about the path;2. Do not press next. Open with Windows Explorer the folder like this:C:\Users\\AppData\Local\Temp{60712028-B7B0-4EC3-9C28-66

PDM生成sql的方法（应用oracle）：工具栏里的Database--》Database Generation（Ctrl + G）Directory：导出路径File name：导出名（我写的是myself.sql）点击“确定”。 如果报错：Generation aborted due to errors detected during the verification