Data dodania Pytanie
2017-06-19 21:06 SSIS insert recrods from Oracle to SQL and even process them »
Thanks for answering... I am new to SSIS and I have below requirement: We are getting bulk records from Oracle based on some criteria. I need to in...
(1) odpowiedzi
2017-06-19 17:06 Oracle sql MERGE INTO with a single where clause »
I have the following SQL code (this is how much I've got so far): MERGE INTO SCHEMA1.TABLE_1 table1 USING ( SELECT DISTINCT table2.colu...
(2) odpowiedzi
2017-06-19 16:06 Oracle SQL - Get same result without using a WITH clause »
I've a query which uses a WITH clause, to be able to calculate some flags (IS_EMPLOYE, IS_AFFILIE) in the SQL result. But I need to find an equivalent...
(1) odpowiedzi
2017-06-18 15:06 What happens to a database session when the user closes the browser tab/windows before the transaction is completed? »
In a webshop scenario where for example a user goes on to press "buy" on his shopping cart, what happens in case he closes his browser window or tab d...
(1) odpowiedzi
2017-06-18 11:06 Adding a user-defined constraint to an SQL table »
So i'm working with 2 tables: Persons and Marriage. Persons hold many attributes and his PK is person_id. Marrige is defined like that: CREATE TABLE ...
(2) odpowiedzi
2017-06-18 08:06 Remove duplicates from first column in Select (not Distinct) in Oracle »
I am new to Oracle. I have a Select as part of a larger query which returns the below result. My problem is that for the first column I only need the...
(2) odpowiedzi
2017-06-17 20:06 ORACLE 12c - "not a single-group group function" »
I have a table o employees that contains names, date of employment and some more information. I want to check which year the most employees were empl...
(4) odpowiedzi
2017-06-17 18:06 SQL query that returns a date »
My DB contains a period(month) and a year - I am trying to convert it to a date. I don't care for the actual day of the month so I have just made it "...
(2) odpowiedzi
2017-06-17 01:06 Select rows with different values on different columns »
I'm new to SQL so this took my a long time without being able to figure it out. My table looks like this: +------+------+------+ |ID |2016 | 2017...
(1) odpowiedzi
2017-06-16 18:06 Sum the results of case statement in a new column Oracle »
I have just started using an Oracle system after learning SQL, querying and RDBMS functionality in MS Access, so please bear with me. I have created a...
(2) odpowiedzi
2017-06-16 16:06 Oracle - optimising SQL query »
I have two tables - countries (id, name) and users (id, name, country_id). Each user belongs to one country. I want to select 10 random users from the...
(3) odpowiedzi
2017-06-16 10:06 Copying Data from Oracle Server to SQL Server »
I'm quite new to coding in general and I'm looking to copy 47 columns with c300,000 rows of data, from an Oracle to an SQL database, on a daily basis....
(1) odpowiedzi
2017-06-15 15:06 Oracle Regex remove duplicates »
I have a requirement to remove duplicate values from a comma separated string. Input String: a,a,a,b,c,a,b Expected output: a,b,c What I have tried...
(0) odpowiedzi
2017-06-15 09:06 Sysdate in oracle virtual column »
I'm trying to create a virtual column in oracle that use a case statement but if I call the SYSDATE function it gave me this error: ORA-54002: only p...
(2) odpowiedzi
2017-06-15 09:06 SQL Query : Facing issues to get desired records from different tables »
I have two tables Calendar (Calname, CCode, PCode) Lookup (LCode, Name) Calendar table contains records like, Calname | CCode | PCode abc | O...
(2) odpowiedzi
2017-06-14 16:06 Time zone results differ with systimestamp »
I have an Oracle table which contains the following column definition: COLUMN_NAME : RESERVATIONDATE DATA_TYPE : TIMESTAMP(6) NULLABLE ...
(3) odpowiedzi
2017-06-14 12:06 Update table records - Add '00' for each 2 Numbers »
I have a table with many millions of records, in oracle. And in this table there's a field that needs to be updated. I need to add a '00' for each to ...
(1) odpowiedzi
2017-06-14 10:06 Query Performance: single column vs multiple column »
Which table structure is better among below 2? OR in first query i use LIKE operator in query. In second i use AND operator. Does first table ...
(2) odpowiedzi
2017-06-13 12:06 Hibernate with sqlserver deadlock issue »
Following are the two tables with its entity classes. tbl_rules | rule_id | rule_name | @Entity @Table(name = "db_user_name.tbl_rules") ...
(0) odpowiedzi
2017-06-13 08:06 ORA-01735: invalid ALTER TABLE option - Toad »
When i execute below SQL in Toad its throws "ORA-01735: invalid ALTER TABLE option". ALTER TABLE CALCULATE ADD (CAL_METHOD VARCHAR2(50), REMARKS VA...
(3) odpowiedzi
2017-06-13 08:06 Converting dates from different centuries »
I have staging table which contains date as string with format 'mm/dd/yy'. I have Oracle 11g procedure to convert the string to date format before loa...
(1) odpowiedzi
2017-06-12 23:06 MAX and SUM query from same table »
I have a table similar the below: part | location | qty 1 | Seattle | 2 2 | New York | 3 2 | New York | 2 1 | Seattle | 1...
(3) odpowiedzi
2017-06-12 17:06 How to convert extracted date in decimal to Datetime in oracle »
I have extracted the date from an EXCEL file which is 42885.4253360301 and date in excel format is DD-MON-RR HH:MI:SS UTC. I want to convert the decim...
(1) odpowiedzi
2017-06-12 07:06 Exception in thread "main" java.lang.NoClassDefFoundError: oracle/jdbc/OracleShardingKeyBuilder »
I'm trying to get DB connection from DB pool. Following is my source code and it returns " java.lang.NoClassDefFoundError: oracle/jdbc/OracleShardingK...
(1) odpowiedzi
2017-06-11 14:06 SELECT FROM AS resulting in ORA-01722: invalid number »
When I try to run the following, I get error in oracle sql developer SELECT VENDOR_CONTACT_LAST_NAME + ', ' + VENDOR_CONTACT_FIRST_NAME AS FULL_NAME ...
(1) odpowiedzi
2017-06-11 14:06 How to get the attributes from an Oracle global_context via package »
For an Oracle Database session-based application context, I can find the attributes and values of the current session either in the view session_conte...
(0) odpowiedzi
2017-06-11 13:06 Opening connections to multiple databases »
I want to connect to multiple databases and want to run some query on through those connections, but it's not working. string source = "1...
(1) odpowiedzi
2017-06-10 22:06 SQL - select most frequent value »
Im stuck with this, I hope someone can help me with this: SELECT max(SELECT count(TO_CHAR(hire_date, 'DAY')) FROM employees G...
(7) odpowiedzi
2017-06-10 14:06 IF ELSE condition executed even though condition is never true »
This is a simple sql statement used to print 2 different questions based on the choice entered. I notice that both statements are run even though the ...
(1) odpowiedzi
2017-06-10 03:06 Any one given this role should be able to assign privieleges to other ORACLE COMMAND LINE »
The Question given in Past Exam was you need to give academic role the ability to select from, insert into and modify existing rows in Student t...
(1) odpowiedzi
2017-06-09 20:06 Add Sum to each row of Listagg in Select »
I use the following as part of a larger query which works as intended. In my case some shipper IDs can have more than one item numbers which would t...
(1) odpowiedzi
2017-06-09 19:06 What is the way with PHP to sanitize user input for SQL DDL statement? »
I need to update a user's password from PHP, this is accomplished through an ALTER USER statement. I can't use prepared statements, because they do no...
(1) odpowiedzi
2017-06-09 10:06 Oracle CONNECT BY behaviour »
I thought I understand how Oracle's CONNECT BY works. But then I found this. select dual.*, CONNECT_BY_ISCYCLE from dual connect by nocycle 1=1 and ...
(1) odpowiedzi
2017-06-08 23:06 Union within CTE removing records but there are no Duplicates »
I have a query with a union within a CTE in oracle. I am trying to get the sum of a field called P in our database and was checking to make sure the ...
(1) odpowiedzi
2017-06-08 20:06 How to display multiple rows or one row, depending on the condition, in SQL Developer »
I am revising a SQL Developer query that pulls transaction data for salespeople from the selected period; the selected period is always a month, e.g. ...
(0) odpowiedzi