Oracle/Expert Profile


Ask A Question

Expertise

I can answer questions about Sql (including Sql tuning), pl/Sql and a bit of oracle administration

Experience in the area

I work as a consultant in Brazil and I face problems of all kind in oracle every day development.

Education/Credentials

INFNET

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness
UserDateKCTPComments
sandeep07/31/0910101010thats the solution thank u sir
sandeep07/27/0910101010thanks sir i am sincerely thankful to .....
Ajay01/07/0910 
swathibudama12/31/0810101010 
shalabh12/10/0810101010Thanks a ton. It worked.

Recent Answers from Edson

2009-10-22 Csv data into oracle:

SQL Loader SQL*Loader (sqlldr ) is the utility to use for high performance data loads. The data can be loaded from any text file and inserted into the database. During processing, SQL*Loader writes

2009-09-26 sql query:

---Examples of FlashBack create table test_flashback (ab number(2)); insert into test_flashback select substr(dman_cd_dim_ano,1,2) from dm_ano; delete from test_flashback; commit; insert

2009-08-31 Execuitng queries stored in a table in a procedure:

Hi there. A good and common approach is to create a table with a blob column. When you perform the loop, call the values of the blob with a execute immediate. for rec in (...) loop execute

2009-08-28 Call a stored procedure from a function:

Hi bandana. I could not understand your question well. What you want is to know the name of the procedure? If so, make a select from all_dependencies, and see the dependencies of the function.

2009-08-16 Oracle:

Hi there Some examples: select * from dual a where sysdate between to_date('16/07/2009','dd/mm/yyyy') and to_date('16/08/2009','dd/mm/yyyy') select * from dual a where sysdate between to_date(replace('16-07-2009'

 

Ask A Question

All Answers

Answers by Expert:


Ask Experts

Volunteer


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