[oracle] Forum Topics

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?

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?

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 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, …

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 …

I m try to solve this problem Add a column named *reorder_quanity* to the *books* table that will hold a value up to 999 with a default value of 10. 4. Update the reorder quantity of all books to 10. 5. Update the quantity ordered to 1 for all books …

hi... I have a doubt. please clear me that what is the difference b/w sql, mysql & oracle.? please reply soon...

select companyname,sum(sale) as TotalSale,sum(purchase) as TotalPurchase from invoice group by companyname Having companyname IN (select companyname from invoice) It returns sum only for those column whose all sum are not blank, how can i show blank sum values I mean there are 7 companies but only 4 records are shown. …

How to take a user table backup from that user account? I mean i want to give him grants to take backup... also query to take backup.

hiiiiiiii I want some help from you I want to start learn orcal just basic I dont know if I can use sql in microsoft tell me If I need to download any things? thanks

Hi, I am trying to find out list of employees who have no dept_id. Below code works. [B]select e.emp_id, e.last_name, e.dept_id from employees E where dept_id IS NULL[/B] Below code does not work. i want to rewrite the query using NVL to replace the value by 0. does not work. …

hey guys, i have a query wherein one table has the same id as the other using inner join.. SELECT c.cat_name, g.maxscore, g.description FROM grp_performance INNER JOIN category ON g.cat_id = c.cat_id Is it possible to use inner join when deleting a row? like.. DELETE FROM grp_performance INNER JOIN category …

Imagine my surprise when I logged onto Daniweb and saw a scrolling advert for IBMs Informix database. I've been using Informix for years and it is an incredibly elegant bit of code, and the object extensions you can use are totally unique. I'd always thought of Informix as a secret …

Can anybody tell me the difference between a Primary key and a Unique Key ?Kindly let me know the idea.Any help would be highly appreciated.

I have VS 2008 on Win 7 Professional 64bit system and database is Oracle 11g r2 installed on the same machine. In Data Source Configuration Wizard --> New Connection Data Source: Oracle Database (Oracle Client) When I click Test Connection after entering Service name, username, and password I get the …