Oracle In Linux
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
0 pts.
View scheduled jobs in a data file
When using the WRKJOBSCDE command on the AS400, you can see information regarding jobs in the scheduler. Is this information contained in a file which can be accessed for query?
When using the WRKJOBSCDE command on the AS400, you can see information regarding jobs in the scheduler. Is this information contained in a file which can be accessed for query?
Data dictionary find time of long running query
Howdi All, I'm trying to figure out a way to find queries running longer than X minutes in the data dictionary. It's been difficult to limit it to a specific query. Sessions are no problem. Here's the latest query I've come up with. SELECT sess.status, sess.username, ...
Howdi All, I'm trying to figure out a way to find queries running longer than X minutes in the data dictionary. It's been difficult to limit it to a specific query. Sessions are no problem. Here's the latest query I've come up with. SELECT sess.status, sess.username, ...
Issue with SQL Query from two tables that have a 1 to many relationship
Thanks all for your help to my question last week. I did manage to get two of the totals I needed for the query. I am still having problems getting the second total and realize now the tables I am pulling the data from have a 1 to many relationship. I am trying to print a report of time clock data...
Thanks all for your help to my question last week. I did manage to get two of the totals I needed for the query. I am still having problems getting the second total and realize now the tables I am pulling the data from have a 1 to many relationship. I am trying to print a report of time clock data...
Software Development in Java
Could someone please advise me (and my team) on which development tools and resources to use for rapid development of java (or java-based) business software packages such as inventory management systems, payroll packages etc. We have been developing using Oracle 6i Developer suite and now intend...
Could someone please advise me (and my team) on which development tools and resources to use for rapid development of java (or java-based) business software packages such as inventory management systems, payroll packages etc. We have been developing using Oracle 6i Developer suite and now intend...
How do you create query with multiple totals by date
I am trying to create a query that has totals of a particular hour type by date. This is what I came up with: select work_detail.wrkd_work_date, (select ((sum(wrkd_minutes))/60) from work_detail where work_detail.htype_id = 2) as totalot1, (select ((sum(wrkd_minutes))/60) from work_detail where...
I am trying to create a query that has totals of a particular hour type by date. This is what I came up with: select work_detail.wrkd_work_date, (select ((sum(wrkd_minutes))/60) from work_detail where work_detail.htype_id = 2) as totalot1, (select ((sum(wrkd_minutes))/60) from work_detail where...
PATINDEX Instruction Result Difference between SQL 7 and SQL 2000.
I am running the same SQL statement on SQL2000 with different results from SQL 7. What I'm actually trying to do is search a 30 byte character string for a certain pattern. I am looking for the following 9 digit pattern. 1) 1st Digit = any number (0-9) 2) 2nd Digit = any number (0-9) or the...
I am running the same SQL statement on SQL2000 with different results from SQL 7. What I'm actually trying to do is search a 30 byte character string for a certain pattern. I am looking for the following 9 digit pattern. 1) 1st Digit = any number (0-9) 2) 2nd Digit = any number (0-9) or the...
Using Query/400 to create SQL-style GROUP BY
Greetings and salutations, I'm trying to put together a query for one of my users to track sales numbers and it is starting to give me a headache. I've put together a query using Query/400 with a break at each invoice to sum the dollar amount for each one. The issue is that on many of our...
Greetings and salutations, I'm trying to put together a query for one of my users to track sales numbers and it is starting to give me a headache. I've put together a query using Query/400 with a break at each invoice to sum the dollar amount for each one. The issue is that on many of our...
Creating a query that will return specific days-3
I have a field that defines the frequency of a specific tasks. In this field there are daily tasks, monthly tasks, calendar year tasks, and fiscal year tasks. I have no problem with getting the daily tasks and the monthly tasks, it is the others that I am having problems with. I have defined...
I have a field that defines the frequency of a specific tasks. In this field there are daily tasks, monthly tasks, calendar year tasks, and fiscal year tasks. I have no problem with getting the daily tasks and the monthly tasks, it is the others that I am having problems with. I have defined...
Creating a query that will return specific days-2
I have a field that defines the frequency of a specific tasks. In this field there are daily tasks, monthly tasks, calendar year tasks, and fiscal year tasks. I have no problem with getting the daily tasks and the monthly tasks, it is the others that I am having problems with. I have defined...
I have a field that defines the frequency of a specific tasks. In this field there are daily tasks, monthly tasks, calendar year tasks, and fiscal year tasks. I have no problem with getting the daily tasks and the monthly tasks, it is the others that I am having problems with. I have defined...
Creating a query that will return specific days
I have a field that defines the frequency of a specific tasks. In this field there are daily tasks, monthly tasks, calendar year tasks, and fiscal year tasks. I have no problem with getting the daily tasks and the monthly tasks, it is the others that I am having problems with. I have defined...
I have a field that defines the frequency of a specific tasks. In this field there are daily tasks, monthly tasks, calendar year tasks, and fiscal year tasks. I have no problem with getting the daily tasks and the monthly tasks, it is the others that I am having problems with. I have defined...
SQL Server query
Hi ppl, I want to create a query that tracks a customer's order patterns on a monthly basis over the last 12 months. I have completed the query, however there are a couple of months (eg Nov-03) were no orders have been placed by any customer. I want to know how to display the month with 0 sales...
Hi ppl, I want to create a query that tracks a customer's order patterns on a monthly basis over the last 12 months. I have completed the query, however there are a couple of months (eg Nov-03) were no orders have been placed by any customer. I want to know how to display the month with 0 sales...
SQL
I created forms in FP2000 (html)so a user can add, change or delete from a DB (Access 2000). I have an input form.html that users can use to modify existing data in a table. There are about 13 columns of information in the table. On the form I have input fields for the old information and...
I created forms in FP2000 (html)so a user can add, change or delete from a DB (Access 2000). I have an input form.html that users can use to modify existing data in a table. There are about 13 columns of information in the table. On the form I have input fields for the old information and...
SQL UPDATE/SET/WHERE statement
I have a DB with 12 columns and hundreds of row with a key on the Smartrac_No. I have created forms in FP2000 to allow a user to add, change or delete rows of information. The following is my SQL statement in the updaterecord.asp: UPDATE smartracs2004 SET...
I have a DB with 12 columns and hundreds of row with a key on the Smartrac_No. I have created forms in FP2000 to allow a user to add, change or delete rows of information. The following is my SQL statement in the updaterecord.asp: UPDATE smartracs2004 SET...
oracle internet directory application developer's guide -- dbms_ldap_utl sample code doesn't work
Hi, all I'm trying to set up Oracle Internet Directory Rel 9. I'm trying to use APIs provided in Application Developer's Guide. I started by copying and trying to run the examples given in the guide. My procedure connects to LDAP, authenticates me, but won't create a user. (Actually, it passes...
Hi, all I'm trying to set up Oracle Internet Directory Rel 9. I'm trying to use APIs provided in Application Developer's Guide. I started by copying and trying to run the examples given in the guide. My procedure connects to LDAP, authenticates me, but won't create a user. (Actually, it passes...
Database Replication
Hello, i have to set up an Database Replication for both read and write access to a tables data from anywhere. Who knows a good description with an example for the set up and administration?
Hello, i have to set up an Database Replication for both read and write access to a tables data from anywhere. Who knows a good description with an example for the set up and administration?
Long running Delete Jobs
We have delete jobs which delete a lot of records belonging to one Version of data that runs for sometimes 2 days. The relation to this Dataversion is done by one Column in each Table whith the same value called Versionnumber. Lots of the tables are conected with cascaded deletes. How can I...
We have delete jobs which delete a lot of records belonging to one Version of data that runs for sometimes 2 days. The relation to this Dataversion is done by one Column in each Table whith the same value called Versionnumber. Lots of the tables are conected with cascaded deletes. How can I...
