Data dodania Pytanie
2017-04-10 16:04 CASE statement with LIKE during LISTAGG Operation »
+-----------+------------+-----------+-----------+ | Person_ID | First_Name | Last_Name | Igroup_ID | +-----------+------------+-----------+----------...
(2) odpowiedzi
2017-04-10 08:04 How to find longest consecutive result set? »
SELECT team1, score1, score2, team2, gameDate FROM GAMES WHERE team1 = 'Tottenham Hotspur' OR team2 = 'Tottenham Hotspur' ORDER BY gameDate ASC;...
(2) odpowiedzi
2017-04-09 18:04 Invalid conversion requested, oracle.jdbc.driver.T4CVarcharAccessor.StringToNUMBER »
I am using oracle 12c with hibernate-core 5.0.1.Final. Table sturcture as follows create table tracer ( id number(10,0) generated as identity, cr...
(0) odpowiedzi
2017-04-09 13:04 Oracle SQL: How to eliminate redundant recursive calls in CTE »
The below set represents the sales of a product in consecutive weeks. 22,19,20,23,16,14,15,15,18,21,24,10,17 ... weekly sales table date ...
(0) odpowiedzi
2017-04-09 00:04 Oracle ORA-01031: insufficient privileges while creating user »
I have created a user, let's call him C##USER from sysdba. Now, I'm trying to create another user from C##USER. Problem is I keep getting the followin...
(1) odpowiedzi
2017-04-08 13:04 Calculate null and not null count for 3 columns in an Oracle table »
I have 3 columns in a table: v_type1|v_type2|v_type3 These columns can contain NULLs. What I need is to calculate the number of NULL and NOT NULL v...
(2) odpowiedzi
2017-04-08 08:04 Why stored procedure cannot be used with select, where & having »
Why stored procedure cannot be used with Select, Where & Having? I understand a function can serve the purpose - what's the reason why a stored p...
(1) odpowiedzi
2017-04-08 03:04 finding the server timezone using SQL »
I need to find the server timezone, in this form : UTC: (SIGN)(HOURS):(MINUTES) My code is : SELECT 'UTC' || EXTRACT(TIMEZONE_HOURS FROM CURRENT_T...
(1) odpowiedzi
2017-04-07 18:04 What I am doing wrong in this correlation query in oracle SqlDevelopper »
I'm trying to build a query to select the correlation coefficient as to determine the most rated movie by a user The structure of my table is like t...
(1) odpowiedzi
2017-04-07 12:04 10-digits BigDecimal cannot be saved in NUMBER(10, 2) column »
In a Oracle 12 database, one of my column is defined with NUMBER(10,2). The goal is to store numbers like that one: 12345678.12. Actually, I can store...
(2) odpowiedzi
2017-04-07 09:04 Issue with comparision of day in PL/SQL »
I am working on PL/SQL. Meanwhile, I required to compare whether the date in table is friday or not. I applied the below code but it's still executing...
(3) odpowiedzi
2017-04-06 20:04 for each item in list, oracle pl/sql »
I have a query: select sq1.* from ( select * from table1 where type = '1' order by name ) sq1 where rownum <= 10; but I have to run ...
(1) odpowiedzi
2017-04-06 16:04 How to parse soap response using plsql oracle apex »
I was trying to parse a xml response, but getting no data found.Code given below.Anyone please help me WITH DATA AS (SELECT '<soap:Envelope x...
(1) odpowiedzi
2017-04-06 09:04 DELETE .. RETURNING rowid in JOOQ not working »
I have an oracle database, and am trying to delete a record based on the client number, with the query returning the rowid of the deleted record. Whe...
(1) odpowiedzi
2017-04-05 17:04 How is SQL Injection Possible When Using Bind Variables? »
How is SQL injection possible when using bind variables? My DBA says that using bind variables doesn't fully secure one against SQL injection, but I ...
(5) odpowiedzi
2017-04-05 08:04 SQL WHERE and LIKE clause duplicated »
Hi guys I'm new to SQL and trying to learn it by myself. I have the following questions when I did the tutorial questions in sqlzoo website. Assume I ...
(6) odpowiedzi
2017-04-05 00:04 Oracle CASE STATEMENT WITH SUM »
I'm having trouble return the correct information with my select statement table: name1 | name2 | amount ------ | ------ | -------- Fred | Fred ...
(2) odpowiedzi
2017-04-04 20:04 Oracle - How to cast a reference to subtype? »
I am using Oracle DB and I have this type with subtypes: CREATE TYPE t_foo AS OBJECT (id INTEGER) NOT FINAL; CREATE TYPE t_foo1 UNDER t_foo() NOT FI...
(1) odpowiedzi
2017-04-04 18:04 Cumulative Compoud Interest Calculation(Oracle Database 11g Release 2) »
I have a requirement to calculate rolling compound interest on several accounts in pl/sql. I was looking for help/advice on how to script calculate th...
(1) odpowiedzi
2017-04-04 13:04 Oracle sql. Compare two tables to find missing data »
I have 2 tables: Operator (id, name, product_id) Product (id) Operator table contains this data: | 1 | Op1 | Pr1 | | 2 | Op2 | Pr2 | Produc...
(3) odpowiedzi
2017-04-03 18:04 Counting inner joined query »
I have two tables one with 'Avatars' and one with 'Children' the children table holds values of parent avatar ID and of child avatar ID. I'm trying to...
(3) odpowiedzi
2017-04-03 15:04 Find consecutive dates spanning a weekend »
I have a job list that indicates the work performed on any particular job. When work is done during the day then just one record is added and a work_t...
(4) odpowiedzi
2017-04-03 09:04 How to pass values to IN operator dynamically? »
I want to create a procedure which accepts an array list for IN operator. For eg: Create or Replace Procedure Test (a Arraylist) { Select * from ta...
(1) odpowiedzi
2017-04-02 17:04 How to Merge fields after query, i know CONCAT, but not this way »
I know the way to merge field in MySQL: CONCAT( ) Oracle: CONCAT( ), || SQL Server: `+ but... I wanna merge AFTER query, is it possible? ...
(1) odpowiedzi
2017-04-02 17:04 optimizer always full scans table eben though fething only 3 rows »
I have a table foo which was created like this. CREATE TABLE foo AS SELECT * FROM all_objects; CREATE INDEX foo_I1 ON foo(owner,object_type,status);...
(1) odpowiedzi
2017-04-02 09:04 Oracle database not recognizing type when using procedure »
I declared my types in the package header: file_2.sql CREATE OR REPLACE PACKAGE MY_UTILS IS TYPE VECTOR IS TABLE OF PLS_INTEGER INDEX BY PLS_INTEGER...
(1) odpowiedzi
2017-04-02 09:04 Compare the column values and update another column in Oracle »
I have a scenario where we have first two entries for each test. Meaning for each test we have two entries, now I want to compare the test ranks and u...
(3) odpowiedzi
2017-04-01 17:04 ORACLE SQL PASSWORD FUNCTION »
Need to create a function that verifies a password (more than 5 characters, different from the previous one, it isn't neither "password" nor "123456")...
(2) odpowiedzi
2017-04-01 13:04 Why I can't create an index on temporary table? »
First I created a temporary table CREATE GLOBAL TEMPORARY TABLE TMP ON COMMIT PRESERVE ROWS AS SELECT * FROM A then INSERT INTO TMP SELECT * FROM ...
(2) odpowiedzi
2017-04-01 12:04 to find minimum missing number in oracle »
i want to find the minimum missing number of a column named (s_no) and the table named (test_table) in oracle and I write the following code.. select...
(3) odpowiedzi
2017-03-31 21:03 How to grant privilege for an Oracle trigger to access a function from other schema »
I have a problem that I try to call functions from a trigger. This function is from a different schema. I granted privileges for the user of the trigg...
(1) odpowiedzi
2017-03-31 09:03 CFQuery not saving time portion to Oracle Datetime field »
I am having a problem using a datetime field in an Oracle database with Coldfusion with and don't know how to solve it. I have a table (Subject) whi...
(1) odpowiedzi
2017-03-31 04:03 Which method is better when I want to search the min and max result in oracle? »
I have a table called student,I want to get the max and min score,so I write the sql in first way: select max(score),min(score) from student; and t...
(2) odpowiedzi
2017-03-30 22:03 Oracle 11g: How to dynamically select multiple columns into BULK COLLECT »
I have a query like the example below where I want to dynamically bulk collect 2 columns using a join into from a table that has 4 columns, but I kee...
(1) odpowiedzi
2017-03-30 21:03 PLSQL - Creating procedure with parameter, but only allowing 2 values »
First off, I'm a DBA that dabbles in PL/SQL Programming. I have some knowledge, but some is most certainly lacking. CREATE OR REPLACE PROCEDURE TR...
(3) odpowiedzi