1
  • SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.

    Please I need an SQL command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype. My Oracle database is on Windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...

    IdongesitDaniel5 pointsBadges:
  • ORA-12535 error on Oracle 9i

    My database runs on 9i. There are remote databases that connected to it. Today all of them are failing to connect because of the error message ora-12535. I increased the CONNECT_TIMEOUT but error still persists. I even set it to zero (0) and the system hangs indefinitely.tnsping to these remote...

    SINETA0 pointsBadges:
  • Count distinct rows on multiple columns

    I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00...

    Mjackson0 pointsBadges:
  • Integrating MS Outlook With iSeries

    I have been asked to display a calendar such as what Outlook has showing dates of events that are stored in the AS400. Just to complicate things, the users would also like to reschedule appointments so we need to update the AS400! (I may be able to talk them out of this) Does anyone have any ideas...

    Pratty5 pointsBadges:
  • Data Sources for SSAS 2000

    I have a short term issue where I will need a SSAS2000 cube to be using data from a SQLServer2005 database. Can I do this directly? If not, can I Export MSSS2005 data directly to the MSSS2000 database? (Sorry for such a simple question- I am a newbie).

    Petro5 pointsBadges:
  • ‘m trying to verify that a SQL DATABASE is empty ,

    I am modifying a VB program that is taking ALL the tables from an ACCESS Database and converting them to a SQL DATABASE. They VB Program opens the SQL DATABASE, but I want to verify the database is completely empty. Is there a function or call that can be added to the code??

    MAB TRIBEFAN5 pointsBadges:
  • XML Publisher with Shipping Docs

    We are trying to use rtf Templates for our shipping docs. When we launch the concurrent request individually they work great. But when we use Ship confirm (which launches the doc set automatically) the xml is generated but the pdf format is not. Looking at the submitted requests, the layout has not...

    Dmcdconsult40 pointsBadges:
  • XML Publisher Issue

    We can't output a concurrent request via XML Publisher... We can create data definitions and link data templates (.rtf files) through the app, when we attach a data.xml preview file, we can preview the output correctly. When we actually attempt to run the concurrent request, the output shows the...

    Dmcdconsult40 pointsBadges:
  • Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g

    Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....

    1081080 pointsBadges:
  • Running a script at specified runtime

    I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks

    Columbus0 pointsBadges:
1

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