You are here:
I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.
15+ years of Oracle PL/SQL Development
B.Sc (Electronics), Diploma in Computer Applications (DCA)
Oracle PL/SQL Developer Certified Associate (OCA)
Oracle Database: SQL Certified Expert
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000
| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| raz | 02/11/12 | 10 | 10 | 10 | Thanks |
| rana | 12/28/11 | 8 | 10 | 10 | |
| sujatha | 12/16/11 | 10 | 10 | 10 | Thank u for reply |
| santhosh | 12/10/11 | 10 | 10 | 10 | |
| Mohd Imran | 11/26/11 | 10 | 10 | 10 | Thank you Mam I agree with Answer! |
Hi Raz, There should be a semicolon after each SELECT statement. Your code is missing the semicolons for the following statements - -- 2nd Check - is the person a foster carer (FCARER)? Select
Hi Sharath, Here is a link which gives information on how to connect to database, depending on your OS and tools used - http://docs.oracle.com/cd/E11882_01/appdev.112/e10766/tdddg_connecting.htm
Hi Ramana, Stored Procedure supports deferred name resolution. Example while writing a stored procedure that uses table named tabl1 and tabl2 etc..but actually the tables does not exists in database
Hi Sucharitha, I am sorry I cannot help you with this. This task requires testing on similar data size, which is not available for me at present. You can check the common tuning techniques from these
Hi Sucharitha, Sorry for the delay in response. I have not tried any formatting in excel, but you can check this site and see if this will solve your problem - http://roelhartman.blogspot.com/2006/07/how-to-create-neatly-formatted-excel

©2012 About.com, a part of The New York Times Company. All rights reserved.