• concatenating rows of a column in oracle 9i sql

    how can i concatenate several rows of a column which is of datatype varchar taking group by of two other columns in oracle 9i sql??

    Chrishram15 pointsBadges:
  • A Socket Connection was Attempted to an Unreachable Host

    Hi, i am getting this Ureachable Exception when connecting From Pocket PC Application To Desktop Application through Scoket. But The same is Working with Wondows Form Application.Not Working with PockePC Application. I can't Understand this. Please tell me How to solve This Problem

    5149365 pointsBadges:
  • ESX luns allocated on Symmetrix will not format.

    Recently we allocated Symmetrix space for an ESX cluster. Some of the LUNs format fine but one or two come up with an error message that says "unable to read partition information from this disk." All of the luns were exactly the same capacity. The ESX is currently attached to a Symmetrix array as...

    Emcsanman20 pointsBadges:
  • VB.NET app cannot login to SQL Server 2005 after upgrade from SQL Server 2000

    I have a VB.Net application which connects to an SQL2000 database and I recently upgraded to SQL2005 and after the upgrade my app does not want to connect to SQL2005 using the same password I used to connect to SQL2000. if I change the login password to all uppercase characters in SQL2005...

    Sanisto45 pointsBadges:
  • Writing Programmes

    Hi I am currently learning AS400 and trying to write a programme. I want to list users under a subsystem, but there are four different sets of users, and we normally use a set of menu's to get these list's, I want to look at the command behind the menu option so that I can add it to my programme....

    JackieCrossan0 pointsBadges:
  • How to get started in a SQL Environment

    I have been in an AS/400 world up until now. We are moving to SQL for a JDE EnterpriseOne implementation. What would be the best way for me to get up to speed on a SQL Server Database? Thank you for any and all insight.

    Kacerc65 pointsBadges:
  • Running .NET Code to manipulate sql tables

    is it possible to retrieve a table using .NET code manipulate in code e.g calculating formulas based on values stored in table retrieved and then pivoting it in code and putting it back into another table

    Ankur7715 pointsBadges:
  • File referencing in vba

    Hi All. I have a user form in Word that populates a doc, saves as a temp file, emails as attachment and then kills the temp file. I am worried that with momre than one user at any one time one person's code might kill another person's temp file before they have sent it. Any ideas as to how I might...

    BugBear5 pointsBadges:
  • AT Command for receiving an SMS from GSM modem using C#.NET

    Hello.... I've a problem for receiving sms from GSM modem.Sometimes sms can be retrieved without any problem(if executing code step by step using f11 key)otherwise I don't get all message.

    999559534735 pointsBadges:
  • About test of scenario

    Hi, i'm searching about a framework that help me to test the "scenarios of tests" for the web application in java.

    Haidy5 pointsBadges:
  • (AS/400 – RPG(ILE)) Date-Conversion

    Date-Conversion --------------------- I have a date in 7-digit format in '1YYMMDD' format. e.g 1071231 for representing 31st of December 2007.(where '107' represents 2007; 12 represents December & 31 represents 31st Day of the month). Now i need to convert this into '31/12/2007' (European format)....

    svankipu625 pointsBadges:
  • ORA-03113: end-of-file on communication channel

    I am running a database health report which consists of many SQLs against the data dictionary. Every SQL returns fine except one querying for chained/ migrated rows which takes a little more time, and I get the following: ERROR at line 1: ORA-03113: end-of-file on communication channel I am running...

    OracleATE190 pointsBadges:
  • Microsoft Excel – I need to find rows that match a user entered entries and sum results of column b

    I have a spread sheet that looks like this Project Well Hours Lewis 1 12 Lewis 2 3 Lewis 1 9 I want to find all the rows that match a user inputed name (in this case 'Lewis'), then add the numbers in column c labeled 'hours', if the sum equals 24 then no problem, but if the sum does not equal 24...

    Ksaep0420 pointsBadges:
  • SQL Developer Views and Programs

    I created a view to simplify the cursor within the package body. The SQL statement being used works as expected in SQL Developer but the program returns zero records. The program worked correctly before replacing one of the tables with this view. Not sure why all of a sudden the sql statement isn't...

    Petpat12370 pointsBadges:
  • Conditional Formatting – Excel 2003

    Hello, I would like to know how to setup a conditional format for the following example. Ex. Column 1: Company Column 2: Begin Date Column 3: End Date Column 4: Exceed Date if >3 (Calculates Column 2 & 3 in Days) Conditional Format for Column 4: if days exceeded 3 and "eguals the company in...

    Lhunter5 pointsBadges:
  • To retrieve records from SQL Server database

    Hello All, I have a requirement with sql server. Please find below the same. In database say we have a column named "Name" in a table. The records that are available in the table are say like Column_Name = Names Lean Metric Sequence Lean Operation Metric Lean Cleaning and so on.... Now, through...

    Pichha5 pointsBadges:
  • Sql Query

    hi all ..please help me ....what's wrong in this query ..i'm using it in java :String sql="insert into Etudiant(Nbetudiant, Pass, Nom , Prenom , Adress , Tel , Email , Sexe , Fax , Diplome , Date) values('"+ Nbetudiant + "','"+ pass +"','"+ Prenom +"','"+ Adress +"','"+ Telephone +"','"+ E_mail...

    UL15 pointsBadges:
  • ASP.NET and Multiple Access Databases Open

    Dear Colleagues Please could you help me? Is it possible to have an ASP .Net Web application with multiple (7) large MS Access 2000 databases open simultaneously. When I heard this I was surprised because there could be dozens of users each using up to 7 large and disparate Access databases...

    Hessm0035 pointsBadges:
  • TextBox problem in Visual Basic .NET 2008

    My listbox1 and the textbox1 (multilines properties) When double_click the listbox1, textbox1 = data from list box Being that the user has to do the event(double_click)several times how do i code the textbox1 to have all the the results of the events? If the user for example double_click 3,4,5 or 6...

    Ajibola110 pointsBadges:
  • What are the containers available in VB 6.0

    containers available in vb 6.0

    Engimca5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following