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) 编辑
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) 编辑
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) 编辑
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) 编辑
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) 编辑
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) 编辑
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) 编辑
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) 编辑
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) 编辑
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) 编辑