You are here:
- Home
- Computing/Technology
- Oracle
- Oracle
- Alwyn D'Souza
Oracle/Expert Profile
Expertise
I can answer question related to writing SQL Queries, PLSQL Programming (which includes Procedures,Packages,Functions,Collections,Types,Triggers,Objects), Oracle Utilities ( SQL Loader), Pro*C.
Experience in the area
I have got total of more than 5.5+ years of experience in Application Design , Application Development using PLSQL Pro*C & Product Implementation. Worked with Oracle India into Support Division providing product support for PLSQL,Pro*C, OCI, XDK. Was an expert in PLSQL and have delivered internal training session , delivered a presentation on 11gR2 new feature (EBR) at OTN DBA Day and was also the part of Beta Testing Team for 11gR2 PLSQL. When with Oracle i was the moderator for metalink PLSQL Forum.
Organizations
Presently Infosys Pvt Ltd. Previously worked for Oracle India Pvt Ltd
Education/Credentials
Bachelor of Engineering (Electronics & Communication) Oracle Advanced 11G PL/SQL Developer Certified Professional Oracle Database 11g : SQL Certified Expert Oracle Database 11G Administrator Certified Associate
Awards and Honors
- Rewarded and Recognised as "Oracle JourneyMan" in Oracle Communities in 2009 - Rewarded and Recognised as "Oracle Pro" in Oracle Communities in 2010
Average Ratings
Recent Reviews from Users
K = Knowledgeability C = Clarity of Response P = Politeness| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| Pasam | 04/30/12 | 9 | 9 | 9 | Thanks for the quick response. |
| rajan | 04/21/12 | 9 | 9 | 9 | thanks sir . . . |
| keerthi | 04/06/12 | 10 | 10 | 10 | |
| MAZ | 02/15/12 | 10 | 10 | 10 | Thanks |
| Arunprasath | 12/05/11 | 8 | 7 | 7 | Good |
Recent Answers from Alwyn D'Souza
2012-05-22 PL SQL:
The data in temporary tables will be available till session expires (ON COMMIT PRESERVE ROWS) or commit is issued (ON COMMIT DELETE ROWS). The data in a global temporary table is private, such that
2012-04-13 problem: maximum open cursors exceeded:
How oracle manages "SYS_REFCURSOR" ? How SYS_REFCURSOR gets closed ? SYS_REFCURSOR is used to open weak dynamic cursor. You need to manually close all the cursors after usage. Else if number of
2012-04-05 oracle - need to convert multiple mutiple rows into single row:
CLOB is basically used to store large data upto 4 GB. Why would you like to convert it to a single column ? Try to find the total size of all the coulumn's before trying to append them. select
2011-11-26 Beginner Help:
Its always good to have plsql or sql knowledge because most of the applications will always need to interact with the databases. Pro*C is part of Oracle languages which uses embedded SQL statements.
2011-09-26 Variable:
Since it is a local variable, the scope of the variable will be inside the anonymous block and you wont be able to fetch it from outside the anonymous block. Declare a public variable inside a package
©2012 About.com, a part of The New York Times Company. All rights reserved.