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';