Hi I am trying to convert an Oracle query to SQL. But i am totally confused thinking how to proceed. For some of the oracle packages , am not able to find an equivalent SQL function Here is my Oracle query cursor c_fields(c_xml XMLTYPE) is select DBMS_XMLGEN.convert(extract(value(x), '//field/@name').getstringval(),1) FLD_NAME, extract(value(x), '//field/@resultCol').getstringval() RESULT_COL, extract(value(x), '//field/fieldConfiguration/@isAttachmentAllowed').getnumberval() AllOW_ATTACHMENT, extract(value(x), '//field/@key').getnumberval() FLD_ID from TABLE(XMLSEQUENCE(EXTRACT(c_xml, '//table/field'))) x; I need to convert this to SQL query. In SQL we dont have parameterized cursor concepts. However to some extent we can achieve the functionality by using "WHERE" condition. But in this query, am not able to trace out how can i write the equivalent SQL functionality since "FROM" part itself is using the parameterized cursor. Please help. Thanks Arudya

Am totally stuck with an issue. I have developed a web application using Visual Studio .Net 2005. The problem is that i could see a straight line displayed in the application, However its not due to any code i guess. Since the issue exists only in Windows 7 OS with IE8. For the same OS, there is no such issue when tested in Mozilla Firefox . And the other scenario i noted here is that when i test the application( same code) with these configurations - Windows XP , Firefox/IE8, the issue is not reproduced. Am not able to trace out whether this issue is browser specific, or OS specific or whether the problem with Visual Studio.Net. Please help. Thanks, Arudya

Am totally stuck with an issue. I don't know whether this is even the right forum to post my doubt, since am not able to trace out the real source of my issue. So let me first ask my apologies if i have used the wrong forum and request the people coordinating the form to move the message to the appropriate forum.. I have developed a web application using Visual Studio .Net 2005. The problem is that i could see a straight line displayed in the application, However its not due to any code i guess. Since the issue exists only in Windows 7 OS with IE8. For the same OS, there is no such issue when tested in Mozilla Firefox . And the other scenario i noted here is that when i test the application with these configurations - Windows XP , Firefox/IE8, the issue is not reproduced. Am not able to trace out whether this issue is browser specific, or OS specific or whether the problem with Visual Studio.Net. Please help. Thanks, Arudya

Hi, I am pretty new to database section. I tried porting a table created in Oracle to SQL Server 2005. In Oracle, i could see a column defined holding the user details. The column is defines as given below. CREATE_USER VARCHAR2(255 BYTE) DEFAULT USER NOT NULL My doubt is regarding default value USER. I would like to know 1) What will be the value keyword "USER" will be returning in ORACLE. Is it an in built property or function which returns the default user? 2) And the equivalent value to be used for "USER" in SQL Server 2005? Please help Thanks, Arudya

modified on Wednesday, October 27, 2010 12:01 AM