Aklımdan Kaçanlar...

Developerlar için 12C ile gelen özelliklerin anlatıldı güzel bir makale http://allthingsoracle.com/oracle-database-12c-new-features-part-4/ Diğer makalelere de göz atmak da fayda var, okumanızı tavsiye ederim.

Configuring WebUtil at OS: 1.Download WebUtil http://www.oracle.com/technology/software/products/forms/files/webutil/webutil_106.zip 2. Download Java Com Library  http://prdownloads.sourceforge.net/jacob-project/jacob_18.zip 3. Extract both zips to some directory. 4. Copy   File  frmwebutil.jar   From folder: webutil_106\webutil_106\java  To: $ORACLE_HOME/forms/java   File:  jacob.jar    From folder: jacob_18  To: $ORACLE_HOME/forms/java   File:  d2kwut60.dll, JNIsharedstubs.dll   From folder: webutil_106\webutil_106\webutil To: $ORACLE_HOME/forms/webutil   File:  jacob.dll  From folder: jacob_18 To: $ORACLE_HOME/forms/webutil   File:  forms_base_ie.js, forms_ie.js - From folder: webutil_106\webutil_106\java To: $ORACLE_HOME/forms/java  File:  webutil.olb, webutil.pll and create_webutil_db.sql  From folder: webutil_106\webutil_106 To: $ORACLE_HOME/forms  ...

SQL Developer Dil Ayarları IncludeConfFile ../../ide/bin/ide.conf SetJavaHome ../../jdk AddVMOption  -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true AddVMOption -Dsun.java2d.ddoffscreen=false AddVMOption -Dwindows.shell.font.languages= AddVMOption  -XX:MaxPermSize=128M AddVMOption -Duser.language=en  AddVMOption -Duser.region=US AddVMOption -Doracle.jdbc.mapDateToTimestamp=false IncludeConfFile  sqldeveloper-nondebug.conf

DBMS_SQL paketinin kullanılması DECLARE Source_Cursor      INTEGER; Num_Rows_Processed Integer; BEGIN Source_Cursor := Dbms_Sql.Open_Cursor;      Dbms_Sql.Parse(Source_Cursor, 'select * from dba_source where object_name =  ', 1);      Num_Rows_Processed := Dbms_Sql.EXECUTE(Source_Cursor);      Dbms_Sql.Close_Cursor(Source_Cursor); end;

SELECT * FROM dba_scheduler_jobs where job_name=:job_name; SELECT * FROM dba_scheduler_job_log WHERE job_name=:job_name ; SELECT * FROM dba_scheduler_job_run_details where job_name=:job_name; SELECT 'SELECT * FROM '||object_name||';' FROM dba_objects where OBJECT_name like 'DBA_SCHEDULER%' and object_type='VIEW';

declare CURSOR c1 IS   SELECT p.index_owner,p.table_owner,p.table_name,p.index_name, wm_concat(p.column_name) kolonlar    FROM   DBA_IND_COLUMNS p    WHERE table_name =:TABLE_NAME    AND NOT EXISTS           (SELECT 1 FROM dba_ind_columns@diger_db r            WHERE p.index_name=r.index_name            AND p.index_owner=r.index_owner )    GROUP BY p.index_owner,p.table_owner,p.table_name,p.index_name; BEGIN FOR r1 IN c1 loop   dbms_output.put_line('CREATE INDEX '||r1.index_owner||'.'||r1.index_name||' ON '||r1.table_owner||'.'||r1.table_name||' ('||r1.kolonlar||');' ); end loop; end;

DBA SCHEDULER JOB OLUŞTURMA BEGIN     SYS.DBMS_SCHEDULER.CREATE_JOB (             job_name => 'isci',             job_type => 'PLSQL_BLOCK',             job_action => 'BEGIN islemi_yapacak_prosedur; END;',             job_class => 'DEFAULT_JOB_CLASS', repeat_interval => 'FREQ=DAILY; byhour=7',             enabled => true,             comments => 'Bu program gunluk olarak  calisacak'); END; /*******   Değiştirme  ******/ BEGIN DBMS_SCHEDULER.set_attribute (     NAME      => 'ISCI',     ATTRIBUTE => 'repeat_interval',     VALUE     => 'FREQ=DAILY; byhour=9'); END; BEGIN dbms_scheduler.DISABLE ('ISCI'); END; /*******  Çalıştırma ve Durdurma ******/ BEGI...