{"id":30,"date":"2010-12-02T20:50:43","date_gmt":"2010-12-02T20:50:43","guid":{"rendered":"http:\/\/ebs.ict-oke.com\/?page_id=30"},"modified":"2015-09-23T11:24:25","modified_gmt":"2015-09-23T09:24:25","slug":"scripts","status":"publish","type":"page","link":"https:\/\/ict-oke.com\/?page_id=30","title":{"rendered":"Oracle Scripts"},"content":{"rendered":"

 <\/p>\n

\"scripts\"<\/a><\/p>\n

 <\/p>\n\n\n\n
\n

SQL> SELECT distinct url, email
\nFROM hr.all_companies
\nWHERE expertise = ‘Oracle’
\nAND job in (‘APPS_DBA’, ‘DBA’, ‘CONSULTANT’)
\nAND knowledge = ‘Excellent’
\nAND experience = ‘Excellent’
\nAND commitment = (select MAX(commitment) from hr.all_companies);<\/span><\/span><\/span><\/p>\n

URL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 EMAIL<\/span>
\n——————-\u00a0\u00a0 ————————–<\/span>
\nict-oke.com\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 info@ict-oke.com<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The scripts may be downloaded and used for free.<\/span><\/span><\/span><\/p>\n

\n
\n
Warning:<\/span><\/span><\/span>Some of these scripts may be dangerous and can potentially damage or destroy your database or system. <\/span><\/span>Make sure you understand, customize and test all scripts to suite your needs and environment before using them!<\/span><\/span><\/span><\/div>\n<\/div>\n<\/div>\n

APPS DBA Scripts:<\/span><\/span><\/span><\/span><\/p>\n

NOTE – At this moment this page is being updated.
\nPlease come back at a later time for the scripts. <\/span><\/p>\n

\n

 <\/p>\n

\u00a0<\/strong><\/span><\/p>\n

SQL> SELECT distinct url, email
\nFROM hr.all_companies
\nWHERE expertise = ‘Oracle’
\nAND job in (‘APPS_DBA’, ‘DBA’, ‘CONSULTANT’)
\nAND knowledge = ‘Excellent’
\nAND experience = ‘Excellent’
\nAND commitment = (select MAX(commitment) from hr.all_companies);<\/span><\/span><\/span><\/p>\n

URL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 EMAIL
\n——————-\u00a0\u00a0 ————————–
\nict-oke.com\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 info@ict-oke.com<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    SQL> SELECT distinct url, email FROM hr.all_companies WHERE expertise = ‘Oracle’ AND job in (‘APPS_DBA’, ‘DBA’, ‘CONSULTANT’) AND knowledge = ‘Excellent’ AND experience = ‘Excellent’ AND commitment = (select MAX(commitment) from hr.all_companies); URL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 EMAIL ——————-\u00a0\u00a0 ————————– ict-oke.com\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 info@ict-oke.com The scripts may be downloaded and used for free. Warning:Some of these scripts may be […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":118,"menu_order":7,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/pages\/30"}],"collection":[{"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ict-oke.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=30"}],"version-history":[{"count":10,"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/pages\/30\/revisions"}],"predecessor-version":[{"id":296,"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/pages\/30\/revisions\/296"}],"up":[{"embeddable":true,"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/pages\/118"}],"wp:attachment":[{"href":"https:\/\/ict-oke.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=30"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}