Data dodania Pytanie
2017-11-30 06:11 Check equals between multiple columns values in a row? »
quick question here I have a table like this COLUMN_1 COLUMN_2 COLUMN_3 COLUMN_4 COLUMN_5 SAME X1 X1 X1 X1 X1 X1 X1 ...
(4) odpowiedzi
2017-11-29 22:11 Would null value change the average? »
What will be the result of this query? (Oracle SQL) SELECT TO_CHAR(AVG(TEST_SCORE),'999,999.99') FROM SCORES; If the values of TEST_SCORE are (...
(2) odpowiedzi
2017-11-29 22:11 Query from a function »
I have this query Select distinct a.name, p1.ref as book, p2.ref as text, p3.ref as note from library a left join room p1 on a.id=p1.id left join r...
(1) odpowiedzi
2017-11-29 21:11 Converting Oracle to MySQL : Different Outputs Seen »
I have an SQL query from Oracle which I am trying to convert to MySQL. Below is part of the query from both. The database structure is different henc...
(1) odpowiedzi
2017-11-28 22:11 How to display an attribute from one table using an ID from another »
I have the following tables in an Oracle database: CREATE TABLE Team ( teamID INT NOT NULL, teamName VARCHAR(50), wins INT, losses INT, ...
(1) odpowiedzi
2017-11-28 15:11 Oracle order. First letters and after numbers »
I have a Spring Boot appl. that uses JdbcTemplate to access an Oracle DB I am working on a Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 -...
(1) odpowiedzi
2017-11-28 08:11 ORACLE (11.2.0.1.0) - Recursive CTE with a date expression »
The right answer on the following question: That is a bug that was fixed in 11.2.0.3 or later if I recall correctly. (11.2.0.1 is no longer supporte...
(2) odpowiedzi
2017-11-27 17:11 Oracle SQL using Like and wildcard »
I am using the following query to find the names of tables in my database: SELECT table_name FROM user_tables WHERE table_name LIKE 'APP_X_%' ...
(1) odpowiedzi
2017-11-27 12:11 Oracle : Query Runs Successfully, but the column name is not available »
In our application Oracle(11g and 12C), I'm facing a weird Issue as below. When I run the below query in Oracle DB it runs successfully and gives m...
(1) odpowiedzi
2017-11-27 10:11 Oracle, SQL, how to get intervals between dates »
I need help with a problem. Actually, I do not know if it will be possible to solve it directly in SQL. I have a list of works. Each work has a start...
(3) odpowiedzi
2017-11-26 22:11 Do not connect oracle database with PHP through PDO »
I want to connect the oracle Schema database by default that comes in the oracle bd through PDO with php but it throws me this error: Fatal error:...
(1) odpowiedzi
2017-11-26 13:11 Oracle Connection Pooling in .Net »
We have a system that uses an Oracle database. I've been asked if the system makes use of connection pooling which I'm not sure about. We are using ...
(1) odpowiedzi
2017-11-26 05:11 Using COUNT(*) and INTO oracle sql »
I have select statement like this: with input as (select id,date,quantity from abc a,xyz z .......) select count(*) ...
(1) odpowiedzi
2017-11-25 13:11 SQL Query JOIN on the same table for a given data »
I have the following table and data: CREATE TABLE TEST_TABLE ( ID NUMBER(6) NOT NULL, COMMON_SEQ NUMBER(22), NAME VARCHAR(20), CONSTRAINT PK_...
(2) odpowiedzi
2017-11-25 12:11 How to "flatten" the structure with the TABLE expression »
I have a VARRAYS TYPE wanted to "flatten" the structure with the TABLE expression. The example data CREATE OR REPLACE TYPE ARIS.NUMBER_VARRAY_5 AS ...
(1) odpowiedzi
2017-11-25 01:11 PL/SQL ORACLE: Trigger updates on delete »
I am trying to make a trigger that increases the booked value and decreases the available value whenever new record is inserted inside the table ticke...
(1) odpowiedzi
2017-11-24 09:11 Timezone region not found »
I'm creating a C# MVC project that uses Oracle Database. While trying to connect to the DB, I get following error: ORA-00604: error occurred at re...
(2) odpowiedzi
2017-11-24 07:11 Find each position of same characters in a string through SQL query »
Below is my data set Year Month Holiday list ---------------------------------------------------------- 2007 1 WWHHWWWW...
(2) odpowiedzi
2017-11-24 05:11 Could not remove unicode character »
I have a text string in Oracle table ("NGUYỄN NGỌC HOÀNG"). I have tried to replace the Unicode string (my expected result is "NGUYEN NGOC HOANG"...
(3) odpowiedzi
2017-11-23 15:11 SQL Request : Count with group by and total to make a percentage on the same line »
I'm currently blocked on a simple request... : I have this database : order | couple | first | second ------------------------------- 1 | A-B ...
(1) odpowiedzi
2017-11-23 11:11 ORA-00917: missing comma on DATE column »
I had come across many queries similar to the mentioned title. But my situation is quite different. I am trying to run the INSERT command for a table ...
(1) odpowiedzi
2017-11-23 10:11 What data type should a time difference column in oracle sql be? »
Hey so I have a database where i have a started and a completed timestamp. Now I need a third one for the time difference which I want to set by calcu...
(2) odpowiedzi
2017-11-23 08:11 Sales Order UOM different with Shipping Transaction in oracle shipping »
I need your expertise to solve my issue. My Issue is , I Input Sales order Item with Carton as Unit of measure (UOM). But when I go to Shipping Trans...
(0) odpowiedzi
2017-11-22 14:11 Is a 3 column SQL index used when the middle column can be anything? »
Trying to prove something out currently to see if adding an index is necessary. If I have an index on columns A,B,C and I create a query that in the...
(2) odpowiedzi
2017-11-22 09:11 Executing a stored oracle procedure in R using ROracle »
I'm having trouble executing/calling an Oracle procedure in R via ROracle. I've tried many different ways of calling the procedure and I keep getting ...
(2) odpowiedzi
2017-11-22 00:11 Select top N columns based on standardized values »
Got a bit of googly question. Is it possible to select say 10 columns based on the values in each column if all the values are standardized. So for ...
(2) odpowiedzi
2017-11-21 18:11 Oracle command, meaning of the part after sysdba »
Can someone please tell me what does it mean @test.sql in the Oracle command: sqlplus sys/pw@somedb as sysdba @test.sql ...
(1) odpowiedzi
2017-11-21 18:11 Find SSN with same digit including dash using oracle REGEXP_LIKE function »
I am trying to filter out SSNs having same digits with dash (-).Meaning all digits in SSN are same and follow xxx-xx-xxxx format. Examples: Correc...
(2) odpowiedzi
2017-11-21 08:11 Oracle Database PLSQL Subtype of certain characters »
I want to make a subtype in PLSQL which can only hold this values: '♠', '♥', '♦', '♣' Is this possible? In my code I have subtype suit_t is ch...
(1) odpowiedzi
2017-11-20 18:11 How to spool separate queries to same file without a page break? »
I am trying to run multiple separate queries in one script using SQL*Plus and spool the output to a file. It is currently spooling out, but it is inse...
(1) odpowiedzi
2017-11-20 10:11 how to select number and convert number from English to arabic in oracle »
i have table and the data like this and i need to select this data but i need it to be like this how to convert the number from English to arabic ...
(1) odpowiedzi
2017-11-20 04:11 PIVOT function with String columns return wrong output result »
I have two tables named class_record_hist which will store the attendance entry of a class for a particular date student_record_hist which will st...
(1) odpowiedzi
2017-11-19 23:11 ASP.NET Single Text Box Multiple Keyword Search »
Right now, I have: Upper(tb.name) LIKE Upper('%' + :SearchBox + '%') With this, I can type a single keyword and if it exists in tb.name, it will re...
(2) odpowiedzi
2017-11-19 19:11 Convert Oracle query to SQL Server 2008 »
I am facing a problem to convert an Oracle query to its SQL Server 2008 version. In this Oracle query LISTAGG and connect by prior are used. I researc...
(1) odpowiedzi
2017-11-19 10:11 Split IPv4 address into 4 numbers in Oracle sql »
I'm trying to split a given IPv4 address into four numbers. In SQL Server this query works well for me: select CAST (PARSENAME('10.20.30.40',4) AS ...
(3) odpowiedzi