I want to perform my query on a string in this format, xxxx/xxxx where x is a number. when I perform it using the Oracle interface or my C# application I get this error: ORA-00904: "xxxx/xxxx": invalid identifier I performed this query: SELECT * FROM "My Table" WHERE Field="xxxx/xxxx" ...
I want to perform a special query on a table in my oracle database. I want the result to be sorted according to an enum that I have. the enum goes as follows: private enum days { Saturday = 1, Sunday, Monday, Tuesday, Wednesday, Thursday, } I want the result to be sorted according to this enum. ...
I want to perform a special query on a table in my oracle database. I want the result to be sorted according to an enum that I have. the enum goes as follows: private enum days { Saturday = 1, Sunday, Monday, Tuesday, Wednesday, Thursday, } I want the result to be sorted according to this enum. ...
Hi, I installed oracle-xe into my virtual box that running with Fedora 13 successfully. Although I can ping my virtual machine, I can not connect the database from outside the box. Do I have to make some changes on tnsnames.ora or can I use another connection type for this situation? I would be greatly appreciated if someone be able to ...
Hello, I make use of: NetBeans IDE 6.7.1, GlassFish v2.1, Oracle 10g XE, JAVA 6 SE, JAVA 5 EE, From inside a stateless EJB I persist entities of type customer I have the annotation: @SequenceGenerator(name="seq", sequenceName="cust_id_seq") in the class customer so the primary keys are autogenerated in the database from the seque...
i am facing this error when i start the oracle. I checked Oracle Home and SID. everything is set properly. ORA-27101: shared memory realm does not exist please help me to find out the solution. Thanks in advance ...
the designing.making/deploying/management of a distributed database? or do i need to buy the versions for the above? if it 10g express has this support, will there be a central point to which my web application will connect, or do i have to write connection strings to connect to each server making "the distributed database " please al...
i have oracle 10g express edition installed and i want to know how to create a system dsn for it.so that i can connect database to my java programs ...
I am trying to make use Oracle's ability to deploy and invoke .NET assemblies within it. This requires connecting as SYSDBA. The weird thing is that I can connect as Normal and as SYSDBA from within PL/SQL Developer and I can connect as Normal from within Visual Studio, but get an "insufficient privs" error connecting as SYSDBA from Visu...
When I try to use WMSYS.WM_CONCAT with Oracle XE 10g, I receive a compilation error: ORA-00904: "WMSYS"."WM_CONCAT": invalid identifier. Can anyone verify that this is indeed due to XE lacking this (undocumented) feature? If so, is there anyway to enable it in XE? ...
I need to rebuild the following object in an Oracle database...can somebody tell me how I would go about doing this? Thanks in advance. OBJECT ID = 576 OBJECT_NAME OBJECT_TYPE SMON_SCN_TIME_TIM_IDX INDEX ...
For a certain assignment, I'm tasked with creating a very simple Q/A site, complete with tagged questions and commented answers. One of the requirements is to have a trigger to detect the insertion of duplicate tags and, if such is the case, increment the already-existing tag's usage counter. Problem is, I can't cancel the trigger with...
Hay I ve installed oracle-xe 10g sever version on ubuntu desktop 10.10 32 bit. for installation i ve followed the these steps: [https://help.ubuntu.com/community/Oracle10g] Now im working with my dbms. its just working fine. for php setup i've followed this: [http://netbeans.org/kb/docs/php/configure-php-environment-ubuntu.html] now ...
This seems so simple but I can't understand how do I do this query: I have a table users like this: user_id | name | role 1 | abc | a 2 | lol | b 3 | f | c and a table usersprojects (with user and project PKs) projectid | userid 1 | 1 1 | 2 2 | 2 2 | 3 How could I select all us...
I want to find the user who is doing most physical reads to the hard-disk and kill that user. Can I have a SQL/PL script to do that in oracle xe? ...
I have created a table: INDEX_SIZE_TRACKING with the following attributes: Index Name: name of the index. Type: VARCHAR(255). This is the primary key of the table. Allocated Space: the memory space (in bytes) allocated to the index. Type: NUMBER Used Space: the memory space used by the index. Type: NUMBER Last Update: the time when ind...