某mysql字段如下：
`test_id` int(11) not null auto_increment comment '自增字段',
而且有大量的这样字段需要转到oracle，首先我们知道oracle的字段描述里面是没有comment的，但是同时也需要保留comment信息。使用正则表达式来转换，用notepad++正则表达式替换：
查找目标：
comment(.*),
替换为：
,comment\1
\1表示的是(.*)的内容
最后替换为：
`staff_id` int(11) not null auto_increment ,– '自增字段'
然后去掉反引号，去掉auto_increment，手动加上constraint primary key。
一般我们建表结构的时候都是使用以下的形式：
create table test(
menuid number(8) default '0' not null,
name varchar2(40) not null,
id_parent number(10) not null,
url varchar2(300) null,
constraint pk_test primary key(menuid)
);
执行后，查看这个test表的所有约束：
select constraint_name,table_name from user_constraints
发现命名都是SYS_CXXXXXX（XXXXXX表示数字），这些是oracle自动给约束的命名，我感觉为了提高以后数据库的可维护性，还是需要给not null约束指定名称，语法很简单：
create table test(
menuid number(8) default '0' constraint menuid_nn not null,
name varchar2(40) constraint name_nn not null,
id_parent number(10) constraint id_parent_nn not null,
url varchar2(300) null,
constraint pk_test primary key(menuid)
)
参考
SQL> create or replace table testTb; create or replace table testTb ORA-00922: 选项缺失或无效只能使用先drop再create来代替
drop table testTb;
create teble testTb(
fid varchar2(4),
fname varchar2(10)
);
可以用create or replace的对象有：functions, procedures, packages, types, synonyms, trigger and views，就是没有table，也没有sequence。
drop掉一个并不存在的表报错：
SQL> drop table non_exists; drop table non_exists ORA-00942: 表或视图不存在drop table容错的方法是：
BEGIN
DROP TABLE non_exists_table;
EXCEPTION
WHEN OTHERS THEN
IF sqlcode != -0942 THEN RAISE; END IF;
END;
/
错误代码：-0942
BEGIN
DROP SEQUENCE non_exists_sequence;
EXCEPTION
WHEN OTHERS THEN
IF sqlcode != -2289 THEN RAISE; END IF;
END;
/
错误代码：-2289
参考
所有版本：https://addons.mozilla.org/zh-CN/firefox/addon/autoproxy/versions/
，还没有通过firefox addon审核。function db_connect()
{
return @ocilogon($this->username, $this->password, $this->hostname);
}
function db_pconnect()
{
return @ocilogon($this->username, $this->password, $this->hostname);
}
here is the prototype of oci_connect( ocilogon improved version )
resource oci_connect ( string $username , string $password [, string $db [, string $charset [, int $session_mode ]]] )codeigniter最新的2.0.1太蛋疼鸟。system/database/drivers/oci8/oci8_driver.php里面的db_connect()和db_pconnect()函数尽然不支持连接的时候设定字符集，因为函数的原形ocilogon（被oci_connect代替）支持设定charset和session_mode。还有codeigniter为啥要使用@ocilogon而非oci_connect呢？php官方说5.0.0以前的版本才使用ocilogon，codeigniter为了使用ocilogon不报warning还前面加上了”@”符号。但是codeigniter声称是支持php 5.1.6以及以后版本的php框架。有点搞不懂codeigniter的想法了。 没有版本，这个问题，只有通过hard coding修改oci8_driver.php文件的db_connect()和db_pconnect()函数为：
function db_connect()
{
return @ociplogon($this->username, $this->password, $this->hostname, $this->char_set);
}
function db_pconnect()
{
return @ociplogon($this->username, $this->password, $this->hostname, $this->char_set);
}
已经将这个问题提交到bitbucket。 Connection Parameters
Not all of the parameters in application/config/database.php are used as one might expect. Namely, $db[‘default’][‘database’] isn’t used at all. The value used for $db[‘default’][‘hostname’] depends on whether the Oracle client’s tnsnames.ora file exists and contains information about the database to be used. If the file exists and is configured for the intended database, this parameter should be set to the symbolic name. Otherwise, it should be set to a single string of the connection parameters that tnsmames.ora would normally contain.
An example of connection parameters for the latter case:
$db['default']['hostname'] = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=orcl)))';
$db['default']['username'] = 'dbuser';
$db['default']['password'] = 'dbpassword';
$db['default']['database'] = ''; // not used by this Oracle driver
$db['default']['dbdriver'] = 'oci8'; In this case, the appropriate values need to be set for the HOST, PORT, and SID keywords in the hostname parameter.
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />mysql数据库统一字符集utf-8，校队：utf8_general_ci 就可以了，系统可以在“标准规范模式”正常浏览不出现乱码。 可能在后期处理上传的ms office文档的时候有转码的需要。
最近玩codeigniter，使用netbeans写代码，调试器使用xdebug（貌似netbeans不支持zend debugger？之前用过的zend studio支持zend debugger），写了一个demo，然后ctrl+F5调试的时候，进过（F8）了几步之后出现如图上的问题：”The URI you submitted has disallowed characters.”，因为codeigniter对$_GET、$_POST等外来参数有一个“白名单”的机制来加强了安全性，如果你的参数没有加入“白名单”，那肯定是有问题了。
而xdebug调试的时候自动加上了参数 XDEBUG_SESSION_START，所以肯定报错。
http://ci-study/index.php?XDEBUG_SESSION_START=tun-xdebug在CI 2.0的/application/config/config.php Line 112有以下内容：An Error Was Encountered
The URI you submitted has disallowed characters.
/*|--------------------------------------------------------------------------| Allowed URL Characters|--------------------------------------------------------------------------|| This lets you specify with a regular expression which characters are permitted| within your URLs. When someone tries to submit a URL with disallowed| characters they will get a warning message.|| As a security measure you are STRONGLY encouraged to restrict URLs to| as few characters as possible. By default only these are allowed: a-z 0-9~%.:_-|| Leave blank to allow all characters -- but only if you are insane.|| DO NOT CHANGE THIS UNLESS YOU FULLY UNDERSTAND THE REPERCUSSIONS!!|*/$config['permitted_uri_chars'] = 'a-z 0-9~%.:_\-'; |
$config['permitted_uri_chars'] = 'a-z 0-9~%.:_\-'; |
$config['permitted_uri_chars'] = 'a-z A-Z 0-9~%.:_\-'; |