Data dodania Pytanie
2017-07-23 16:07 all queries are uppercase with oracle driver with laravel query builder »
I'm using https://github.com/yajra/laravel-oci8 for connecting to oracle database in my project. the problem is all of my queries turns to uppercase....
(0) odpowiedzi
2017-07-23 15:07 Connect Sys as Sysdba : Insufficient privileges »
I'm trying to connect to an Oracle database using SQL Developper as Sys DBA but I'm receiving the error : ORA 1031 : Insufficient Privileges. I'm sur...
(3) odpowiedzi
2017-07-23 13:07 SQL join query where foreign key has non of these fields »
I have two tables created as follows: create table table1( id number(10) not null, constraint table1_pk primary key (id) ); create table tab...
(3) odpowiedzi
2017-07-22 22:07 Oracle : select last updated row having maximum DATE_COLUMN »
suppose I have a oracle table like this. EMP_ID DATE_EX ATTN LEV REV -------- ----------- ---- ---- ---- 50001000 13-07-2017 2...
(3) odpowiedzi
2017-07-22 18:07 not all variables bound when returning inserted id Oracle »
I'm trying to get the new id when inserted new data in database table, but I got: ORA-01008: not all variables bound I'm doing it from a Java SE p...
(2) odpowiedzi
2017-07-22 10:07 Getting first 10 unused manual_sequence numbers »
I would like to find the first 10 unused manual sequence numbers from a range. Please find my query below: select X1.* From (Select Rownum seq_n...
(1) odpowiedzi
2017-07-21 21:07 PHP Oracle Date Error ORA-01847 »
I have some trouble about inserting new record to oracle from php. If I remove date column or change date column format to string i can add new record...
(1) odpowiedzi
2017-07-21 12:07 Can't convert timestamp to a time zone Asia/Jerusalem »
I'm using Oracle and it doing: SELECT FROM_TZ(TIMESTAMP '2017-03-31 02:10:00', 'Asia/Jerusalem') FROM DUAL; Throws an: 01878. 00000 - "speci...
(1) odpowiedzi
2017-07-21 00:07 Python cx_Oracle Client Library Cannot Be Loaded »
I am trying to connect to an Oracle database but python script cannot find cx_Oracle. Here is my script: import cx_Oracle con = cx_Oracle.connect(
(2) odpowiedzi
2017-07-20 18:07 ORA-12704: character set mismatch when performing multi-row INSERT of nullable NVARCHAR's »
Consider the following table where one of the columns is of type nullable NVARCHAR: CREATE TABLE CHARACTER_SET_MISMATCH_TEST ( ID NUMBER(10) NOT ...
(0) odpowiedzi
2017-07-20 15:07 multiple select query with same where clause »
I have two type of select statement with the same complicated where clause. One - Returns transaction detailed data select field_1, field_2, field_3...
(4) odpowiedzi
2017-07-20 13:07 Why lowercase 'i' mapped to '?' after doing NLS_UPPER »
Can someone please explain why lowercase i in string abcdefghijklmnopqrstuvwxyz is mapped to ? whereas all other alphabets are correctly mapped to cor...
(2) odpowiedzi
2017-07-19 20:07 PL/SQL Oracle - Insert ID from Table 2 in Table 1 based on Name as key, which may be duplicate and update Table 2 if Name not found »
PL/SQL - Insert ID from Table 2 in Table 1 based on Name as key, which may be duplicate and update Table 2 if Name not found in Oracle. I have to cre...
(2) odpowiedzi
2017-07-19 14:07 is it possible to put condition inside count function in oracle? »
I have a table with a creditAmount and terminal_ID fields, in which I have values that are >0 and some are < 0. I want to count the rows which are ...
(2) odpowiedzi
2017-07-19 05:07 ORA-01877: string is too long for internal buffer »
I'm Trying to insert a row into ORDER table with a structure as follows: However when using this insert statement: INSERT INTO "ORDER" ( CUSTR...
(1) odpowiedzi
2017-07-18 09:07 Table Left Join »
I'm currently trying to get an output from two tables that I want to join and it seems like I have a block in my mind on how to resolve this. Table 1...
(2) odpowiedzi
2017-07-18 08:07 Is there any way to reference column with different datatype? »
I have 2 schemas/tables as shown: CREATE TABLE schema1.code_tbl ( code CHAR(6) PRIMARY KEY, description CHAR(30) ); CREATE TABLE schema2.r...
(3) odpowiedzi
2017-07-18 08:07 how to multi-row insert in Oracle with sequence? »
I want insert more than one row into table in Oracle . But it's confused me: I can not use "select seq_table1.nextval into table1 form dual" , becaus...
(2) odpowiedzi
2017-07-17 17:07 Merging multiple count queries with a common date field »
I have 3 queries as per below :- SELECT to_char(Actual_SSD,'YYYY-MM') AS Period, Count(Actual_SSD) FROM tblQuotesNew where tblQuotesNew.Quote_Status=...
(1) odpowiedzi
2017-07-17 17:07 SELECT WHERE Query Spanning Numerous Rows Linked by RotationID column »
So first, apologies for the rough title. Really not sure how to summarize this simply. I'm also decently new to SQL, but couldn't find anything to hel...
(1) odpowiedzi
2017-07-17 13:07 How can I create constraint using subquery in sql? »
Here is my table game : create table game ( h_team number, a_team number, p_date date ); Condition to be followed: Every team plays ...
(1) odpowiedzi
2017-07-16 18:07 Need help creating Oracle PL/SQL Stored procedure »
I'm currently trying to convert the SQL Query to Oracle PL/SQL stored procedure. Here is the query: select * from table1 where DATE = " + s1 + " a...
(3) odpowiedzi
2017-07-16 10:07 Oracle change any string to a number »
I'm having this problem we have this database witch IDS are stored in varchar2 type this ids contains Letters. Is there any solution to convert a str...
(2) odpowiedzi
2017-07-16 10:07 ORA-12518, TNS:listener could not hand off client connection comes from a loop with heavy memory access »
I have a loop with heavy memory access from oracle. int firstResult = 0; int maxResult = 500; int targetTotal = 8000; // more or less ...
(1) odpowiedzi
2017-07-15 19:07 How to fetch record from entity which is not having primary key column using JPA or JPQL »
I have table with no primary key or embeddable key (combine two columns to represent data uniquely withing table). So how can I fetch all records fr...
(1) odpowiedzi
2017-07-15 09:07 Print NULL Value column Name »
I have a table with the columns ColA, ... , ColE as below. I need to check each record and show the column name which has NULL value in another existi...
(2) odpowiedzi
2017-07-15 01:07 Microsoft SSIS Connectors by Attunity Version 4.0 NOT showing on Visual Studio 2015 »
In one of our company meetings with Microsoft we were advised to use Microsoft SSIS Connectors by Attunity Version 4.0 if we extract data from Oracle....
(1) odpowiedzi
2017-07-14 22:07 ora-00936 missing expression-select statement »
I have a variable in ssis, with query SELECT OBS_TYPE_ID, OBS_TYPE_NAME, OBS_UNIT_ID, IS_LEAF, PATH, LEVEL0_NAME, LEVEL1_NAME, LEVEL2_NAME, LEVE...
(2) odpowiedzi
2017-07-14 22:07 Oracle OLE DB Provider not Listed in SSIS »
I'm having an issue with SSIS and VS2015 CM. I have a package that needs to connetc with Oracle to get some data. I installed the ODAC for Win64 and...
(1) odpowiedzi
2017-07-14 08:07 Count(*) with order by not working on PostgreSQL which works on Oracle »
Below is the Sql query which works on oracle but not working on PostgreSQL. select count(*) from users where id>1 order by username; I know that...
(2) odpowiedzi
2017-07-13 16:07 Trigger to update week of the year »
I want to write a trigger so that when decom_date is inserted or updated the week of the year is updated to the corresponding value. This is what I h...
(1) odpowiedzi
2017-07-13 15:07 Pivot in SQL: count not working as expected »
I have in my Oracle Responsys Database a table that contains records with amongst other two variables: status location_id I want to count the num...
(1) odpowiedzi
2017-07-13 05:07 Oracle SQL TO_DATE and TO_TIMESTAMP »
I have two queries in Oracle SQL that are equivalent. SELECT ... FROM TABLE WHERE timestamp = TO_DATE('2017-07-01', 'YYYY-MM-DD') and SELECT ... F...
(1) odpowiedzi
2017-07-12 09:07 is there any difference between where company_id=1 and where company_id='1' in oracle? »
If I am enclosing bind value within single quotes in where clause, Am I doing a mistake? I just want to know is it good practice to put every value un...
(1) odpowiedzi
2017-07-12 09:07 Get the previous dates from another table »
I have 2 tables. 1 table looks like this (values are stored as DD-MM-YYYY) Table A: CustID | StartDate 1 | 20-1-2016 2 | 25-1-2016 2 ...
(2) odpowiedzi