Hi, I have the following table: SQL> desc recording Name Null? Type -------------------- -------- ------ CAPTUREID NOT NULL NUMBER(9) STARTDATE NOT NULL DATE ENDDATE DATE STATE NUMBER(1) ESTIMATEDENDTIME NUMBER(13) Here's a sing...
I am using Oracle 10.2.0 and I am new with it. I need a sql Statement I have a table with 3 columns. in the column1 are numbers and same of them have equals values in column2 and cloumn3 are String. How can I get the Strings from column2 and column3 together separated with ";" when Numbers from column1 are equals. thanks ...
We are using the web application that was build using Oracle Developer 10g (10.1.2.02). After the Microsoft Outlook 2010 has been installed we started having problems. Now every time we try to access the application, Internet Explorer crashes. Does anyone experiences the same problem ? I would really appreciate if you share your work a...
Hi all, I'm really newbie about Oracle backup operations. I'm really new in this world and I need to know how to backup a DB schema and restore it in another machine under another schema name. I cannot afford any mistake since I'll be doing this in our customer site, an making a small mistake could be the last one I don't want to sou...
Is there anyway to connect on oracle by a proxy user using PDO? ...
Hi, I am trying to build an application (Hello World) in Oracle JDeveloper and run. It ran fine. But it doesn't open in default browser. I edited Tools--> Preferences --> Web Browser and Proxy --> gave C:\Program Files\Internet Explorer\iexplore.exe . It doesn't work. I could not even try preview. Please help me. Thanks, ...
I am trying to write some custom Serializers for an Oracle XSQL Servlet. I'm trying to keep my two serializers within the local .ear because they are still being developed and tested and I don't want to hurt production code. However, I am getting the following error XML-25021: Serializer XLSv2 is not defined in XSQL configuration file ...
Have been writing the shell script such as : #! /bin/bash `sqlplus -s <username>/<passwd>@dbname` set echo on set pagesize 0 set verify off set lines 32000 set trimspool on set feedback off `SELECT tr.number, count(*) as total FROM <dbname>.<tablename1> tr LEFT JOIN <tablename2> t2 ON t2.i...
Hi We have a third party oracle based application, that ships with precompiled binary(wrapped) packages. But when I compile them in Oracle SQL Developer (right click -> compile all), they get invalidated. Is recompiling a safe operation with no side effects? ...
I have huge data which needs to be classifed in to different groups while retrieving. Each group has a different condition. I don't want to retrieve them separately. I want to know the number of items in each group using a single sql statement. For example, the pseudo code will be like this: Select count(IssueID) as Issue1_Count if(...
Greetings: Is there anyway to make an apex report table cell (or even the entire report itself) conditionally read-only in Apex 3.2? I don't see the "read-only" box anywhere in the options; tried searching everywhere. Thanks in advance! ...
(Disclaimer: I changed/obfuscated some of the variable/table/column names here for security reasons. Please forgive me if something looks a little off.) I am building a front-end to an Oracle 10g database, and I'm trying to get paged data. Aside from paging, the following SubSonic 2.2 code gives me what I want, in the order I want it:...
Hi If I write a custom package with nothing but static SQL in it, would it invalidate other package. (other third party packages that were shipped as wrapped code). a co worker suggests that I re write the custom package in Dynamic SQL, and I will not see this problem. I find this hard to believe because the third party packages are not...
Hi, I am kind of new to triggers and cant figure it out how to resolve this. After insert a new row on a specicfic table it should influence other tables aswell. So if I add(insert) an order on a table which includes 3 quantity, I want to be 3 less In_stock in another table(column)... thanks in advance ...
I have two tables: Table A ID ABC_ID VAL Table B ID ABC_ID VAL These two tables are directly related to each other through the ABC_ID column. I want to find all the VAL column values in table A which are not present in table B for the same ABC_ID. ...
SELECT HQRH_BADGENO, HQRH_SHIFT, HQBD_BADGENAME, HQRH_DISCRRECONCILE, HQRH_ADJUSTAMOUNT, HQRH_DISCRADJUSTMENT, CASE HQRH_DISCRRECONCILE WHEN 'HQRH_DISCRRECONCILE <0' THEN 'HQRH_ADJUSTAMOUNT' WHEN 'HQRH_ADJUSTAMOUNT>0' THEN 'HQRH_ADJUSTAMOUNT' WHEN 'H...
Hi... I have a string in the format "dd.mm.yyyy hh:mm".. i need to convert it into oracle date format 'dd-mon-yy'..... How do i make it happen??? ...
I'm trying to support multiple databases for an app that I'm writing. The app mostly uses Hibernate, but it's incredibly inefficient to iterate over millions of rows and process them individually when a DML statement can process them in a fraction of the time. Therefore, for certain operations, I need to work out the SQL. I'm more of ...
I have 2 tables with the following fields. Table1 AA BB CC DD Table2 AA CC EE Query Select t1.*, t2.* from table1 t1, join table2 t2 on table1.DD = table2.EE My data columns back with the following column names: AA, BB, CC, DD, **AA_1**, **CC_1**, EE I don't want the column names like that. I want them to have ...
Hi everyone, I'm attempting to reference a view with a foreign key but I am getting this error: "Error: ORA-02270: no matching unique or primary key for this column-list" However, I have created a primary key on this view and verified it in the Constraints tab in TOAD. This is the table I'm attempting to create: CREATE TABLE QUESTI...