Posted by: Edi Yanto on: April 18, 2007
In the below example, we can suppress duplicate values in the MGR column, display a blank line between manager number groups, and suppress the display of repeated values in the DEPTNO column using the BREAK command. SQL> BREAK ON mgr SKIP 1 ON deptno when the query executes, the report output is organized based on [...]
Posted by: Edi Yanto on: April 18, 2007
We can create a header and a footer to display customized titles at the top and bottom of each page in the report output using the TTITLE and BTITLE commands. Query for display the employees who work in SALES department and hire date year is 1981. After type the command to display the title 1981 [...]
Posted by: Edi Yanto on: April 17, 2007
In Oracle, we can customize the column heading and formatted it’s value. Controls display of a column: COL[UMN] [ { column|alias } [option] ] CLE[AR] : Clears any column formats HEA[DING] text : Sets the column heading FOR[MAT] format : Changes the display of the column using a format model NOPRINT | PRINT NULL [...]
Posted by: Edi Yanto on: April 17, 2007
Ada teman mengirimkan tulisan di bawah ini, sepertinya bagus untuk kita semua. Selamat menyimak! Semoga bisa bermanfaat… Bukan berat Beban yang membuat kita Stress, tetapi lamanya kita memikul beban tersebut.(By Stephen Covey) Pada saat memberikan kuliah tentang Manajemen Stress, Stephen Covey mengangkat segelas air dan bertanya kepada para siswanya: “Seberapa berat menurut anda kira [...]
Posted by: Edi Yanto on: April 16, 2007
The below step are for optimizing performace of Oracle8i Database : Tune architecture and design of the data model. Tune Applications. It’s important to design efficient SQL statements. Efficient SQL Statement take less time to process. You must also consider the data access and manipulation operations in detail. Tune memory structures, memory tuning involves tuning [...]
Posted by: Edi Yanto on: April 14, 2007
Some programs must build and process a variety of SQL statements, where the exact text of the statement is unknown until run time. Such statements probably change from execution to execution. They are called dynamic SQL statements. Formerly, to execute dynamic SQL statements, you had to use the supplied package DBMS_SQL. Now, within PL/SQL, you [...]
Posted by: Edi Yanto on: April 14, 2007
Kisah empat lilin, yang satu per satu mulai meleleh dan padam. Lilin pertama berkata, ”Aku adalah damai, namun manusia tidak mampu menjaganya. Jadi, lebih baik aku matikan diriku.” Pet! Lilin kedua mulai berkata, ”Aku adalah iman. Sayang, aku tidak berguna lagi. Manusia tidak mau mengenalku. Tidak ada gunanya kalau aku tetap menyala.” Tiupan angin pun [...]
Posted by: Edi Yanto on: April 4, 2007
This condition can be fixed with restart the concurrent manager in Oracle 11i E-Business Suite. Step: 1. Login to the Oracle Apps with the System Administrator Responsibility. 2. Go to Concurent -> Manager -> Administer. 3. Find the Standard Manager in the field name. 4. Click the Restart button to restart the concurrent manager.
Posted by: Edi Yanto on: April 4, 2007
Seorang guru sufi mendatangi seorang muridnya ketika wajahnya belakangan ini selalu tampak murung. “Kenapa kau selalu murung, nak? Bukankah banyak hal yang indah di dunia ini? Ke mana perginya wajah bersyukurmu?” sang Guru bertanya. “Guru, belakangan ini hidup saya penuh masalah. Sulit bagi saya untuk tersenyum. Masalah datang seperti tak ada habis-habisnya,” jawab sang murid [...]
Recent Comments