Data dodania Pytanie
2017-09-28 10:09 Oracle - Get all characters before the nth occurrence of a character »
I am trying to get a query where I get all characters from a string before the 'n'the occurence of a character. Say I could have the following string...
(2) odpowiedzi
2017-09-27 19:09 Performance issues with outer joins to view in Oracle 12c »
Two of my clients have recently upgraded to Oracle 12c 12.1.0.2. Since the upgrade I am experiencing significant performance degradation on queries u...
(2) odpowiedzi
2017-09-27 08:09 SQL Query for executing a series of update statements »
I have a set of update statements which needs to be executed one after the other. The database that i am using is Oracle and i am running these querie...
(1) odpowiedzi
2017-09-27 06:09 How do I list tnsnames »
Is there any easy way to list out all the available tnsnames in my system via command line? Whenever I need to find out a tnsname, I just simply sear...
(2) odpowiedzi
2017-09-26 17:09 How to connect a rails app to a oracle database? »
I am unable to find step by step instructions on this topic. I want a Rails 5.x app to be able to connect to an Oracle Database. I know that there a...
(1) odpowiedzi
2017-09-26 17:09 Row Number() Order Issue »
Apologies in advance if this specific scenario has been asked previously, but I can't seem to get these to order properly (which is probably from star...
(3) odpowiedzi
2017-09-26 13:09 extract date from pl/sql »
I have some issues while writting a function which return by month, year and the id of a doctor, the number of consultations he did. The problem is:...
(2) odpowiedzi
2017-09-26 13:09 Based on Column Day concatenated with Date as Heading »
I have the data from my table as shown below ╔═════════╦════════════╦══════════
(1) odpowiedzi
2017-09-25 15:09 Select MAX Value for Each ROW - Oracle Sql »
I have one doubt. I need to find what is the latest occurrence for a specific list of Customers, let's say to simplify, I need it for 3 Customers out ...
(2) odpowiedzi
2017-09-25 13:09 Why day in sysdate not working for monday in plsql trigger? »
create or replace trigger trig1 before delete or insert or update on students begin if( To_char(sysdate,'day') = 'monday' then raise_application_erro...
(3) odpowiedzi
2017-09-25 09:09 To Count the occurrence of pattern between specific values in Oracle table »
For example, with the help of below tables, Rn ID Pattern 1 C20 2 C21 3 C25 4 C25 5 C25 6 C25 7 C25 8 C21 9 C23 10 C20 11 C21 12...
(1) odpowiedzi
2017-09-24 21:09 Combining sets+tables+windowfunction in one go »
I want to make something like this work in proc sql: proc sql; %connect_to_sql_macro; create table sql.table as ( select some_id, date from connectio...
(1) odpowiedzi
2017-09-24 14:09 how is possible to rotate data in a sql table? »
i have a an oracle database table that contains these info : name jan feb march april may item1 15 10 45 19 80 i...
(2) odpowiedzi
2017-09-24 05:09 How I can start JDeveloper for BPEL 11g in debug mode. It´s possible? »
For OSB 11g in Eclipse is possible to start weblogic server in debug mode and finally executing the proxy services (adding breakpoints) in debug mode....
(0) odpowiedzi
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