Edi Yanto (何 萬 新)

Archive for April 2007

Suppress Duplicate Values in Oracle

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 [...]

Customized Titles in Oracle

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 [...]

Customized the Column Heading in Oracle

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   [...]

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 [...]

Tags:

Tuning the Oracle8i Database

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 [...]

Tuning Dynamic SQL with EXECUTE IMMEDIATE and Cursor Variables

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 [...]

Kisah 4 Lilin

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 [...]

Tags:

Concurrent Manager ( no manager )

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.

Jangan Jadi Gelas

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 [...]

Tags:

RSS Syndication


Edi Yanto
Oracle Applications Technical Consultant
View Edi Yanto's profile on LinkedIn

My Certifications




Enter your email address to follow this blog and receive notifications of new posts by email.

Join 992 other followers

Archives

 

April 2007
M T W T F S S
« Mar   May »
 1
2345678
9101112131415
16171819202122
23242526272829
30  

Top Rated

RSS Unknown Feed

  • An error has occurred; the feed is probably down. Try again later.

Visitors

Categories

Blog Stats

  • 54,082 hits

Users Online

web counter

Pages

Follow

Get every new post delivered to your Inbox.

Join 992 other followers