Customizing Query

srinivas_puppala's Avatar, Join Date: May 2006
Newbie Member
hi,

Iam Srinivas working as a programmer.I want approach regarding customizing Query for any database.I will clearly explain...

Sometimes we don't which database the client is using,he may use SQLServer,MYSQL,MS Access,Oracle.So i want to customize my query for all these databases i.e The Query i have written should insert or retrieve data from any of these databases.

So what is the approach i should follow ,is there any query builder to generalise Queries.Plz give me answers quickly because i got very less time and i need to start my project as soon as i get the answer for this.

Regards
Sreenivasu Puppala
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Quote:
Originally Posted by srinivas_puppala
Iam Srinivas working as a programmer.
Welcome to g4ef
Quote:
Originally Posted by srinivas_puppala
Sometimes we don't which database the client is using,he may use SQLServer,MYSQL,MS Access,Oracle.So i want to customize my query for all these databases i.e The Query i have written should insert or retrieve data from any of these databases.
Its better if you clear out with the clients as to what database he will be using so that you can use the more customized property of the databases that they support. What I meant is for eg. if its Oracle you can take the help of ROWID where as for SQL server its not there but you can always use ANSI SQL queries to do your job or atleast start with it.
0
coderzone's Avatar, Join Date: Jul 2004
Team Leader
If you look at the article by shabbir about Delete duplicate rows from Oracle you will realize the power of each of them and why you should be using them as much as possible. Also if you can use PL/SQL or T-SQL of Oracle / SQL Server your application will be much more efficient and so concentrating on general queries is good to start off but not a good solution for optimal performances.