Oracle/Expert Profile

Average Ratings

• Knowledgeability 9.82
• Clarity of Response 9.70
• Timeliness 9.76
• Politeness 9.94

• Number of Questions (in Past 24 Hours) 0
• Max Questions to be Asked (in 24 Hour Period) 7
• Total Questions (since joining AllExperts) 321
• Volunteer Since 2006-11-06
• Prestige Points 990

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness

User	Date	K	C	T	P	Comments
sandeep	07/31/09	10	10	10	10	thats the solution thank u sir
sandeep	07/27/09	10	10	10	10	thanks sir i am sincerely thankful to .....
Ajay	01/07/09	8	8	10	9
swathibudama	12/31/08	10	10	10	10
shalabh	12/10/08	10	10	10	10	Thanks 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'