随笔 - 61,  文章 - 0,  评论 - 0,  阅读 - 23348

随笔分类 -  question_oracle

This is a qestion and answer way oracle
SP2-0734: unknown command beginning "lsnrctl st..." - rest of line ignored.
摘要:SP2-0734: unknown command beginning "lsnrctl st..." - rest of line ignored. Cause(原因):Command was being entered as an SQL command.在SQL命令窗口输入命令。Resolut 阅读全文
posted @ 2018-01-07 19:58 杨杨yang 阅读(6604) 评论(0) 推荐(0) 编辑
How to rename table name
摘要:How to rename table name eg. rename emp to emp01; see aslo: https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqljrenametablestatement.html 阅读全文
posted @ 2017-12-13 21:08 杨杨yang 阅读(123) 评论(0) 推荐(0) 编辑
recycle bin tip
摘要:if you have a question about recycle bin that can look the follow link; http://www.dba-oracle.com/t_oracle_recycle_bin.htm 阅读全文
posted @ 2017-11-28 23:41 杨杨yang 阅读(134) 评论(0) 推荐(0) 编辑
how to drop multiple talbes in oracle use a sigle query
摘要:Tool:PL/SQL developer Syntax:SELECT 'DROP TABLE ' || table_name || ';' FROM user_tables; 1.then you can copy select result in command widows. 2.you ca 阅读全文
posted @ 2017-11-25 09:56 杨杨yang 阅读(132) 评论(0) 推荐(0) 编辑
ORA-12514
摘要:ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 监听器目前不知道在连接描述符中的服务请求。 Expert Oracle Database Tips by Donald 阅读全文
posted @ 2017-11-25 01:00 杨杨yang 阅读(442) 评论(0) 推荐(0) 编辑
calculate fraction by oracle
摘要:QUESTION:When you meet calculate fraction in oracle SOLUTION: 1.Check out their values respectively. the use sign of division. select count(1) from em 阅读全文
posted @ 2017-11-13 21:36 杨杨yang 阅读(195) 评论(0) 推荐(0) 编辑
How to reference two table when lack reference column.
摘要:Question:How to reference two table when lack reference column. Example: 1.Create two tables the one of lack reference column. 2.add a column become a 阅读全文
posted @ 2017-11-08 22:24 杨杨yang 阅读(148) 评论(0) 推荐(0) 编辑
when create a table,then show error ora-00952 tablespace tsb_1 not exist
摘要:QUESTION:When create a table,then show error ora-00952 tablespace tsb_1 not exist. STEP: 1.select user table tablespace. SELECT username,DEFAULT_TABLE 阅读全文
posted @ 2017-11-07 20:34 杨杨yang 阅读(212) 评论(0) 推荐(0) 编辑
how to determint wether two column equals
摘要:question: How to determint wether two column equals? Answer: Table one:RecordId = 1,CommonId = 5,Approved = 1. RecordId = 2,CommonId = 5 Approved = 0. 阅读全文
posted @ 2017-11-01 23:24 杨杨yang 阅读(234) 评论(0) 推荐(0) 编辑
oracle_How to Recover Data (Without a Backup!)
摘要:How to Recover Data (Without a Backup!) It's the classic career-limiting maneuver(职业限制机动): accidentally deleting data you weren't meant to. It's easy 阅读全文
posted @ 2017-11-01 01:14 杨杨yang 阅读(209) 评论(0) 推荐(0) 编辑


< 2025年2月 >
26 27 28 29 30 31 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 1
2 3 4 5 6 7 8
点击右上角即可分享
微信分享提示