Installing jQuery to Application Express ( APEX )

Sometimes, you want to add different things your page such as different buttons, images, motions. JQuery API provides these wishes by using JavaScript and CSS.
For detail information, examples and to do download this api, visit http://jquery.com.
If you want to import and use this api in your Apex Application you will have to do [...]

Oracle Apex 3.1 Sunumu

18 Ekimde, OracleTURK grubuna, Oracle Akademi sponsorluğunda, Kadıköy Bireysel Eğitim Merkezinde gerçekleştirmiş olduğum, Oracle Application Express v3.1 sunumu ve workshop esnasında gösterdiğim bazı özelliklere ait kodlar için tıklayın.
For english:I present the Oracle Application Express v3.1 to OracleTurk Group, at Kadıköy Bireysel Eğitim Merkezi, sponsored by Oracle Turkiye Akademi. To access this presentation click here.

Asynchronous Ajax in Apex

We use Ajax for rapid query processing without submitting page. In apex, you can build ajax within your pages. For this purposes, we use “Application Process” under the Shared Components.
Sometimes, Application Process can not response rapidly. For example, if you query a count from very large table, it takes for minutes or hours. If you [...]

Running DDL Statements on Remote Database

You cannot run any DDL statement on a remote databases via using our custom remote sqls.
CREATE TABLE EMP@DB1 …
This causes an error. Instead of this you can use the Dynamic Sql to produce ddl statement to execute it when it is called.
For example, There are two DB. A_DB and B_DB. We write this function in [...]

About Returning Into Clause on Remote DB – ORA-22816

We use PL/SQL RETURNING INTO clause for returning value(s) after dml commands(INSERT,UPDATE,DELETE). Assume that you would insert row a employee table with employee_id value. Likely, you type this sql statement:
INSERT INTO TEMPLOYEES (EMP_ID,EMP_NAME) VALUES( SEQ_TEMPLOYEES.NEXTVAL,’FUAT SUNGUR’);
After this statement you need this employee_id to add another table. You can use RETURNING INTO clause to get employee_id [...]

Google Syntax Highlighter for PL/SQL

Google Syntax Highlighter App. provides us to show code in our blogs or other html pages. This application shows code of C,Java,Jscript,C#,SQL,XML,Ruby,Phyton. But as you predicted, Oracle PL/SQL is missing. So, i decided to develop a code to highlight our Oracle/PLSQL code. Things you have to do them are as follows :

Download the Google Syntaxlighter [...]

Creating your own authentication method in Apex

With this operation, you can do your own login page instead of default apex login page.
Firstly, you need to create a package that deal with user login operations. PKG_APP_SECURITY package name is appropriate for this need.
CREATE OR REPLACE PACKAGE BODY PKG_APP_SECURITYAS

PROCEDURE login

(p_uname IN VARCHAR2,p_password IN VARCHAR2,p_session_id IN VARCHAR2,p_flow_page IN VARCHAR2)ISBEGIN– THIS PROVIDES AUTHENTICATIONwwv_flow_custom_auth_std.login (p_uname => [...]

Installing Application Express 3.1 on Oracle 10g 10.2.0.1.0

In installing apex on Oracle 10g 10.2.0.1.0, i was getting a XDB Login Problem. I setup apex and entering the url path of apex, then browser ask me repeatedly xdb username and password. I tried lots of things that could not solve this problem. Especially this problem take place in Oracle 10g 10.2.0.1.0. I searched [...]

Materialized View

Oracle DW uygulamalarında sıkça rastlayabileceğimiz bir yapı olan Materialized Viewları, saklı tablo sonuçları olarak düşünebiliriz. Normal Viewlardan farkı, bir sql sorgusu olarak değil de sql sorgusu + data olarak saklanmasıdır. Yani MV diskte yer kaplar.
Peki neler yapılıyor MVlerle, milyonlarca kayıt bulunan tabloda belli sorguları önceden çalıştırıp bunun sonuçlarını saklama işlemini yapıyoruz.Örneğin, bir satış tablomuz var, [...]

Tablespace – Datafile Oluşturma

Oracle’da verilerimiz fiziksel olarak datafile’larda saklanır ve bu datafile’ları barındıran lojiksel olarak Tablespace adını verdiğimiz yapılar bulunur. Tablespace’ler, data fileların toplu olarak yönetimini kolaylaştırmıştır. Bir Tablespacei read only yaparak, onu içeren dosyaları da read only yapmış oluruz, hepsini teker teker yapacağımıza.
Şimdi bu tablespace oluşturma işlemini manuel olarak yapalım.İlk olarak konsoldan bir dosya oluşturalım.
root@fuat-laptop:/home/oracle/datafiles# touch fuat_3.dbfroot@fuat-laptop:/home/oracle/datafiles# [...]