摘要:
Dependent Parameters in Oracle Applications Requirement: Say there is a concurrent program that lets you retrieve employee details based on employee name or employee number. The concurrent program has... 阅读全文
posted @ 2017-12-12 19:50
全威儒
阅读(806)
评论(0)
推荐(0)
摘要:
User Mangement Application helps system administrators to assign or un-assign a responsibility for multiple users at a time. Yes, We don’t have to manage individual user accounts for assigning the res... 阅读全文
posted @ 2017-12-12 19:42
全威儒
阅读(475)
评论(0)
推荐(0)
摘要:
在sqlplus中运行sql语句或者pl/sql的时候如果需要统计运行的时间,只需要开启set timing on选项即可。 SQL> set timing onSQL>SQL> select count(*)from cat; COUNT(*)---------- 408 Elapsed: 00:00:00.15如果在运行pl/sql的时候如果需要计算程序运行的时间。使用set ... 阅读全文
posted @ 2017-12-12 16:46
全威儒
阅读(1536)
评论(0)
推荐(0)
摘要:
F9 执行全部sql Ctrl_Enter 执行当前sql Ctrl+T 补全table_name Ctrl+. 补全table_name ALT+ 箭头上下 看sql history ... 阅读全文
posted @ 2017-12-12 11:29
全威儒
阅读(2108)
评论(0)
推荐(0)