itgo.me

  • oracle11g - invalid identifier - oracle

    up vote 0 down vote favorite When I run the query below I get this message: SQL Error: ORA-00904: "B"."MEMBERS_COUNT": invalid identifier 00904. 00000 - "%s: invalid identifier" select pt.paym_type_na

  • oracle11g - Oracle listagg query

    up vote 0 down vote favorite This is my query result: WEEKENDDATE CCNAME PHNAME RATIO 08-Feb-15 Apple Line 1 - Day L&I Work 0.45 08-Feb-15 Apple Line 1 - Day Sorter 6.85 08-Feb-15 Apple Line 1 - Day T

  • oracle11g - ORACLE QUERY - OPTIMISATION

    up vote 3 down vote favorite 1 I have written the below query which has many 'AND' operators, i would like to know how to optimize the performance of the below query [can i remove some of the 'AND' Op

  • Oracle SQL substr

    up vote 0 down vote favorite I have two tables: Employee(empNo, lName, fName, sex, dob, address, deptno, position) Zip(city, state, zipcode) In the Employee table, the address is stored like this: 55

  • Deadlocks in Oracle

    up vote 0 down vote favorite 1 I want to make a script where the oracle sessions which go into a deadlock are killed automatically.Is it possible to find out the session id for the sessions which go i

  • oracle import error

    up vote 3 down vote favorite While importing a dump file into oracle 11gr2 i am getting this error please suggest a way to resolve this *Warning: the objects were exported by D7IDMP, not by you import

  • Ruby Oracle Timestamp

    up vote 0 down vote favorite 1 I have the following code in the method to extract a timestamp and print it. I am using the active record gem. def changeCreationTimestamp(procid, prflrefid, token)

  • sql - Paging with Oracle

    up vote 65 down vote favorite 47 I am not as familiar with Oracle as I would like to be. I have some 250k records, and I want to display them 100 per page. Currently I have one stored procedure which

  • Oracle ApEX website

    up vote -1 down vote favorite I plan to create a website using Oracle ApEX and have a question regarding security, authentication. Most of the pages are going to be public to anyone, but some of them

  • Oracle APEX project

    up vote -1 down vote favorite I am working on a project with Oracle APEX. There is one thing that I am not able to figure out. When I create a form and add data to it and run my application it keeps t