Archive for the ‘Programming Concepts’ Category
UNIX Commands
Posted by: Edi Yanto on: March 7, 2009
Table of the main UNIX commands Unix Commands Description Options ls lists the content of a directory -a Displays all files, including hidden files -I Displays a detailed listing -R Displays the files recursively (i.e. in the sub-directories) -d Displays only the directories and not their content -S Sort by size -t Sort by the [...]
Row Numbering With an Order By Clause
Posted by: Edi Yanto on: March 7, 2009
One of the most often uses of the pseudo column rownum is to provide sequence numbers to the records in a query. This feature is widely used in reports to represent systematic display of information. SELECT ROWNUM, rcta.trx_number, rcta.trx_date FROM ra_customer_trx_all rcta; ROWNUM TRX_NUMBER TRX_DATE 1 40881-05 12/14/2005 2 38384-05 11/24/2005 3 42740-05 12/28/2005 4 [...]
Various Backup and Restore Scripts
Posted by: Edi Yanto on: March 6, 2009
(1) mt # mt -f /dev/rmt/0n status (to check status of backup device) # mt -f /dev/rmt/0n eom (to move to the end of tape) # mt -f /dev/rmt/0 rewind (to rewind) # mt -f /dev/rmt/0n fsf [count] (to jump [count] files) # mt -f /dev/rmt/0n bsf [count] (to forward [count] files) # mt -f [...]
Differences Between Interpreted and Compiled Languages
Posted by: Edi Yanto on: December 18, 2007
High-level languages can be divided into two groups: interpreted and compiled. Interpreted languages are translated into machine language with the help of another program called an interpreter. The interpreter translates each statement in the program into machine language and executes it immediately before the next statement is examined.
RSS Syndication
Edi Yanto
Oracle Applications Technical Consultant
My Certifications
- The XML Publisher Concurrent Request Fails Due to the Output Post Processing (OPP)
- BLOB Images in XML Publisher
- Tuning Dynamic SQL with EXECUTE IMMEDIATE and Cursor Variables
- Moving Concurrent Programs, Data Definitions and Templates Between eBusiness Suite Instances
- Receiving and Return Transaction with Receiving Open Interface (ROI)
- Transact Move Order and Ship Confirm Using API
- Spell Number (Function Terbilang)
- Making Custom Reports Oracle Apps Compliant
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- ORA-01591: lock held by in-doubt distributed transaction
- Edi Yanto: Hi Mandi, Have you tried the steps on my blog? Please send me your RTF, XML and RDF files to my gmail (edi.y4nto@gmail.com), I'll take a look when I'
- Mandi: Hi Edi, I am trying to incorporate signature and logo for check printing template in R12. I have converted the blob to clob using getbase64 function
- Edi Yanto: Hi Siva, Images on excel output are not scale itself, so you must change the image size according to what you want. More info about excel limitation
Unknown Feed
- An error has occurred; the feed is probably down. Try again later.
Online Apps DBA
- Weekend Online Oracle R12 Apps DBA Training commencing from 03rd June 2012
- Weekend Online Oracle Weblogic Administrator 11g Training commencing from 02 June 2012
- Confused about Oracle IAM software version & release number ?
- ASM block corruption ORA-01115
- Oracle Adaptive Access Manager (OAAM) for beginners
Visitors
Users Online
Recent Comments