• 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, sess.machine, sess.program,...

    Tmjimob0 pointsBadges:
  • database design

    sir, i am developing the order-process mgt (3-tier intranet app)using jsp,java,javascript and mysql as backend. i have to store the data from the customer order-sheets. in this business, they organize the garments(product) according to the colour.then each color is divided in to sizes like...

    Msuresh270 pointsBadges:
  • database design-2

    sir, i am developing the order-process mgt (3-tier intranet app)using jsp,java,javascript and mysql as backend. i have to store the data from the customer order-sheets. in this business, they organize the garments(product) according to the colour.then each color is divided in to sizes like...

    Msuresh270 pointsBadges:
  • 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 to...

    Tendy770 pointsBadges:
  • 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...

    Trinaa0 pointsBadges:
  • 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...

    Trinaa0 pointsBadges:
  • 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 letter...

    RAMBORAY0 pointsBadges:
  • 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...

    MwphData0 pointsBadges:
  • 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...

    MwphData0 pointsBadges:
  • 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...

    MwphData0 pointsBadges:
  • 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...

    Piq9920 pointsBadges:
  • 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 input...

    CathyS0 pointsBadges:
  • 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 Description='::NewDescription::' WHERE...

    CathyS0 pointsBadges:
  • 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?

    Mysterky0 pointsBadges:
  • PL/SQL and Excel

    Hi, Is it possible to execute Excel Macros from PL/SQL procedure ?

    Gleferrec0 pointsBadges:
  • execute immediate

    Can anyone remind me what EXECUTE IMMEDIATE does, and what are the pros and cons of using it versus regular dynamic SQL refcursor fetch. Thanks.

    Paulina0 pointsBadges:
  • 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...

    Mysterky0 pointsBadges:
  • Best PL/SQL Tool?

    In your opinion, what's the best PL/SQL development tool on the market, and why?

    Nmarco0 pointsBadges:
  • Database groups in Ireland

    Do you know of any associations in Ireland that specialize in Database work, such as an Oracle Users Group?

    Pegasusdba0 pointsBadges:
  • SQL string limitation

    Oracle8i SQL I wrote a query below that pulls in the procedure code from application specific metadata. I wrote it to search up to 4 levels deep of the 2000 character string object_text column. When object_seq greater than 1 exist it will concatenate the code. The SQL bums if it finds more than 2...

    NOCOPY0 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