‘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
