• Limit the number of rows returned by an Oracle query

    Would there be a way to make an Oracle SQL query behave like it contains a MySQL limit clause? So, for example, here's what I can do in MySQL: select * from sometable order by name limit 20,10 This allows me to get the 21st to the 30th rows (meaning skip the first 20, give the next 10). The rows...

    ITKE352,580 pointsBadges:
  • How to extract a query to a CSV formatted file using SQL Plus

    I'm trying to extract several queries to a CSV output format. The only problem is that I can't use SQL Client or Oracle. I need to use SQL Plus. How can I do it?

    ITKE352,580 pointsBadges:
  • Building an xml in java

    Please give me an example of building an xml with multiple child nodes, in java. I want something like : <Parent> <Child1>something</Child1> <Child2>something else</Child2> </Parent> Now, the values for Child1 and Child2 must be picked using SQL from AS400....

    Siri55 pointsBadges:
  • Connecting Visual Basic and SQL Server

    After creating ODBC, what code will connect the front-end Visual Basic and the back-end SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to import simple spreadsheet into MySQL database?

    I have a simple spreadsheet (only 2 columns) that I need imported into a MySQL database. I can convert the spreadsheet into whatever format I need to (comma delimited), but I need the MySQL commands that will import it. Does anybody know how to do this?

    Ingram871,285 pointsBadges:
  • Conversion of Oracle trigger to MS SQL

    How can I convert an Oracle trigger into MS-SQL?

    Jannat895 pointsBadges:
  • Create a Lotus Notes DB replica for Unique IDs only

    I have a Lotus Notes DB which contains a field populated with a unique id number. I would like an action button to prompt the user for their IDNUm, then once entered it would replicate only those documents where the IDNums match from the server to a local copy. We are currently able to do this...

    IMLearning25 pointsBadges:
  • Convert an Excel spreadsheet to a Access database.

    My questions: How do I convert data from an excel spreadsheet to a Access Database? How do I convert a access form to excel - Using the form as a front for data capturing? How do I link multiple users to a access database - making allowance for data to flow simultaneously into the database?

    Joshua55 pointsBadges:
  • Access database table linked to Excel file question

    Can multiple instances of the same access database be open when linked to same excel file?

    SeenFresh25 pointsBadges:
  • How to change the location where JPG is looked for in ACCESS

    I enter data for trophy fish catches into an AK. Dept of Fish and Game database. I inherited the DB. I have no IT help. All pictures were in a messy folder with the DB. I sorted the pics into sub-folders. Now the program cannot find the JPG associated with a particular entry. I assume somewhere the...

    Gingkobrother5 pointsBadges:
  • Converting Data in Excel to PF on DB2/400

    Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

    rajsubhyd105 pointsBadges:
  • Getting a textual representation from an Oracle BLOB

    I've been trying to see, from inside my SQL console, what's inside an Oracle BLOB. I already know that it contains a large body of text and I need to see it. But my query only shows that there's a BLOB in the field. Here's the query: select BLOB_FIELD from TABLE_WITH_BLOB where ID = ''; And this is...

    ITKE352,580 pointsBadges:
  • Good PL/SQL user guide

    I am interested in a good reference guild for PL/SQL which explain all utility commands and configuration patterns and files. Your help is much appreciated.

    Hfeshari0 pointsBadges:
  • Implementing DBMS

    My company does not have information services staff and I am not planning to ave one at this moments because of the expanses. We have 12 WINTEL microcomputers that we used for variety of tasks withing the organization. We use Microsoft Office for words and financial application and power point, but...

    Mis15 pointsBadges:
  • How to create a virtual shared disk on for a cluster setup?

    How to create a virtual shared disk on for a cluster setup? This question is from the Microsoft Virtualization Chat held on August 27th.

    ITKE352,580 pointsBadges:
  • What’s the difference between horizontally and vertically scaling a database?

    I'm working with two different databases (NoSQL and MySQL) and we're looking to measure the scalability of each database. What's the difference between vertically and horizontally scaling each one? I would appreciate any help.

    ITKE352,580 pointsBadges:
  • Why is NoSQL better than traditional RDBMS?

    I'm relatively new to the database world and I'm just getting into NoSQL. I want to know what makes NoSQL better than traditional RDBMS?

    ITKE352,580 pointsBadges:
  • Database design

    Hi all, I have a condition and formula generator in my application. I must save this condition and formula in database and calculate formulas for each condition. I want to model these conditions and formulas. For example: Condition: Education=BS AND MaritalStatus=Married AND YearsOfService>10...

    Elham10 pointsBadges:
  • DDS or SQL

    We have an existing COBOL application using files defined in DDS format. We are considering to move from DDS to DDL for future development. What is the best strategy to take this approach?

    Uiiuo50 pointsBadges:
  • How do I convert rows to columns in aAccess using Ms-access query(select statment)

    Hello all, please I want help with the following issue: I have the following table named "CHECKINOUT" in ms ACCESS USERID      NAME        CHICKTIME 1          K1        5:45:11 AM 1          K1        3:45:12 AM 1          K1        6:45:11 AM 1          K1...

    Ahejazi5 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