Suchitra Joshi - Oracle - Oracle - Computing/Technology

About > AllExperts
	Search for

Main Menu

Login (Experts Only)

About Us · FAQ · Tell Friends About Us · Link To Us · Free Encyclopedia · Disclaimer · Tech Support

You are here: AllExperts > Computing/Technology > Oracle > Oracle

Expert Profile: Suchitra Joshi

Expertise: I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader and some basic dba activities or performance tuning for Oracle 8i database. I cannot answer questions related to major dba activities, backup and recovery.

Experience in the area
10+ years
D2K

Awards and Honors
OCP - SQL and PL/SQL
Brainbench certifications in Oracle Administration, Database, PL/SQL

	View Past Answers	View Detailed Ratings

Average Ratings
Prestige Points: 2314
Knowledge	9.49 Excellent
Clarity of Response	9.54 Best of the best
Timeliness	9.62 Best of the best
Politeness	9.77 Best of the best
Number Of Questions (in Past 24 Hours)		0
Max Questions to be Asked (in 24 Hour period)		10
Total Questions (since joining AllExperts)		643

Recent Reviews from Users

Knowl	Clarity	Time	Politeness	Date
10	10	10	10	08/12/08
9	10	10	10	08/07/08
8	7	10	10	08/06/08
9	9	8	8	06/23/08
10	10	10	10	06/18/08

User Comments

thanks a lot
(vidhya on 08/12/08)

Many Thanks Suchitra.
(istiyaq on 08/07/08)

Many Thanks Suchitra.
(istiyaq on 08/06/08)

Thanks For your co-operation...
(pranab on 06/23/08)

Thank you very much Mam.
(Binay Bhusan Mishra on 06/18/08)

View All Comments

	View Past Answers	View Detailed Ratings

Recent Answers from Suchitra Joshi

2008-08-25 select statement: Hi Parth, You will have to use dynamic queries in this case. You first get the query depending on category - select case lower(category) when 'residential' then 'select...

2008-08-23 select statement: Hi Parth, Here is the query - select pid, category, address, case lower(category) when 'residential' then noofroom else null end noofroom, case lower(category)...

2008-08-11 Oracle 10g sql/pl-sql: Hi Mahesha, For any oracle exams you need more practice and experience. Same is the case for becoming Oracle expert. You can find all the documentation for 10g at this site - http://www.oracle.com/pls/db102/portal...

2008-08-09 Procedure: Hi Vidhya, Here is a simple procedure (Assuming you input the transaction id for which you want to find the fine) - create or replace procedure temp_p1(in_tran_id in number...

2008-08-06 oracle: Hi Istiyaq, I have never tried to create more than 50 columns/forign keys in a table. But the documentation shows - Max columns = 1000 Max foreign keys = Unlimited You may find more info at -...