Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 29-12-2010
Member
 
Join Date: Dec 2010
Posts: 59
Query in SQL v/s Query in Oracle

I am learning to execute query on SQL on my SQL server, right now I am using the SQL , I do not know whether but there are a lot of people who are using some other syntax, whenever we execute some queries occasionally we face some sort of dissimilarity in the query being produced in the end, so why does it happen , how are the queries in the SQL different from the SQL query , can anyone please explain to this question. I am waiting for your response.
Reply With Quote
  #2  
Old 29-12-2010
Member
 
Join Date: Apr 2009
Posts: 567
Re: Query in SQL v/s Query in Oracle

I will ask you a few question on this topic Have you ever written any code that comprises of any sort of query while you use one database only to have it break when you toggled to some other database ? How frequently have you made your mind to restrict the functionality of your database by typing only essential SQL since you just were not certain whether your queries would function on a different database ? I think you should get back with answers to these questions
Reply With Quote
  #3  
Old 29-12-2010
Member
 
Join Date: May 2009
Posts: 503
Re: Query in SQL v/s Query in Oracle

Do not worry I will give answer to those questions . I think you have typed ColdFusion code to control query results without acknowledging that the database can do the same operation quicker and more professionally. In all-uses , the database tends to be badly utilized in the majority of applications. Oracle9i and SQL Server 2000 ? the difference is always the key to help. It is always important for the CF developer that will help them to write more transferable and database-smart applications.
Reply With Quote
  #4  
Old 29-12-2010
Member
 
Join Date: May 2009
Posts: 523
Re: Query in SQL v/s Query in Oracle

One of the main differences between Oracle and SQL Server is in the action of chronological primary keys. To get an automatically generated chronological primary key for a table in SQL Server, you will have to make the column of the table as an IDENTITY column. On the other side Oracle, on the other hand, needs that you first make a sequence and then you will have to insert the values .
Reply With Quote
  #5  
Old 29-12-2010
Member
 
Join Date: May 2009
Posts: 533
Re: Query in SQL v/s Query in Oracle

Although , these benefits of the SQL Server approach to chronological primary keys come with a cost - you will not be able to insert a value into an IDENTITY column. Thus, if you attempt to bulk import rows from a remote table into an insider one using an IDENTITY column, you will have to leave out the original column matching to the IDENTITY column. This results in discrepancies especially frustrating to handle correctly.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Query in SQL v/s Query in Oracle"
Thread Thread Starter Forum Replies Last Post
Query for columns in oracle database Gerri Windows Software 4 10-02-2010 08:27 PM
Want to make query dependent on another query. MACE Software Development 4 01-02-2010 05:22 PM
How to deal with oracle character query in Wildcard Shanbaag Software Development 3 11-08-2009 10:23 AM
MySQL query in a query Rail racer Software Development 3 21-07-2009 07:06 PM
Turn on MySQL query cache to speed up query performance DMA2Superman Software Development 3 07-07-2009 10:26 AM


All times are GMT +5.5. The time now is 03:32 PM.