Database Tag Directory

Browse Alphabetically:

Featured Database Questions

  • Hibernate with clob type

    I am using clob of oracle 10 g in hibernate. When I tried to insert 5000lines of HTML code to the variable in Java, I'm getting the following error; Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.citi.gicap.bpm.ver.domain.Notes];...

    Arunpmk5 pointsBadges:
  • Case Statements SQL

    I'm running a query that returns a specific status code. However, within my query that specific status doesn't always exist and I get a null value. I would like to return another status when that is the case. I can't seem to get the case statement to work.

    Wilso01115 pointsBadges:
  • Cloning my dual boot Ubuntu/Mac PC to another

    HI, I have some computers which dual boots Ubuntu and Mac. I need to do the same in around 20 PCs again! How can I do using less resources and time? (All PCs are of the same configuration). All computers can be connected via LAN. I think Norton Ghost is not a solution.

    Jibin405 pointsBadges:
  • How can I change the collation name of a specific database?

    How can I change the collation name of a specific database?

    Nooshka5 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?

    ITKE350,300 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.

    ITKE350,300 pointsBadges:
  • Crosstab query in SQL

    How to make crosstab in my sql?

    Tafz085 pointsBadges:
  • Create .csv file on IFS folder in AS/400

    Please help to create .csv file in as/400 (V4R3). Please provide me the steps to create .csv file on IFS path on AS/400.(V4R3).

    Samule400160 pointsBadges:
  • Do you have any idea approximately when MS & Marathon will have the capability of clustering completed?

    Do you have any idea approximately when MS & Marathon will have the capability of clustering completed? This question is from the Microsoft Virtualization Chat held on August 27th.

    ITKE350,300 pointsBadges:
  • Help on Bulk insert and xp_cmdshell rename

    Hi, I have a csv with only one field with multiple rows, when i am using bulk insert to insert into sql server table, all the rows are inserted in to single column instead of multiple rows. I don't have a delimiter. csv file: (First row is blank) apple bat cat doll when I used the below command:...

    GIG240 pointsBadges:
  • How do I duplicate or clone a dying SATA drive?

    If a sata drive is dying what is the best method to duplicate or clone it without risking the data? Is this the same for ide or scsi drives? If not please list the best methods for these as well across any platform.

    ITKE350,300 pointsBadges:
  • Catching an uncaptured error in SQL

    This is a batch of SQL code I’ve been using: BEGIN TRY begin BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM '\Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting' WITH ( MAXERRORS =1000, FIELDTERMINATOR = '^', ROWTERMINATOR = '|n' ) end END TRY BEGIN CATCH SELECT 'Error Caught' SELECT...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to convert a csv file into a xlsx one?

    Hi, I'm generating a csv file from an open hub in BW so I need to convert it into a xlsx one due to I need to upload it into the Microsoft SharePoint. Is there an abap function that does it? I know that there is one to convert an xls one into a csv. Thanks

    VPD5 pointsBadges:
  • How can I split CSV strings in Oracle 9i?

    I'm trying to to split several CSV strings in Oracle 9i but I'm running into a few issues so I have a couple of questions: Is this possible in Oracle 9i? Do I need to create a new data type? Would I be able to declare the type within the function? Thank so much!

    ITKE350,300 pointsBadges:
  • Cloning C and G drives on Windows Server 2008

    I need to clone my C drive and G drive on a Windows server 2008. The C drive is a mirror and the G drive is a 6 disk raid 5. What is my best option for cloning this setup?

    TeachMeIT975 pointsBadges:
  • Can you explain what cluster shared volumes are? Is this a new file system?

    Can you explain what cluster shared volumes are? Is this a new file system? This question is from the 7/30 Microsoft Virtualization Chat on ITKnowledgeExchange.com

    ITKE350,300 pointsBadges:
  • How to implement crosstab query in Access?

    How to implement crosstab query

    Shamu75 pointsBadges:
  • Bulk Collect loop and Cursor Loop

    Why there is such a huge performace difference between Collection loop and a cursor Loop? Why collection populated using Bulk collect is way faster? Detailed explaination will be helpful. Thanks

    Nikhildhar35 pointsBadges:
  • How do you load a CSV file into Oracle?

    How do I load a .CSV file into Oracle?

    Dolly275 pointsBadges:
  • Sequence information of mutltiple subforms in one form?

    I have one form embedded 3 subforms. I need to identify which subform is the top of the form because I need to write out the fields value to CSV in subsequently left top to right bottom as user can see on their PC.

    koseiarai5 pointsBadges:

Browse Alphabetically:

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