[oracle] Forum Topics

Hi, I have a java appllication which has a query depending on the requirement, select EmployeeID, TransactionAmount from employee where EmployeeID IN ('E123','E234') group by EmployeeID; which works well in mysql, but for oracle a get an error like [Err] ORA-00979: not a GROUP BY expression Can anyone help me …

Hi, i work with SQl Navigator and Oracle and i want to buy Mac laptop, but i am not sure if Oracle 11g is going to Work in Mac. So the question is: If SQL navigator 6.2 and Oracle 11g can work in Mac OS. Thank you.

Hi, I have a select statement and I need to find a way to apply a filter to it: [CODE] select * from my_table where my_table.field_1 like :filter_item [/CODE] The real problem is that filter_item can be a string, a string that includes '%' or a comma-separated string that can …

Hello guys. I have a problem to check datetime overlapping in oracle database. I have this kind of data in my table in oracle. [B]START_DATE[/B] 2011-01-01 08:00:00 [B]END_DATE[/B] 2011-01-01 16:30:00 Given datetime from user is something like this : ---------------------------------------------------------- StartDate = 2011-01-01 07:30:00 EndDate = 2011-01-01 16:20:00 [B]OR[/B] StartDate …

I have encountered ORA 00604 Error, while i was accessing database from my app over Vista system over network, it runs ok on database system... Can any one help me please finding out the solution.

give the concept of before and after trigger..

what is a oracle and dba?pls.........tell me answer. what is the difference between oracle and dba?

Here is the code which is working fine for me on another form but creating problem when i use the same code on another form it gives me this error message when i try to insert a new record in DB "Value cannot be null Parameter name: Data Table" and …

Hi, As the title states, I have a query that I use to concatenate all the rows into a single string and I use the XMLTransform method to accomplish that but I still need to add a new line separator within the XML string and so far I didn't find …

Greetings, I am doing a project that will migrate sybase central to oracle with the used of oracle sql developer, and when im trying to add new connection in sql developer that will connect my sybase when i try the TEST button its status is success but when i retrieving …

Greetings! I am new in Sybase Central, i am trying to migrate Sybase to Oracle using oracle developer. But unfortunately it is for asking for the PORT and HOST of the particular Sybase Database which is i realy dont know because is it my 1st time to see this database. …

how can i alter the INITIAL and NEXT value of a table. I tried something and ended up with the following code. [code]ALTER TABLE TABLENAME ADD ( PRIMARY KEY (ORDER_ID) USING INDEX TABLESPACE TALLYDATA PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED …

hello...i just installed oracle 10g in my pc but i dint get username and password for sql*plus......plz help me

[CODE] insert into AUDIT_TABLE( "TIMESTAMP", AUDITCATEGORY, USERID, AUDIT_XML, "AUDITID", "SOURCE", "ROLE", EVENT_ID, EVENT_DATA, TYPE_OF_APPLICATION) select CURRENT_TIMESTAMP, AUDITCATEGORY, USERID, AUDIT_XML, (SELECT MAX(AUDITID)+1 FROM AUDIT_TABLE), dummyNumber||i, "ROLE", EVENT_ID, EVENT_DATA, TYPE_OF_APPLICATION from AUDIT_TABLE where "SOURCE"='1312171509321'; [/CODE] Hi, Above is a part of my stored procedure , I'm trying to create test data for …

create or replace [CODE]PACKAGE BODY employee_details AS PROCEDURE INSERT_ROW ( P_EMPNO IN NUMBER , P_ENAME IN VARCHAR2 , P_MGR IN VARCHAR2 , P_SAL IN NUMBER, P_DEPTNO IN NUMBER, P_COMM IN NUMBER, P_HIREDATE IN VARCHAR2, P_JOB IN VARCHAR2, P_error_message OUT VARCHAR2 ) is l_EMPNO NUMBER; l_object_name VARCHAR2(60) := 'employee_details.INSERT_ROW'; BEGIN te_trace('Entered …

it is highly recommended........that tell me exact difference between storedprocedure and trigger

Thanks for this answer. Is there is any certification for Oracle SCM?

hello. while long search and issues with connection to oracle database,i installed oracle database 10g express edition or XE,32 bits. i have win 7 and 64bits machine. so i tried to connect to this database after setting the ODBC driver (32 bits driver),but the problem is: i successful connected from …

hello. i have oracle 11g installed on 64 bits laptop running with windows 7. and i manage the ODBC driver fro oracle from the administrative tools ,and i tested the connection from there and everything is okay. but then i tried to connect to oracle 11g DB using visual studio …

Hi All, as i am new to asp.net as well oracle /mysql. i have been given a task to shift website from Oracle databse to Mysql ,i found some tools to convert databse. database converter , procedures / functions /packages copied, but facing problem to make a connection. I checked …

Hi, The problem that im facing is while connecting to oracle11g database from Windows 7 running a java application which uses spring. Through navicat im able to connect to oracle database. When trying to connect from my application deployed in websphere the exception what im getting is Caused by: java.sql.SQLException: …

I hve created one procedure in oracle which is used as a dataset 1 in SSRS in oracle procedure we created one table which is used in sql server query as a dataset 2. but after click on refresh button it gives proper resultset. can we get proper data without …

I have a table customer in ms sql and i have same table in Oracle. I want to insert data from ms sql to Oracle. I am not getting the solution.

I have connected java with oracle over lan, in connection string i have provided the IP address, now the startup is very slow, how can i make it fast, i have already asked the same question in java forum but no responce, so i thought oracle expertise can answer this …

hey guys!!! I tried downloading oracle 10g release2& 11g release2 and both of them failed during the universal download. On both links it told me it should be 5.1 or 5.2, actual 6.0? Can anyone please help me here. I tried doing this 2 times and the same result. I …

Hey guys, I'm having an issue understanding how to write a table that uses an id and another id which both have dual keys. What I mean by dual keys is they use primary key and foreign keys. Example: Table Name = Enrollment Column Name = Sid, Csecid, Grade Data …

while i am executing this piece of code i am able to generate the correct result: [CODE]select parent.MEMBER_ID, count(child.MOVIE_ID) from parent left join child parent.MEMBER_ID = child.MEMBER_ID group by parent.MEMBER_ID;[/CODE] but when i am adding another field from parent field, i am getting an group by expression error: [CODE]select parent.MEMBER_ID, …

I have connected java with oracle and providing the facility of accessing data on the lan... I have also open a port, but still my java app over lan start very slowly after that it speed up, but at startup its very slow Y? Thank you for any suggestion

What am I missing... I have looked and searched. Any help / direction? [CODE]-- DANIWEBOS DROP TABLE ENROLLMENT CASCADE CONSTRAINTS PURGE; DROP TABLE COURSE_SECTION CASCADE CONSTRAINTS PURGE; DROP TABLE COURSE CASCADE CONSTRAINTS PURGE; DROP TABLE TERM CASCADE CONSTRAINTS PURGE; DROP TABLE STUDENT CASCADE CONSTRAINTS PURGE; DROP TABLE FACULTY CASCADE CONSTRAINTS …

Create a script named *just_lee_trg.sql* that contains the PL/SQL code to create a trigger named *books_qty_on_hand_trg*. The trigger should be set up to fire whenever the quantity on hand for a book has been updated. When the quantity on hand becomes zero, it should call the *insert_reorder* procedure and pass …