摘要: TECHONTHENNTE WEBSITE: https://www.techonthenet.com/oracle/functions/to_char.php Oracle / PLSQL: TO_CHAR Function This Oracle tutorial explains how to 阅读全文
posted @ 2017-11-11 14:45 杨杨yang 阅读(187) 评论(0) 推荐(0)
摘要: My personal website: http://47.94.240.229:8080/yjh/project/ 阅读全文
posted @ 2017-11-10 22:00 杨杨yang 阅读(274) 评论(0) 推荐(0)
摘要: 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 阅读(160) 评论(0) 推荐(0)
摘要: question:how find a record import other database. answer: solution one:you user insert into table_name values(value1,value2,...) solution two(recommen 阅读全文
posted @ 2017-11-08 00:14 杨杨yang 阅读(188) 评论(0) 推荐(0)
摘要: 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 阅读(218) 评论(0) 推荐(0)
摘要: TELENT COMMAND DEFINE:Telnet is a command control your cmd windows of remote computer. step: 1.Open you server in the two computer each oter communica 阅读全文
posted @ 2017-11-06 22:18 杨杨yang 阅读(328) 评论(0) 推荐(0)
摘要: Question:When you use developer tool in oracle.However,you press Ctrl and click left-mouse in a table.It isn't show table attribution. solution one:Op 阅读全文
posted @ 2017-11-06 20:48 杨杨yang 阅读(171) 评论(0) 推荐(0)
摘要: Excel Enter and format data Layout Combine text from two or more cells into one cell Combine text from two or more cells into one cell Applies To: Exc 阅读全文
posted @ 2017-11-06 00:32 杨杨yang 阅读(909) 评论(0) 推荐(0)
摘要: Oracle / PLSQL: LPAD Function This Oracle tutorial explains how to use the Oracle/PLSQL LPAD function with syntax and examples. Oracle / PLSQL: LPAD F 阅读全文
posted @ 2017-11-06 00:12 杨杨yang 阅读(181) 评论(0) 推荐(0)
摘要: WEBSITE:https://stackoverflow.com/questions/14564641/drop-a-table-in-a-procedure Qusetion:Hou to use procedure drop a table in oracle. Eample Syntax 阅读全文
posted @ 2017-11-04 13:35 杨杨yang 阅读(258) 评论(0) 推荐(0)