Data dodania Pytanie
2017-09-23 20:09 Is an anti-join more efficient than a left outer join? »
A comment on this answer notes that anti-joins may have been optimized to be more efficient that outer joins in Oracle. I'd be interested to see what ...
(2) odpowiedzi
2017-09-23 17:09 in Oracle SQL-Trace: how can I group a set of SQL executions when the code is not instrumented? »
I have an oracle-10046—aka. sqltrace—file similar to this structure: Oracle Release 11.2 PARSING IN CURSOR #1 len=20 dep=0 uid=7 oct=6 lid=7 tim...
(1) odpowiedzi
2017-09-23 15:09 Its saying I have no row selected? »
It's saying I have no row selected. This is the question: Find the member ID, last name, and first name of the members who have never borrowed any bo...
(1) odpowiedzi
2017-09-22 16:09 Fastest way of testing for a NULL field »
I use two different ways of checking whether a database field column_b is not NULL. Which is faster and why? First query SELECT * FROM my_table WHER...
(2) odpowiedzi
2017-09-22 12:09 oracle DB - joining with a messy string »
I am trying to join two tables in oracle: Table 1 Jira ID|bugz url(string) -------|--------- 1234 |http-url-897654 1235 |http-url-158974 1236 ...
(2) odpowiedzi
2017-09-22 11:09 Can I use where clause instead of AND in given SQL query? If yes, whats the difference in both? »
Came across this query online some where, explaining inner join with a condition (incentive>3k).Was just wondering if I can use where clause instead o...
(4) odpowiedzi
2017-09-21 21:09 Extract date from a column of type date in SQL/ORACLE »
I've a column of type DATE. How can I compare it with hours field of SYSDATE to perform some operation? Column name: DateColumn - of type DATE Requi...
(3) odpowiedzi
2017-09-21 13:09 Join tables based on Aggregate Function result »
I have a small issue related to joining two tables based on the result of SUM().Following are my tables. Customers Table CUSTOMERID NAME AGE ...
(1) odpowiedzi
2017-09-21 00:09 How does an Oracle table know which sequence it is associated with? »
I want to know how an Oracle table (or column) knows which sequence is used or applies to that specific table (or column). ...
(2) odpowiedzi
2017-09-20 20:09 Select query for Converting Oracle Rows to Columns »
I have the below table ID-----Name------Value 1 City New York 1 Country USA 2 City Barcelona 2 Country Spain Desi...
(2) odpowiedzi
2017-09-20 17:09 Kafka Connect JDBC sink to Oracle task FAILED »
I am trying to sink data from Kafka avro topic to an existing Oracle database table I created beforehand. I run Kafka Connect in distributed mode (3 w...
(1) odpowiedzi
2017-09-20 15:09 UNION and NOT EXISTS throws Error »
I have a table which contains city name in both English and french name only if the name are different else it will have only English name. NOTE. Geoc...
(2) odpowiedzi
2017-09-19 13:09 Oracle sql query to group consecutive records by date »
With the below sample data, I am trying to group record with same rate. id start_date end_date rate --------------...
(1) odpowiedzi
2017-09-19 11:09 Oracle | query output separated with semicolons »
I am spooling to .csv files some values from an oracle table. Each value must be separated with semicolon. The query that i retrieve the data from is ...
(1) odpowiedzi
2017-09-19 09:09 Oracle SQL "EXECUTE IMMEDIATE" ORA-00922/06512 Create Table »
i searched a lot and many people got similar problems, but nothing seemed to match. This is no problem: create table CUSTOM_WORKFLOW_ID_COUNTER ( ...
(2) odpowiedzi
2017-09-18 21:09 When querying against a view, a filtering clause in the view's definition is being ignored »
I have a table SCHEDULES with columns LDATE and SCHTYPEID. If SCHTYPEID = 1, then LDATE contains dates in a numeric format (e.g., 20170918 for today's...
(3) odpowiedzi
2017-09-18 21:09 How to display last 12 months of data in proper order in SQL »
I want the count of last 12 months records group by MM-YYYY. select to_char((SCHEDULED_START_DT), 'MM-YYYY') , count(*) from XYZ where SCHEDULED...
(3) odpowiedzi
2017-09-18 07:09 Wrong implementation of Oracle Java ConcurrentHashMap? »
I am testing ConcurrentHashMap on Oracle's Java 8 implementation: ConcurrentMap<String, String> concurrentMap = new ConcurrentHashMap<>()...
(2) odpowiedzi
2017-09-17 15:09 How to check audit trail size and flush or truncate audit trial? »
We have Oracle database in our startup company and there is only 1GB space is left in the entire database, It will be occupied soon so What should be ...
(1) odpowiedzi
2017-09-17 08:09 SQL update values based on join »
I'm trying to update values of one table based on criteria of second table. But something is wrong. Can you advise what I'm a doing wrong? UPDATE foo...
(3) odpowiedzi
2017-09-17 03:09 SQL: Retrieve all records where has all joined »
Sorry, couldn't think of a better title. I have 3 tables in Oracle XE. An EMPLOYEE table a PROJECT table and a WORK_ON table. An EMPLOYEE can WORK_ON...
(2) odpowiedzi
2017-09-16 17:09 execute immediate in creating a table PL/SQL »
I would just like to ask why this code does not create the table? BEGIN EXECUTE IMMEDIATE 'create table temp1 as (select * from table)'; COMMI...
(1) odpowiedzi
2017-09-16 13:09 how find two consecutive days late comer employee in oracle PL SQL »
My main table contains clock-in is TAD_REGISTER_VIEW. The table is massive so I just pick one specific employee with id 004634 and showing its record...
(1) odpowiedzi
2017-09-16 03:09 Join check view with a calendar view »
I have two views. One with checks: Check_Id Issued_Date Cleared_Date Amount 1 2017.01.03 2017.02.04 100 2 2017.03....
(1) odpowiedzi
2017-09-15 11:09 Oracle equivalent for java's System.nanoTime() »
Is there any equivalent for java's "System.nanoTime()" in oracle? In java System.nanoTime() returns something like "246193102011083". ...
(1) odpowiedzi
2017-09-15 11:09 SQL-Oracle Update table from itself using LAG() »
Lets assume we have a table like this one: | Year | Month | Day | ID_Office | Operations | Operations yesterday | |------|-------|-----|-----------|-...
(3) odpowiedzi
2017-09-15 11:09 How can I combine multiple query? »
I have some queries like that: select sysdate from dual; select id, count(*) as A from TABLE1 group by id; select id, count(*) as B from TABLE2 group...
(2) odpowiedzi
2017-09-14 17:09 SQL Statement not working when executed through procedure »
Trying execute the below query through a procedure. The query runs well when i run it manually with single quotes in toad, but facing error while ru...
(1) odpowiedzi
2017-09-14 13:09 SELECT ALL... in Oracle SQL »
I was researching packages from DB, when I saw following query: SELECT ALL TABLE1.CODE, nvl(TABLE1.EXPLANATION, '') as Explanation FROM TABLE1; I ...
(1) odpowiedzi
2017-09-14 10:09 Oracle get last 10 days sql »
I need to get the last 10 days from now on I currently have following Oracle sql query to get the last 10 dates. WITH DATES AS ( SELECT sysdate - 1...
(2) odpowiedzi
2017-09-13 21:09 ActiveRecord is not reloading nested object after it's updated inside a transaction »
I'm using Rails 4 with Oracle 12c and I need to update the status of an User, and then use the new status in a validation for another model I also nee...
(0) odpowiedzi
2017-09-13 19:09 SQL Server tracking changes in data coming from Oracle link »
I have a SQL Server table that I create by selecting from an Oracle view using a database link. The Oracle database is fully wrapped and comes from an...
(0) odpowiedzi
2017-09-13 17:09 Why is DISTINCT on 3 identical values so slow? »
I have a performance issue that I cannot understand in on of my queries. The query I am executing is the following: SELECT UNIQUE GROUP_ID FROM pos...
(2) odpowiedzi
2017-09-13 13:09 What is the difference between (*) and .* in regexp? »
.* is any character zero or more number of times. I was trying to find words starting with vowel and i used ^[aeiou](*) And it gave me all words s...
(2) odpowiedzi
2017-09-12 22:09 Oracle make column only editable by trigger »
We're at an impasse here trying to figure this out. We have triggerA that updates myColumn from tableB, but we don't want our application users to be...
(3) odpowiedzi