Data dodania Pytanie
2017-04-22 13:04 Oracle sql constraint questions »
I'm having problems with creating a oracle sql script. How do I create these two constraints? If VID is null then FID has to be null as well (VID = ...
(2) odpowiedzi
2017-04-22 09:04 Listener refused the connection »
I am having a problem while configuring a hibernate application. Please could you help me with this. I searched a whole lot of forums but could not fi...
(0) odpowiedzi
2017-04-22 04:04 Sometimes, error "ORA-00933" occurs when using entity framework to query to Oracle DB but when I restart the webapp, it works »
I have used Entity Framework 5 for Oralce Database of web-based application. Sometimes (rarely happens), error "ORA-00933" occurs but when I restart t...
(0) odpowiedzi
2017-04-21 17:04 How to select an entry and exit record for each user from same table »
I have the following table R_ID DATE Col_A Col_B Col_C 158 20161008 01 99 99 158 20161012 01 01 99 158 201610...
(3) odpowiedzi
2017-04-21 09:04 Oracle Regular Expression-To match an exact word »
I need to search in a column named DESCRIPTION in a table which match the exact word ICE, Ice or ice. There may be other words before or after the key...
(2) odpowiedzi
2017-04-21 01:04 Oracle SQL - Select First n Distinct Rows »
In Oracle 12, we finally have a limit feature, so we can simply select distinct columnname from mytable fetch first n rows only; However, I am pres...
(2) odpowiedzi
2017-04-20 23:04 Oracle SQL - Query Time Limit »
In a similar fashion to how select * from mytable where rownum <= 1000; will give me the first 1000 rows of results of a query, is there a way t...
(1) odpowiedzi
2017-04-20 23:04 How to catch TO_TIMESTAMP or TO_DATE exceptions in PLSQL without an OTHERS clause? »
I noticed that TO_TIMESTAMP raises a variety of error codes depending on how it failed; --01847 select to_timestamp('2016-01-0a', 'yyyy-MM-dd') from...
(1) odpowiedzi
2017-04-20 17:04 Oracle Rank() within (sub)group »
I am trying to get the correct rank within a subgroup and am having problems with the outcome. I need to get a rank of each time the group changes bas...
(1) odpowiedzi
2017-04-20 11:04 Using JRuby with Oracle Database to populate a database »
I am looking to populate a database using jruby. I followed the instructions here and I have updates and queries working great. My issue is with the i...
(1) odpowiedzi
2017-04-19 19:04 Purpose of Self-Joins »
I am learning to program with SQL and have just been introduced to self-joins. I understand how these work, but I don't understand what their purpose ...
(4) odpowiedzi
2017-04-19 13:04 How to Get the Shorthest Path in a Flightroutes-Table »
I have trouble in getting a statement to get all stopovers on a flight. I have table with flightroutes as below, which has a source-airport and a des...
(3) odpowiedzi
2017-04-19 00:04 Oracle SQL Get unique symbols from table »
I have table with descriptions of smth. For example: My_Table id description ================ 1 ABC 2 ABB 3 OPAC 4 APEЧ I need to g...
(3) odpowiedzi
2017-04-18 12:04 oracle: sort by date and timestamp »
I select some data from three tables using union then I would like to sort them by date and timestamp (descending): select reportname as name, conve...
(3) odpowiedzi
2017-04-18 12:04 Hierarchical query find all parents with some filters »
I've a structure like: CREATE TABLE BUSINESS_UNIT ( ID NUMBER, DESCPRIPTION VARCHAR2(100 CHAR), TAG VARCHAR2(10 CHAR) ); CREATE TABLE USERS ( ...
(1) odpowiedzi
2017-04-18 07:04 Can adding FK or PK constraints invalidate something? »
I have a couple of tables with primary-foreign key relations but those constraints do not actually exist. Now I want to add them with an alter table ...
(1) odpowiedzi
2017-04-17 21:04 I have 2 tables I am looking to join, with no common column, but the information is needed »
I need to return the name and salary grade of each employee. I have two tables, Employee and Salgrade. Employee is set up this way - CREATE TABL...
(1) odpowiedzi
2017-04-17 21:04 How to migrate Spring Boot JMS from ActiveMQ to Oracle Advanced Queueing »
I'm studying the Spring Boot and JMS example and yes, I'm rather new on this Since we work with Oracle, I would like to migrate the Spring Boot &...
(1) odpowiedzi
2017-04-17 19:04 ORACLE SQL: Build a CASE statement with SUBSTR »
The Select statement below is returning the columns attached. At this point everything is good, but I still need to add a few checks. I need to: IF ...
(2) odpowiedzi
2017-04-16 23:04 Theoretical evaluation of SQL query cost »
I need to evaluate a SQL query in theory by analyzing the results and the number of lines looked upon. Any link to information online is welcomed as I...
(1) odpowiedzi
2017-04-16 17:04 How do I combine two working SELECT queries into one query? »
I have two queries which work independently of one another; SELECT e.employee_id, e.first_name, e.last_name, e.job_id, ...
(3) odpowiedzi
2017-04-16 12:04 Find Maximal Value of other Rows per Group »
I have a simple table with values (ID) in groups (GRP_ID). create table tst as select 1 grp_id, 1 id from dual union all select 1 grp_id, 1 id from d...
(2) odpowiedzi
2017-04-15 18:04 I want to insert random gender(M or F) values into a table in Oracle »
CREATE TABLE USERS (Email varchar2(30) CONSTRAINT UserKey PRIMARY KEY, First_Name varchar2(30), Last_Name varchar2(30), Password varchar2(15), Dat...
(1) odpowiedzi
2017-04-15 17:04 SQL select min() using SQL join »
I need result like this (in Oracle SQL): Name Producer Min Price HDD 250 gb Western Digital 6000 HDD 500 gb C...
(1) odpowiedzi
2017-04-15 16:04 What is PSEUDO in V$PROCESS? »
I'm Oracle Database beginner. I read throughout Oracle reference, thought I cannot find an explanation of PSEUDO when I query V$PROCESS tables. What...
(1) odpowiedzi
2017-04-14 21:04 How to get 2 greatest field between multiple field? »
I'm trying to figure out how to get 2 highest value from 5 fields, I know about greatest function though, don't realize how to reach out second highes...
(3) odpowiedzi
2017-04-14 08:04 Fastest way to compare millions of rows in one table with millions of rows in another »
I want to compare two tables with million of records in each table and get match data from the comparison. To get the match data from both the tables...
(2) odpowiedzi
2017-04-14 07:04 How to fill missing values using analytical functions? »
I would like to fill missing null values from my dataset. I have a data set like this +---------------------+------+-------------+ | ORDER_DATE ...
(3) odpowiedzi
2017-04-13 17:04 Oracle SQLDeveloper: How to get a condensed list of Unique values based on YEAR range »
I have a table that consists of 4 columns: NAME, STARTYEAR, ENDYEAR, IDNUM How do I get a distinct list where the STARTYEAR is the MIN year for that ...
(1) odpowiedzi
2017-04-13 15:04 Do I have to change my database user password in this situation? »
Ok I know this is a stupid question but our one and only DBA get into a mess with our manager and rage quit today. As a small company, I (IT support ...
(0) odpowiedzi
2017-04-13 12:04 Is it safe and possible to recover oracle dump with cycle dependencies? »
Suppose there are 2 schemas A and B: B defines several views from A tables A defines some triggers which use functions from B schema. Is it safe t...
(1) odpowiedzi
2017-04-12 17:04 in node.js, SQL command not properly ended at Error(native) »
I'm using oracle in node.js, and I want to insert my sql query. I tried to insert my query, but i can't insert. This is my error: Error: ORA-00933...
(0) odpowiedzi
2017-04-12 15:04 Error(30,11): PLS-00103: Encountered the symbol UPDATE error »
While creating below SP I am getting the error as Error(30,11): PLS-00103: Encountered the symbol "UPDATE" when expecting one of the following: ...
(1) odpowiedzi
2017-04-12 14:04 Shorten SQL statement not using a common table expression »
The SQL below is written to return 'open orders'. This was written in a way I could understand but now I would like to try and optimize this and reduc...
(1) odpowiedzi
2017-04-11 17:04 JdbcTemplate - Insert or update Oracle BLOB using SQL MERGE »
Using JdbcTemplate I would like to call MERGE SQL statement which will insert a new record to the table or update if row with specific key already exi...
(1) odpowiedzi