dongxiexie的博客

找到tnsnames.ora文件，位置：D:\app\orcl\product\12.2.0\dbhome_1\network\admin复制出数据库的描述，只需要加粗部分ORCL =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    (CONNECT_DATA =      (SER...

– 添加主键约束，并指定索引alter table public_db_log add constraint pk_con_pri_key primary key (id_public_db_log) using index idx_id_public_db_log;drop table public_db_log;create table public_db_log( i...

包头create or replace package pkg_interview_test is --公共常量，变量 /** * 对user_info表造数 * num 条数 **/ procedure pro_gene_user_data(num number); -- ...

包头create or replace package study is -- 定义动态游标类型 type type_cur is ref cursor; procedure pro_page_query(page_no number,page_size number, total_num out number , rs_data_cur out ty...

查看原文：https://blog.youkuaiyun.com/xiaokui_wingfly/article/details/45953633查看原文：https://blog.youkuaiyun.com/liangweiwei130/article/details/38223319