Data dodania Pytanie
2017-04-25 15:04 SQL Server equivalent of Oracle 'byte' »
SQL Server equivalent of Oracle 'byte' I'm looking for the SQL Server equivalent of the Oracle datatype byte. I searched for it in this documentatio...
(1) odpowiedzi
2017-04-25 14:04 Oracle: Fastest way to compare tables containing CLOB and get diff »
Suppose I have two tables with columns, Col1, Col2 and Col3 which are VARCHAR2, CLOB and NUMBER types respectively. How can I get the diff of these t...
(5) odpowiedzi
2017-04-25 01:04 PostgreSQL equivalent of Oracle bulk insert »
Trying to re implement this oracle bulk insert to postgres equivalent. Currently have: a.each do |b| params << [nil, ...
(1) odpowiedzi
2017-04-24 14:04 PHP Fill with values an existing .xlsb file with data from Oracle »
I want to write into my .xlsb excel file which name is the number of the day. For exemple the name of the file for yesterday is 23.xlsb. Initial th...
(1) odpowiedzi
2017-04-24 12:04 calling multiple Oracle stored procedures from Java »
I have multiple stored procedures which are on my DB example: proc1, proc2, ...proc10. I want to call them in a loop from java. What is the best way...
(1) odpowiedzi
2017-04-24 04:04 How to create a trigger to allow both manual and auto primary key in sql developer with oracle 11g »
I am attempting to create a trigger (using SQL Developer with Oracle 11g) that will allow manual insertions onto the primary key, and if a record is c...
(1) odpowiedzi
2017-04-23 21:04 Is it possible to exit a case in Oracle SQL query? »
Suppose I have a table named ABC: Col Val a 1 b 3 c 2 a 3 b 6 c 7 a 5 b 9 c 9 a 7 b 2 c 8 SELECT MAX(CASE WHEN COL = 'a' TH...
(2) odpowiedzi
2017-04-23 19:04 How to put text into SQL select statement »
I have the following problem. We are using ORACLE Apex Application Express. We have database with some information inside. I need to write a SQL selec...
(1) odpowiedzi
2017-04-23 16:04 SQL Triggers, how to copy a value from one column to another while updating the first one »
let's say this is our table of PRICES curP | oldP | ID +------------------+ |210 | null | 1 | +------------------+ I would like to create a t...
(2) odpowiedzi
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