Recent IT Questions

1 - 8 of 8
<<PREVIOUS 1 NEXT>>

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

View Answer   |  Feb 8 2008   7:12 PM GMT   |  asked by MAB TRIBEFAN
Data/Application Integration, SQL, Database


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 Dollars102 Adam 010C Cafe- 10.00 Dollars102 Adam 05CC Cafe- 5.00 Dollars103 Jane 010C Cafe-...

View Answer   |  Jan 5 2007   8:23 PM GMT   |  asked by mjackson
Database, Oracle, DB2


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

View Answer   |  Dec 4 2006   9:27 AM GMT   |  asked by dmcdconsult
Oracle, Business Intelligence, Data/Application Integration


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

View Answer   |  Nov 27 2006   3:09 PM GMT   |  asked by dmcdconsult
Oracle, Business Intelligence, Data/Application Integration


ORA-12535

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 indefinately.tnsping to these remote...

View Answer   |  Oct 26 2006   5:44 AM GMT   |  asked by SINETA
Windows, Architecture/Design, Availability


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

View Answer   |  Oct 24 2006   11:28 AM GMT   |  asked by 108108
Database, Oracle, DB2


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

View Answer   |  Oct 6 2006   11:26 AM GMT   |  asked by IdongesitDaniel
Oracle, Database, DB2


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

View Answer   |  Jul 10 2006   12:23 AM GMT   |  asked by Columbus
Oracle, Windows, Oracle Administration


1 - 8 of 8
<<PREVIOUS 1 NEXT>>