Viewing 15 posts - 301 through 315 (of 440 total)
Hi
There are no big difference between 9.2 and 9i.
i am not sure what kind of back-ground you have but to start with you need to first understand SQL..PL/SQL...and the go...
January 8, 2009 at 9:42 am
Hi,
When you migrate your PL/SQL code from Oracle to SQL Server, it would be good re-design the objects. coz There are features suipported in Oracle are not available in SQL...
January 8, 2009 at 9:26 am
Hi,
When you migrate your PL/SQL code from Oracle to SQL Server, it would be good re-design the objects. coz There are features suipported in Oracle are not available in SQL...
January 8, 2009 at 9:25 am
Hi
If you have some data in the column and want to change the data type, then it will NOT work. To change the data type of the column you shouldn't...
January 8, 2009 at 9:13 am
Hi
Index willl surely improve the query performance.
Is this column is unique?
End users always going to use RegistrationNo to query this table?
What is the volume of the data?...
October 8, 2008 at 12:55 pm
Hi
Check out the below link
Thanks -- Vj
-- For Microsoft related queries
-- For Oracle related queries
October 5, 2008 at 7:19 am
Hi The way only i can think of using UNION or UNION ALL.
You can't have one query to place IF..ELSE conditions in Joining conditions.
Thanks -- Vj
-- For Microsoft related queries
October 5, 2008 at 7:14 am
Hi
Your requirement is not clear, but based on my initial understanding is If you have join condition to join all these tables then you need to write one SELECT query.
If...
October 5, 2008 at 7:07 am
Sure you can there is no restrictions on the database operations.
Please let us know if you are facing any issues....
Thanks -- Vj
October 4, 2008 at 11:26 am
October 4, 2008 at 11:21 am
HI,
What is the importance of colum Order in writinig selec queries in your application!! If you are looking for "C" column in between "B" & "D" then have this placing...
September 8, 2008 at 9:57 am
Hi,
All these queries are tied to the Customer ID, If i know these values in advance then i can use PIVOT or CASE to convert the rows into columns, but...
August 5, 2008 at 11:06 am
Hi,
Instead of deploying your tables, why canot you share the database?
Other option is export the table structures in .sql file and run this file.
Thanks -- Vj
July 22, 2008 at 9:03 am
HI Peso
any specific reason for having ORDER BY cluase in the query?
Thanks -- Vj
July 15, 2008 at 1:57 pm
Hi,
Basically you need to use Split functiont to break the string.
http://www.dotnetspider.com/resources/1266-Split-e-String-Using-char-separator.aspx
Thanks -- Vj
July 15, 2008 at 1:54 pm
Viewing 15 posts - 301 through 315 (of 440 total)