Data dodania Pytanie
2017-01-01 13:01 Gather stats on partition table »
I have table ABC interval partition by each day. Each partition is used in queries for that specific day. Even if i schedule job @nyt each day to gath...
(2) odpowiedzi
2016-12-31 22:12 Oracle Golden Gate sequences »
In Oracle Golden Gate, I'm unable to replicate production sequence to replicate database, since as sequence increased by 1 in production, the count of...
(1) odpowiedzi
2016-12-31 11:12 Ejabberd integration with Oracle database »
I need to integrate ejabberd with Oracle database(don't want to use Mnesia default database). I searched all the ejabberd forums but couldn't find any...
(0) odpowiedzi
2016-12-31 05:12 Uploading a String Array of dates into oracle »
I keep getting the following error when I try to upload my books table through eclipse: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number ...
(1) odpowiedzi
2016-12-30 18:12 Customize Peoplecode App Designer text editor »
I'm writing a lot of peoplecode in Oracle's Peoplesoft Application Designer 8.53 as far as IDE's go its pretty rudimentary but i'd like to be able to...
(0) odpowiedzi
2016-12-30 16:12 Oracle 12c - SQL Loader Invalid month Error »
I'm getting ORA-01843: not a valid month error while loading the data using tab delimited text file with sql loader 11.1.0.6.0 on oracle 12c. contro...
(1) odpowiedzi
2016-12-30 10:12 Generate the URL of a Remote File using PL/SQL »
I created a Concurrent Program that creates an Excel File from a long, parametrized query using PL/SQL. Once the Program successfully completes, the f...
(1) odpowiedzi
2016-12-29 23:12 How to see error logging done by Oracle's DBMS_PARALLEL_EXECUTE Utility ? »
I'm running a procedure in parallel by using oracle's dbms parallel execute utility which chunks the workload ; but I have few chunks failing and I ca...
(1) odpowiedzi
2016-12-29 11:12 How to combine date from one column and time from another »
Currently I'm trying to select a datetime column from two date columns. I'm having the following situation: FROMDATE column which contains dates wit...
(4) odpowiedzi
2016-12-29 10:12 Make Oracle last_day function be compatible with H2 database »
I am writing integration testing and I want to test my sql queries by using a H2 database. In production these queries are running against an Oracle d...
(0) odpowiedzi
2016-12-28 23:12 In SQL: add a column based on before or after date? »
In Oracle SQL Developer, how do I add a column based on whether my date column has a value before or after January 1st, 2010? For example: Date ---...
(3) odpowiedzi
2016-12-28 16:12 Analytic count over partition with and without ORDER BY clause »
I don't understand why there are different results when using an ORDER BY clause in an analytic COUNT function. Using a simple example: with req as...
(2) odpowiedzi
2016-12-28 14:12 Query to omit an entire group which has one record with a certain value in an attribute »
I need to create a personal table based on particular criteria from another table. The records associated with the data are grouped together (based o...
(3) odpowiedzi
2016-12-27 20:12 Improve MERGE performance when using big tables »
Context We have a model in which each element has an element kind and from 0 to N features. Each feature belongs to only one element and has a featur...
(1) odpowiedzi
2016-12-27 18:12 How to select from a single table with a condition across multiple rows of the same column »
I have a table that includes columns for medical numbers and procedures. There are a lot of rows and medical numbers can be repeated with many procedu...
(3) odpowiedzi
2016-12-27 09:12 Running Oracle SQL scripts with Ansible playbook »
A look at the core database modules in Ansible documentation shows no signs of a module for Oracle. What is the best way to handle SQL/PLSQL deploymen...
(1) odpowiedzi
2016-12-26 12:12 How to create a async Oracle job to run in multiple instances »
I have created the next program and subsequent Oracle JOB: BEGIN DBMS_SCHEDULER.create_program (program_name => 'myProg', ...
(1) odpowiedzi
2016-12-26 11:12 select all the rows with the date between 2 datetime columns in Oracle »
Columns in the table are ID Name SDate EDate RNo 1 abc 12/27/2016 12/31/2016 12345 And the result should be...
(1) odpowiedzi
2016-12-26 05:12 How to select a primary key which has exact foreign keys matches a given list of values? »
For example: pk_ref fk ====== === 1 a 1 b 1 c 2 a 2 b 2 d How do I do a query like the "pseud...
(5) odpowiedzi
2016-12-25 15:12 drop check constraint when constraint name is not known »
Is it possible to delete check constraint(no constraint name declared) that is created within CREATE TABLE command? ...
(1) odpowiedzi
2016-12-25 11:12 PL/SQL VALUE_ERROR exception not raised where expected »
I am sure my question has a simple theoretical answer but I cannot find it. I have a procedure which accepts as parameter a NUMBER. It also have the ...
(1) odpowiedzi
2016-12-25 03:12 Insert date works in SQL Developer but not through Java »
I face a problem whenever I want to insert a date from Java to my Oracle database. Here is a sample of my Java code: PreparedStatement prest = myCon...
(2) odpowiedzi
2016-12-24 14:12 Convert Oracle Regexp_replace function into Netezza »
Following Regexp_replace needs to be converted into Netezza Syntax: regexp_replace(COLUMN_NAME,'([[:cntrl:]])|(^\t)|(\s+$)',null) From what i under...
(1) odpowiedzi
2016-12-24 12:12 no Execute Oracle Procedure Java »
JAVA code public boolean userReg(User user) throws SQLException, ClassNotFoundException { Connection conn = null; CallableStatement cs = null...
(1) odpowiedzi
2016-12-24 00:12 Inline view limitations »
SELECT in_ev.type, pl.name, in_ev.year FROM places pl INNER JOIN (SELECT e.type, e.place_id, e.year FROM events e)in_ev ON...
(1) odpowiedzi
2016-12-23 22:12 Connect by return more rows than expected »
I am making a query for retrieving "future months" based on a project's forecast budget. Basically I am taking the last forecasted date (START_DATE) ...
(3) odpowiedzi
2016-12-23 20:12 Oracle Database 12 c , SQL Server Translator Is not Translating query »
I have installed SQLServer Translators as oracle document require to use 12 c jdbc jar so i replace this jar with jdbc jar. I have created transport a...
(0) odpowiedzi
2016-12-23 10:12 Create an Excel File (.xlsx) using PL/SQL »
In relation to my previous question Return the SQL Statement of an Explicit Cursor, i was able to generate an Excel (.xls) file using DBMS_SQL and UTL...
(3) odpowiedzi
2016-12-22 21:12 TROUBLE IN MULTIPLE SUBSELECT QUERY »
I need to find the name, function, officename and the salary of all employee with the same function as PETER or a salary greater or equal than the sal...
(2) odpowiedzi
2016-12-22 15:12 What is the difference between TRUNC and TO_DATE in Hive »
Hi i trying to find out what the difference between using a TRUNC and TO_DATE is in Hive. Currently within oracle I wrote the following case stateme...
(1) odpowiedzi
2016-12-22 05:12 ORA-32795: cannot insert into a generated always identity column »
Guys I am trying to execute below insert statement and I keep getting the error: cannot insert into a generated always identity column the state...
(2) odpowiedzi
2016-12-21 18:12 INNER JOIN performance with '<' or '>' condition »
I have two tables with the column SessionOrder. This column is an integer datatype and have the following index: CREATE INDEX OSIDX_<internal name&...
(3) odpowiedzi
2016-12-21 15:12 Disable all foreign key constraints associated to specific table »
I have table 'MY_TABLE' which has a primary key 'CODE' , this primary key has several foreign key constraints referencing it and I need to disable the...
(3) odpowiedzi
2016-12-21 08:12 Oracle query to fetch the previous value of a related row in same table »
I have a table Student which has name and ratings year wise. Name Year Rating Ram 2016 10 Sam 2016 9 Ram 2014 8 Sam ...
(2) odpowiedzi
2016-12-20 14:12 Multiple rows with null values - i want one row with not null »
My query result below: ID desc Year pid 0006845503 tes1 null null 0006845503 null 2017 nul...
(2) odpowiedzi