• convert from msaccess to sql2005

    SELECT Format(DTrans.DATE,'dd/mmm/yyyy') AS dated, DTrans.trntype as Expr1 , DTrans.JVNO, 'By ' & FINNACCO.ACCNAME , (select analscode from INCEXPAN where analscode=val(DTrans.CRANALSCODE) and accode=craccode) AS CRANALSCODE, '' , DTrans.AMOUNT, dtrans.craCCODE AS accode,...

    Radhikanutalapati5 pointsBadges:
  • Oracle 10G installation errors on memory variable

    WHEN I INSTALL ORACLE 10G FIRST TWO THREE TIMES INSTALLED PROPERLY.AFTER DELETING ALL THIRD TIME AFTER INSTALLING DEVELOPER SUIT I DELETED 10G AND INSTALLED AGAIN.AT THAT TIME ENVIRONMENT VARIABLE 1036 ERROR MESSAGE CAME .   HOW TO OVERCOME THIS ERROR  

    PAPA1015 pointsBadges:
  • Connect to Oracle DB in Windows 7

    I installed Oracle 10g client on Windows 7 Pro with no install errors. However, I had to add the user of the machine I am configuring to the local Administrator group for my app that uses Oracle db to be able to connect to the database. I don't want this user to be an admin though. I tried Power...

    OracleSpatial50 pointsBadges:
  • Problem With Import in OWB (Oracle Warehouse Builder)

    Hi, We are using OWB for data migration in our project. We have been facing while importing mappings from one environment to another. We have noticed that sometimes after import in the new MAP some existing connections are missing.  Does anyone have idea why this happens. The Version we are using...

    Indrajit5 pointsBadges:
  • Export Oracle 10g and Import to Oracle 9i

    I have a data warehouse server that's running Redhat AS 2.1 and Oracle 9.2.0.4, and a production database that's running Redhat AS 4.0 and Oracle 10.2.0.3. I need to export tables from the Oracle 10g database and import them into the Oracle 9i database. The Oracle 10g server/database is new. I know...

    Llewis5 pointsBadges:
  • The most-watched IT questions this week: Dec. 15, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Ak1bo78 asks for a C# how to on IF Statement’s, which Mshen and CarlosDL help create. 2. Dbsi2006 asks for help on how to map drives without UNC, which Rklanke, MrDenny,...

    Michael Morisy8,323 pointsBadges:
  • applications of rdbms in real world

    i need to know how rdbms is used in our real life with good example

    Chithra5 pointsBadges:
  • Crystal reports and Oracle

    I need to have a user design and run reports without having them being a local admin on the machine. I have tried various options, but the user cannot connect.  We are using SYSTEM DSN ODBC  Does a reports user have to be a local admin???

    Steveal5 pointsBadges:
  • Stored Procedures on AS/400

    Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks...

    Ashnirody100 pointsBadges:
  • Preview report in in Oracle forms.

    Is there any way to preview a report within a particular window in a form?

    PreethaSreekumar30 pointsBadges:
  • The IT Blog Top 10: Dec. 10, 2009

    10. No Exchange 2007 on Windows 2008 R2 – but why? Brendan Cournoyer delves into why the latest Windows 2008 R2 takes a surprising turn in not support Exchange 2007. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8....

    ITKE342,975 pointsBadges:
  • The most-watched IT questions this week: Dec. 1, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. CompEng asked about open-ended SQL statements, and Mrdenny and Meandyou delivered the goods. 2. Kalpana queried Networking certifications, and where the best place is to get...

    Michael Morisy8,323 pointsBadges:
  • Oracle Developer 10g not working

    i have oracle 10g database and devolper10g and i run a oc4j and start sccess i have a problem when i run a form the the servelet not work and the page can not be displayed and the message "The gateway could not receive a timely response from the Web site you are trying to access. This might...

    Yomran5 pointsBadges:
  • Triggers to Populate Geometry of a Feature

    Hi, Has anyone created a trigger that populates a field with the geometry of that table, where the table contains spatial geometry?  For example, I would like to create a trigger to automatically populate an area (AREA_SQM) or perimiter (PERIM_M) field of a building area feature (AREA_BUILDING)...

    SamAvella30 pointsBadges:
  • The most-watched IT questions this week: Dec. 8, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Pushan1234 asks about Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime. CarlosDL and MrDenny provide some pointers. 2. Bonbon78 runs...

    ITKE342,975 pointsBadges:
  • Business Impact or plus using Oracle 11g RAC over 10g

    Business Impact or plus using Oracle 11g RAC over 10g

    Inprise610 pointsBadges:
  • Problem running Oracle Forms 10g in browser

    I am unable to run the form in the browser I have set the run time preferences

    Babladi5 pointsBadges:
  • ORA-01033 : Oracle startup or shutdown in progress

    We are getting this error while accessing the Database. Tried restarting the server and "the alter database open" command throws error: ORA-01122: database file 6 failed verification check ORA-01110: data file 6: 'G:ORACLE102DBCITI10DATAQCSITEADMIN' ORA-01251: Unknown File Header Version read for...

    Aloksarda5 pointsBadges:
  • Performance Problem

    We are experiencing intermittant performance problems most likely related to the update of a file that saves emails sent to customers. The problem may be related to a 10,000 byte text field for the body of the email message and/or the size of this file (2 million records). The file has one index...

    Ashnirody100 pointsBadges:
  • step to install oracle 8i with client/server

    i have installed oracle 8i in win xp prof. can i make it as oracler server or should i use win 2k. whar are changes in sqlnet.ora and tnsnames file. should i install d2k on client only. kindly reply me all steps for this instaqllation. thanks a lot in advance

    Msa5 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