El-Ahly Win Again In World Cup

Vote For Abu Trika

Dear All Please Vote To Select Mohamed Abu Trika As The Best Player In Africa For 2006ز

Just Enter a valid email and enter Mohamed Abu Trika-Al Ahly Egypt

http://news.bbc.co.uk/sport2/hi/football/africa/6106170.stm

& Thanks For LobLob Who Voted For Abu Trika

Thanks For All

How To Convert Numbers Into Characters

To Convert Numbers into Text use the following Select Statment
select to_char(to_date(1500,'j'),'jsp') from dual
it will give you the following Result
one thousand five hundred
but you have to take in your consideration that it will not accept
more than 5,373,484
and it will cause an error

How To Retrieve All Blocks & Items From Any Form

PROCEDURE Get_Canvas_Names IS
lc$blockDeb varchar2(60); -- start block
lc$block varchar2(60); -- current block name
lc$item varchar2(60); -- current item
lc$Type varchar2(20); -- item type
lc$itemdeb varchar2(60); -- first item
lc$canvas varchar2(60); -- current canvas name
lc$tabcan varchar2(60); -- current tab canvas name
lc$Acanvas varchar2(60):= ' '; -- old canvas name
lc$Atabcan varchar2(60):= ' '; -- old tab canvas name
ln$NbRec pls_integer:=0;-- number of records(for know if the block is multi-records)

BEGIN

LC$BlockDeb := get_form_property( NAME_IN('System.Current_Form'), FIRST_BLOCK ) ;
LC$Block := LC$BlockDeb ;

Loop -- For each block of the form

LN$NbRec := get_block_property(LC$BLOCK, RECORDS_DISPLAYED) ;
lc$itemdeb := get_block_property(LC$BLOCK, FIRST_ITEM) ;

lc$item := LC$BLOCK '.' lc$itemdeb ;

while lc$itemdeb is not null loop -- For each item

-- visible item ? --
IF GET_ITEM_PROPERTY(LC$Item , VISIBLE) = 'TRUE' Then

-- Get the canvas and tab canvas name --
lc$canvas := GET_ITEM_PROPERTY(LC$Item , ITEM_CANVAS ) ;
lc$tabcan := GET_ITEM_PROPERTY(LC$Item , ITEM_TAB_PAGE ) ;


End if ; -- GET_ITEM_PROPERTY(LC$Item , VISIBLE) = 'TRUE'

lc$itemdeb := get_item_property(lc$item, NEXT_NAVIGATION_ITEM );
lc$item := LC$BLOCK '.' lc$itemdeb ;

end loop ;


LC$Block := get_block_property( LC$Block, NEXTBLOCK ) ; -- next block

exit when LC$Block is null ;

End loop ;

END Get_Canvas_Names;
Note This method only works when you load the form into the memory.
i.e it means you have to call the form

Personal Data

Address: Mussafah – Abu Dhabi
Tel: (971)-50-3186928
E-mail: ashrafashour411@yahoo.com
ashraffarouk@hotmail.com
Nationality: Palestinian
Date of Birth: 04/11/1979

Programming Languages And Development Tools

- SQL, SQL*Plus & PL/SQL (Expert)
- Developer 6i - Forms & Reports (Expert)
- Developer 2000 - Forms & Reports (Expert)
- Developer 9i & 10g Forms & Reports (Expert)
- Oracle Designer 10g (Good)
- JDeveloper 10g (Beginner)
- Java & Java Core (Beginner)
- PL/SQL Developer 7.0.2(Expert)
Past Knowledge of:
- Visual Basic 6.0
- Visual C++ 5.0
- ASP (Active Server Page)
- C & C++
- Object Oriented Concepts.

Education

B.Sc. In Computer Science from 1996 to 2001 (5 Years), Modern Academy for Computer Science and Management Technology in Maadi, Cairo, Egypt.
Note: I was the fourth on my department in the computer science Department with Accumulative GPA %88.5 and with %92.5 for the fifth year.

Professional I.T. Certifications

· OCP: Internet application developer using Forms 6i

· MCDBA: Microsoft Certified Database Administrator on SQL Server 2000.

And Currently Inshaa ALLAH Preparing to take OCP DBA 10g.

My Experience

Working Experience

Nov 2006 – Till Date: Experts Computer Consulting (Abu Dhabi, U.A.E):
- Computer Programmer (Information Technology Unit):
· Analysis, Design, Build, Document, Transition, Developing & Finally Testing Application for the Department Of Economy (Abu Dhabi).
· Design & Development of Applications (including Table structures) to be used by different departments using development tools such as Oracle Developer 10g.
· Analysis, design, development, testing and implementation of an application for Economy Department which covers Registration, Issuing, Tracing, Following up & Finally approving or Rejecting The Trade Licenses for Abu Dhabi.
· Give training for users on how to use the developed systems.

May 2004 – Oct 2006: Bin Hafeez Establishment (www.binhafeez.ae) - (ISO 9001, 2000 Certified, ISO 14001, 2004 Certified) (Abu Dhabi, U.A.E):
- Computer Programmer (Information Technology Unit):
· Analysis, Design, Build, Document, Transition, Developing & Finally Testing For In-House Development Applications.
· In-House Design & Development of Applications (including Table structures) to be used by different departments using development tools such as Oracle Developer 6i & Oracle Developer 10g (Details will be provided upon request).
· Analysis, design, development, testing and implementation of an application for Maintenance Department which covers corrective and preventive maintenance, machines usage details for servicing purpose and lubricants services module in addition to the integration with the email system
· Analysis, design, development, testing and implementation of an application for Production Department that covers ordering, caging, batching, production and delivery processes
· Development and testing of an Oracle web based application for Payroll & HR which includes candidates, employees, personnel & payroll modules in a multi company environment according to U.A.E Labor Law using Oracle Developer 10g.
· Develop & Testing Application for Purchasing Department includes Material Requisitions, Approval, Issuing Purchase Orders and more.
· Development and testing of estimation & cost control system.
· Development and implementation of HelpDesk System to allow users to send computer related complains and requests through e-mail
· Effectively Migrate Developed applications from 6i to Web Application 10g.
· Give training for users on how to use the in house developed systems.
· Constant maintenance to bespoke applications developed by third party companies to suite our needs, As well as writing Reports for those applications. These applications were written in Developer/2000.
· Research on various ways to improve I.T. in a way to boost the performance of the company.
· Providing Support to the Company (Software & Hardware).
· Basic administrative tasks on the Windows 2000 Server.
· Software and Hardware installation, upgrading, and troubleshooting.

Sep 2001 - Jan 2004: Egypt Network ISP (Internet Service Provider) (Cairo, Egypt):
- System Administrator & Technical Support
· Providing Support to the Company (Software & Hardware).
· Providing Support to the Company’s Network.
· Providing Support to Dial-Up Users (Clients).
· Providing Support for Connecting to the Internet through Satellite to Home Users & Companies (Installation, Troubleshooting & Support).
· Provide Technical Support for ADSL Connection to Home Users & Companies (Installation, Troubleshooting, Support & Networks Support).Modify the Websites by updating the links and resizing the web graphics & images.

Al-Ahly Win Again

My Favorite Team

Al-Ahly Club Won The African champions League On 11-11-2006

Welcome Page

Dear All,


I have decided to post my little knowledge about oracle (Sql, Pl/Sql, Forms & Reports)

Version 2.1, 6i, 9i & 10g.

And Inshaa ALLAH I will do my best to post as much as I can.


Best Regards,

Ashraf Farouk