[oracle] Forum Topics

Hi All, I am updating a column in a table through SQL+ using Select to_char(systimestamp,'YYYY/MM/DD-HH24:MI:SS.FF3')from dual; The same field when updated through an application has a time offset of 4hrs. Select dbtimezone from dual; returns DBTIME ------ -04:00 I want to form a statement which will update the field with …

Hi All, I am trying to copy recordset in excel file. When i execute the query in toad it is obtaining 12 records. But when i use ADODB.RecordSet it is returning only one record. Please help me in fixing this.. Set objRec = CreateObject("ADODB.Recordset") objRec.Open SQL, curSession When i return …

Hello, folks. Well, I can't get my head around that particular function. I want to calculate and then return the total amount of hours assigned for a given stage_no. I got confused. Do I have to use COUNT(*)? [CODE]CREATE OR REPLACE FUNCTION total_numbers_hours(hours NUMBER, stage_no NUMBER) RETURN NUMBER IS return_val …

Hello everyone, I'm working on a little project that use c#, Oracle ODT and asp.net, so, my problem is that i dont know how to convert or store the data retrieved from a sql that is a sequential and then use in other query in the same project. This is …

Hello I found this : [CODE]INSERT .... ON DUPLICATE KEY ...[/CODE] What does [B]'ON DUPLICATE'[/B] mean ? Thank you

[CODE][/CODE]I was having trouble wording my title. I'll try my best to describe my problem. I'm a SQL newbie, so go easy on me.. I'm trying to match records that "doesn't exist" between two relational tables. For instance, if I have two tables. [CODE]Table 1: Client_ID Client_Name Table 2: Purchase_ID …

I am having a table in oracle without a primary key and table is having 5 columns. Every time while making the insert, i have to ensure that the same combination of records are not bing inserted. For every row if a specific value has been inserted then a common …

Hello people, I want to create 'Voyageur' table that references a successfully created table which name is 'Categorie',. But I get this error message when I click on 'run': [COLOR="Red"]ORA-02438: Column check constraint cannot reference other columns [/COLOR] Here is my 'Voyageur' Table that makes me a problem around its …

I have a problem using the oci_execute function in php. I start by initialising my query then oci_parse it and then oci_execute it. Everything works fine. And data are being inserted or modified in my database. The problem is that these data are inserted randomly. If I have a query …

I have a problem making a select tag in php code dynamic. I'm creating a website (homework) using php and connecting to an oracle database which has all the info needed. Each agency has a list of vehicules. I created a select option tag for agencies and for vehicules. I …

what is default size of varchar2 in oracle

Hey All, I am looking to develop a web application on the Java platform with Oracle 11g database. I asked one of the dealers for a quote & the quote is for "20 users". I don't really know how this works, but will I be requiring a license for 20 …

hi! I need to populate a flex combobox with the result query of a oracle db, using coldfusion. I have this code, but it is not functioning: my flex webpage: [CODE] <?xml version="1.0" encoding="utf-8"?> <mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute"> <mx:Label x="230" y="36" text="Selecionar Consolas"/> <mx:Script> <![CDATA[ import mx.events.*; import mx.collections.*; import mx.rpc.events.ResultEvent; …

I need some help to wrote a code in pl/sql that display the most common 10 words from a string...I appreciate any help that comes. Thank you!

I have installed SQLPlus on my ubuntu 10.10 and now I want to install Oracle server.. I was following a tutorial on that and at the end of it, I got lost because I don't have access to certain files that were mentioned in the tutorial and I changed permissions …

I just wanted to know what famous algorithms that you should have in hand? or be familiar with? or That is always used?

Hi, I just want to know from everyone if they have problem on auditing?

Hi guys, hope you can help. I'm creating a mixture of an employee scheduling system with elements of a Human Resource Management System for small to medium businesses. I ideally want to create a java application with a database backend, which I'm trying to see if I can apply sql …

Hi, I have this requirement that I have been trying to solve for a couple of days now. I have this source DB. The objective is to extract data from this source DB and insert into a oracle table. The meta data for both tables are the same (1-1 mapping). …

hi.. i know little bit about the casting in java ie (from "float"to "int" or/etc) like wise my question is how the oracle converts the data in condition this is my sample query branch -t branch_bnk_code number3 branch_brn_code number3 branch_city_code number3 mybranch -t mybranch_bnk_code varchar2 mybranch_brn_code varchar2 mybranch_loc_code varchar2 by …

Hi, I have two tables. Cla_case cc and Cla_event ce. The join between the two tables is on cc.cla_event_no = ce.cla_event_no. In cla_case i have the following columns : Discover_date and Notification_date. In cla_event I have the column Incident_date. I need to perform a SUBQUERY that will find the latest …

The below query is updating all the rows in the table1 eventhough the inner query only selects few of the rows. Any help. Appreciate it. Thanks, UPDATE table1 out SET (col1, col2, col3) = (SELECT col1, col2, col3 FROM (SELECT col1, col2, col3 FROM table1 in, table2 a, table3 b …

Hey everyone, Is this the right way how to make a trigger in Oracle? [CODE] CREATE OR REPLACE TRIGGER "TRI_AMOUNT_REDUCTION" BEFORE INSERT ON "PURCHASE" FOR EACH ROW BEGIN IF (:NEW.CLIENTNO =SELECT C.CNAME, T.CLIENTNO, T.TOTAL FROM CLIENT C, ( SELECT A.* FROM (SELECT CLIENTNO, SUM(AMOUNT) AS TOTAL FROM PURCHASE GROUP BY …

Hey everyone, I'm trying to count all Purchases and find ReceiptNo the ones that start with '434'.. [CODE] Select count(p.purchaseNo) from purchase p (select INSTR(TO_CHAR(p.recceiptNo), "434") >= 10; [/CODE] But this line doesn't only select all receipt number starting with 434.. it selects all receipt no that has 434 in …

Can anyone see anything wrong with this statement? [CODE] CREATE OR REPLACE VIEW V_DEPT_AMOUNT AS SELECT DEPTNO AS DNO, DNAME AS DNAME, MAX(AMOUNT) AS MAX_AMOUNT, AVG(AMOUNT) AS AVG_AMOUNT, MIN(AMOUNT) AS MIN_AMOUNT, SUM(AMOUNT) AS TOTAL_AMOUNT FROM DEPT D, EMP E, PURCHASE P WHERE D.DEPTNO = E.DEPTNO GROUP BY DNAME, DEPTNO; [/CODE] …

hi i have the table in which date valve is like this [COLOR="Red"]11/11/2009 6:08:29 AM[/COLOR] how can i compare the value or select them , the to_date is working in SELECT but,i want to select the records using this colmn and by giving value ie:[CODE]SELECT * FROM SENTMAIL WHERE SENTMAIL_SENT_DATE='01-OCT-2011'[/CODE] …

Hi All, Is there any Mechanism similar to "Oracle AdvancedQueue" in Altibase database...? Any one have idea about Altibase database please help. Any help will be appreciated. Thank You.

I'm download oracle Database 10g from oracle web site , how i can install it On Ubuntu by details plz

I made a basic JUnit test to set up this oracle database on my computer with hibernate. The database works and everything, but trying to hook it up to Hibernate is proving to be a challenge. My config file is below: [code] <hibernate-configuration> <session-factory> <!-- Database Connection Properties --> <property …

hey everyone, I'm trying to get my head around this Question but it is not making that much sense .. Each receipt is issued from a receipt book whose number is encoded in the first three digits of the ReceiptNo field in the PURCHASE table. For example, the receipt numbered …