Hi - I have a table that stores the page hits on a web application, storing unique_row_id http_session_id page_name page_hit_timestamp ---------------------------------------------------------------- 0 123456789 index.html 2010-01-20 15:00:00 1 123456789 info.html 2010-01-20 15:00:05 2 ...
I have a table which represents a line-by-line dump of the data read from a particular text file format. Each line may represent a "master" or a "detail" line, indicated via rec_type code. I'd like to write a query that gets the "master" lines alongside the associated detail lines. I've come up with something that does the job, but it se...
I have a table with fields (simplified): id, fld1, fld2, fld3. id is a numeric primary key field. There are duplicates: id differs but fld1, fld2 and fld3 are identical over 2 or more rows. There are also entries where the values occur only once, i.e. non-duplicates, of course. Of each set of duplicate entries, I want to retain only...
Hi i have a table that is 5 GB now i was trying to delete like below: delete from tablename where to_char(screatetime,'yyyy-mm-dd') <'2009-06-01' But its running long and no response. Meanwhile I tried to check if anybody is blocking with this below: select l1.sid, ' IS BLOCKING ', l2.sid from v$lock l1, v$lock l2 where l1.block ...
I have a Java application running against an Oracle 9i database. The database has a trigger to create an audit record, which tracks changes to the base record. The trigger utilizes current_timestamp. When I modify the base record with the Java application, the audit record reflects GMT. However, if I use Toad and update the base reco...
[Cross-Posting from ServerFault] I am in a development environment, and our test Oracle 9i server has been misbehaving for a few days now. What happens is that we have our JDBC connections disconnecting after a few successful connections. We got this box set up by our IT department and handed over to. It is 'our problem', so options li...
This is the command,i am using in ORACLE 9i. SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY') Date FROM DUAL; It gives an error "FROM keyword not found,Expected" ,where Date is an ALIAS,but when i enclosed Date in "Date" double quotes like this ,it is taking it as an Alias and output is right. Please SUGGEST!!! ...
I am using Oracle 9i ,when i type ed ,notepad gets open ,i want to use Microsoft Word instead of notepad as an editor,Is it possible? ...
I got the following error in Oracle: SELECT * FROM abcd WHERE name LIKE 'a%' LIMIT 10 * ERROR at line 1: ORA-00933: SQL command not properly ended What is the problem with the command? ...
I have created two tables with following descriptions SQL> desc new_emp Name Null? Type EMPNO NUMBER(4) ENAME VARCHAR2(10) JOB VARCHAR2(9) HIREDATE DATE SAL ...
select salary from employees order by salary desc MINUS select salary from employees where rownum<10 order by salary desc; I am unable to use order by with MINUS ,it says sql command not properly ended. Please suggest! ...
Hi, This is my query, CREATE VIEW employee_vu AS( SELECT employee_id,last_name "employee",department_id FROM employees); I am giving alias of columns in lower case ,and in it is stored in lower case after doing desc i have confirmed. But when i am trying to select this column employee :error occurs EMPLOYEE: invalid identi...
I want to show indexes,sequences,constraints in DESC command ,is it possible, or any other cammand by which i can see structure(design) of a table along with constraints, sequences,indexes. ...
Hello, We have a Oracle 9i database and OrderDetails table which has a column to store binary data for product images. These images can be viewed only using a 3rd party tool. I have no idea which 3rd party tool. and I have no idea of the format of the image. Is there anyway from the binary data we can find what format is the image? Tha...
Following is the configuration details: <property name="hibernateProperties"> <props> <prop key="hibernate.dialect"> org.hibernate.dialect.Oracle9iDialect </prop> <prop key="hibernate.show_sql">false</prop> <prop key="hibernate.cache.provider_class"> org.hibernate.cache.OSCacheProvider </prop> <prop ...
When I create a directory using sytem user (vin.txt is my file) create directory emp_dir1 AS "'C:\Documents and Settings\Administrator\Desktop\vin.txt'"; it creates it. When I do the same using user Scott it gives an error for path of file that "Identifier is too long" but when I put this file path in single quotes instead ...
Hi, I am writing some new SQL queries and want to check the query plans that the Oracle query optimiser would come up with in production. My development database doesn't have anything like the data volumes of the production database. How can I export database statistics from a production database and re-import them into a development...
I am using Oracle 9i and want to know to the definition(code) of predefined functions in Oracle like,REVERSE(),REPLACE(). Is there any library of oracle where i can serach these library functions! Please Suggest!! ...
Is there any way to handle exceptions in sql(ORACLE 9i) not talking about PL/SQL only sql ? Since I was trying to divide values of a column that contains both numbers and literals ,I need to fetch out only numbers from it ,as if it divisible by any number then its number else if contains literals it would not get divided it will generat...
We currently have an Oracle 9i Client running on an HPUX Itanium platform and are looking at upgrading the Server from an Oracle 9i Windows 2000 Server to an Oracle 11g W2K3 Server. Is an Oracle 9i Client compatible with an Oracle 11g Server? Are there any problems with this configuration or is it recommended to upgrade the Oracle 9i C...