• Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • ACCESS ERROR CHARACTERS FOUND AT THE END OF SQL STATEMENT

    I tried example 6 from the book SQL for Microsoft Access and got the error message" CHARACTERS FOUND AT THE END OF SQL STATEMENT. I tried deleing the first semicolon and got a message: missing semicolon at end of SQL statement. Can anyone tell me what I am doing wrong? Thanks, INSERT INTO Toys...

    Fredking5 pointsBadges:
  • SQL indexes

    hello, there are many indexes clustered an non clustered .so how can i see the result of each index, clustered and non clustered seperately through (T-SQL) pls guide me. RINO

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • Count Distribution

    From an input table consisting of YEAR and COUNT, e.g. YEAR COUNT 1999 3 2000 4 2000 7 2000 15 Can a Pivot Table or SQL Query be constructed to output a Yearly Count Distribution? e.g. YEAR 1->9 10->19 20->29 1999   1 2000   2        1 Thanks, JaG

    Jaggerdude60 pointsBadges:
  • Sql Server CAL

    I have a Sql Server Enterprise 2005 64X, installed licesed by processor, I what to cut budget so thougt if I change to CAL licensing could save money, but know how to calculate how many users are currently conecting to my server. How can I get this info?

    Noyo775 pointsBadges:
  • SQL Syntax Error SQL0104

    I have to recreate a duplicate logical file, but I can't use the crtdupobj command because it doesn't recreate the correct library pointers. Using the dspfd command. I'm attempting to recreate the logical file in a different environment(library). Using the exact same commands (different library)...

    DLM2007285 pointsBadges:
  • retrive data from 3 tables

    HI i need to retrieve data of 3 tables using one more master table wat are the possible options Union,Joins anything else? with good performance please guide for considering the performance as the retrival count is huge in my case

    Inprise610 pointsBadges:
  • Script to add a Period after a Middle Inital- Then query AD for User ID

    I would like to create a script that parses an excel spreadsheet column with user's full names (I.E. 'John A Smith') and inserts a period (.) after the middle inital character. (I.E. 'John A. Smith') Once the middle inital period has been inserted, I would like the script to query Active Directory...

    AASuperTech5 pointsBadges:
  • MySQL brain teaser

    This has been driving me crazy. I’m trying to come up with an UPDATE query in MySQL that will remove the second blank space in a name and close the gap.   Example: O Brien, John E should become OBrien, John E   A simple REPLACE (name, ‘ ‘,’’) where SUBSTRING (name,2,1) like “ “...

    Michael Morisy8,323 pointsBadges:
  • help me create trigger update column

    CREATE  TRIGGER Trigger_UPDATE_BIENLAI_TIENNOP ON BIENLAI FOR UPDATE,INSERT,DELETE AS IF (@@ROWCOUNT = 0) BEGIN PRINT ' TABLE is null' RETURN END IF UPDATE(TIENNOP) BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP FROM BIENLAI BL1,DELETED BL2,INSERTED BL3  WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP...

    2110805 pointsBadges:
  • SQLEVN70.RLL error

    IT Answer "Your SQL server installation is either corrupt or has been tampered with (Could not open SQLEVN70.RLL). <I have been getting this error during bootup since i tried to install the microsoft office professional 2007 trial software i received with a computer book that i am currently...

    Caspeak5 pointsBadges:
  • How to create a loop query in SQL.

    Hello Friends, I am trying to write a SQL code to pull all the parts in a chain. For eg., Part A is replaced by Part B and Part B is replaced by Part C and C to D and so on. Is there anyway that I can pull all the parts in that loop at once. A,B,C,D,....., All these relationships are stored in one...

    Coolams5 pointsBadges:
  • Editions of SQL Server

    Can you briefly discuss the different editions of the database that are available now?

    ITKE352,565 pointsBadges:
  • SQL EXCEPTION JOIN

    I have three files (orderinfo, deliveryinfo and itemlines). The three files entries shall exist as 1 to 1 to many. The files contains orders from 10+ years. Thus data has been migrated several times by various people. I have discovered that the one-to-one-to-many rule has been broken for many...

    DanTheDane2,555 pointsBadges:
  • Whats the Difference Between UNION and OR clause in Oracle SQL

    I have query like Select empno,sal from employee where deptno = 10 or dept = 20 and i can also write this query in this ways also Select empno,sal from employee where deptno = 10 UNION Select empno,sal from employee where deptno = 20 Now i wanna to know which is better way between these two and...

    Goelneeraj0 pointsBadges:
  • SQL record with latest date

    if there is one table with a id and names as cloumns and another table with the id and dates, if want to have a id, name and the latest dates as an id can have mulitple dates what would be the query

    Techybrains5 pointsBadges:
  • SQL Fetch

    I an joing tow files with inner join. I want all the fields from the first file and only two fields from the other file. I defined an external DS for the first file then included that DS in another DS with the two fields from the other file but program will no compile. Will not read the last DS in...

    Doctor-job20 pointsBadges:
  • Seeking Help with SQL SUBSTR Function using Host Variables in COBOL

    Hello All I am currently on version V5R2 and I am trying to make a COBOL program produce some parsed fields from one large field. I have trying to use host variables for al three arguments in the SUBSTR function. The SQL compiler will take a host variable as argument number one but not for argument...

    FCARPENTER200 pointsBadges:
  • rpg sql

    I am using dynamic sql in an rpgle pgm. This pgm is called from 2 different menu options. When I take the 2nd option, everything works fine. I exit out of that option and take the first option. Everything is still work fine. I exit the first option and go back to the 2nd option and the pgm hangs up...

    mcg15 pointsBadges:
  • Storing array values into an Access database table from a program

    Hi, I’m trying to write a program that stores the values in an array into a database table. The name of the database is Company.mdb and the table that I want to store values is called Employee. Below is the procedure that is supposed to perform the task. The problem is it doesn’t store the...

    Zigzagzig10 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following