I have created a Java Eclipse app with database tables from Oracle 11g. It works fine but only in my local pc. How can I make these tables work into another pc? Maybe I have to put them in the application folder? The app is connected with the db via
We have a project built on .NET 4.0 framework in Visual Studio 2010. Database is on Oracle 10g server. We are trying to migrate the project to Visual Studio 2015. In the meantime as we encountered Oracle 10g client is not suitable for windows 7 and w
What are the tables and its fields in Trading Community Architecture in oracle R12? I have searched on google for TCA. But I was not able to find out proper table structure on google. Please help.
I'm trying to update a single table in my record using the session.getCurrentSession().save(Bean); And I'm getting this error. I have cross checked my table and column names in my Database with the attributes in my POJO class. The hibernate.hbm2ddl.a
Our requirement is if any 1 of the column name in table is updating we need to insert the column name in another table so I had written this code CREATE OR REPLACE TRIGGER Test AFTER UPDATE ON XX_table FOR EACH Row BEGIN FOR C IN (SELECT column_name
XMLType.transform is outputting different HTML tags on Oracle 12c versus Oracle 11g. 11g: <td align="right"></td> <td></td> <input type="checkbox" onclick="return false;" checked="checked"
How to get datetime in oracle of previous day at specific hour? Say for example today is June 1st and i want to get the datetime of previous day 6pm? i need to go back one day at specific hour. --------------Solutions------------- There is a lot of w
My task is to group similar digits/characters in a given string, For e.g.: The output of the SQL for the string 4455599 should be 44 555 99 and is working with following query: with t(str) as ( select '4455599' from dual ) select listagg(str_grouped
Someone in my team made a mistake during the development of a software. The specs have been correctly written, and well reading but the code wasn't good. The problem was about a primary key... The specs have been written by someone who use SQLDevelop
Query: SELECT * FROM MYTABLE WHERE (custom_date BETWEEN '16-MAR-15' AND '15-APR-15')) pivot(SUM(user_value) FOR custom_date IN(to_date('16/03/2015', 'DD/MM/YYYY') AS day16, to_date('17/03/2015', 'DD/MM/YYYY') AS day17, to_date('18/03/2015', 'DD/MM/YY
I got a problem with something and I don't know if the thing I am doing is right.. or deadly wrong. I am working with the outer-join concept. In my case with all the three of them. As I am typing my query's I get 50% viewable values en 50% null value
I have a procedure which returns a SYS_REFCURSOR as an OUT parameter. What I would like to do is call that procedure, and use that returned SYS_REFCURSOR in another procedure. In this second procedure, I would need to run a GROUP BY on the results, a
I have a requirement where i need to duplicate the present record with data column update to the next date. I have table data like below : cobdate system b_id b_type L_TYPE lode symbol ------------------------------------------------------------ 2015
I am trying to do Code-First development with EF 5.0 and Oracle Data Client 11.2.0. I have been reading online that 12c version of Oracle Client supports Code first but I am wondering if 11.2.0 supports it as well. I got my code to work Database-Firs
My application is using Spring 4, Hibernate 4, Java 1.7. This is a desktop application rather than a web application, so there is no server involved. I'm trying to create a connection to the database. For brevity's sake--I can't copy and paste--I lef
my oracle 11g does not connecting my database while i'm login and in sql*plus i am getting ERROR: Error while trying to retrieve text for error ORA-12154,i export few data from my oracle 8i --------------Solutions------------- this is TNS error.try f
I am trying to install Oracle SOA suite. http://www.oracle.com/technetwork/middleware/soasuite/downloads/index.html So, now when I go to my location where I have my JDK and run the following command http://www.oracle.com/technetwork/middleware/soasui
I am trying to get a count from a table which has 4 columns. The 2 I have included in the pivot_data are 'ocode' and 'cname' the other 2 relate to customer details. I am trying to show how many individual 'ocode' (options) there are for each 'cname'
Hi I am learning ASH and AWR tables but any ideas as to how i can get list of sql, objects and schema owner accessed by a give user in last 30 days ? Basically get all SQL text, and then search within this SQL to see if a given object (table, package