Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: missmis44
  • Content: Threads
  • Order by date
  1. missmis44

    NUMTOYMINTERVAL - Subtracting 18 years

    I am trying to select from a Query that I created a count of the inmates that were over 17 when they were booked. I am getting the following Oracle Error: DECLARE * ERROR at line 1: ORA-01839: date not valid for month specified ORA-06512: at line 18 SELECT COUNT(BOOK_ID) INTO ADULT_MALE FROM...
  2. missmis44

    ORA-00920: invalid relational operator

    More details in thread1177-1136650 I am getting the following error: ORA-00920: invalid relational operator with this script: SELECT J.BOOK_ID, A.FEL_MIS_WT, J.BOOKDATE, A.ARRE_ID FROM JMMAIN J, ARMAIN A WHERE (J.BOOK_ID,DECODE(A.FEL_MIS_WT, 'F',1,'W',2,'M',3)||J.BOOKDATE,A.ARRE_ID)...
  3. missmis44

    Query Filtered by Data

    I am trying to create a query to list only one arrest record per booking.There are two tables JMMAIN (Booking) and ARMAIN (Arrest). The ranking are in the following priority order: F,W,M. If both records are the same, such as BookNum 2 that has two Fs and one M, I want it to display ArrestID 5...
  4. missmis44

    POPULATING NULL FIELDS FROM RELATED FIELD W/IN SAME TABLE

    FOR AN ARREST RECORD, WE ONLY ENTER THE CJI_PCN FOR THE FIRST RECORD.THIS SCRIPT NEEDS TO POPULATE ALL THE OTHER RECORDS WITH THE SAME ARRE_ID WITH THE CJI_PCN THAT IS POPULATED, IN OTHER WORDS WHERE CJI_PCN IS NULL, POPULATE IT WITH THE CJI_PCN OF THE RECORD THAT HAS THE SAME ARRE_ID. FOR...
  5. missmis44

    CREATE TABLE LOOP of dates

    I am trying to create a table that lists the date from the first date of a record in the system through the current date, a count at 8:00 AM Each day of how many inmates we have in the jail and a full day count of inmates in the jail. Once this table is created through today. I want to run a...
  6. missmis44

    I am taking a practice test for the

    I am taking a practice test for the Intro to Oracle exam. Why is the answer: Line 1 Evaluate this CREATE TABLE statement, which line of this statement will cause an error? 1. CREATE TABLE order ( 2. id# NUMBER(9) CONSTRAINT PRIMARY KEY, 3. order$ NUMBER(9) CONSTRAINT NOT NULL, 4. date_1 DATE...
  7. missmis44

    Subtract 35 minutes from sysdate

    I have the below statement in which I want return all rows that have a releastime between ((sysdate-35 minutes) and sysdate). How would I accomplish this? SELECT BOOK_ID, NAME_ID, TO_CHAR(RELEASTIME, 'DDMMYYYY') "RELEASE_DATE", TO_CHAR(RELEASTIME, 'HH:MI:SS AM')...
  8. missmis44

    Command Button to Email a Table as an Attachment

    I want to create a command button that when it is clicked it first runs my make query. Then brings up Outlook with that table as an attachment so that my user can enter the appropriate email addresses and send the email. Anyone have any ideas????

Part and Inventory Search

Back
Top