Data dodania Pytanie
2017-01-29 06:01 Max Value based on two columns »
I have a table with multiple columns that contains both month and year. I'm trying to identify based on column1,column2 what is the greatest month and...
(2) odpowiedzi
2017-01-28 19:01 How to properly call a function with date parameter? »
I had to create a function that computes how many people are born from the given date as a parameter. I have a table named Person with date of birth ...
(1) odpowiedzi
2017-01-28 13:01 Is possible insert a new row in a complex view created from 2 tables? »
I've read Oracle Language Reference and There is nothing about this situation So here we go... I've coded a complex view from 2 tables: CREATE OR RE...
(2) odpowiedzi
2017-01-28 04:01 Get all dates in a week »
When I select a date from dual. I have to display all the dates in particular week with days. First I get week number using select to_char(sysdate,'...
(1) odpowiedzi
2017-01-27 16:01 How can I use Hibernate/JPA to tell the DB who the user is before inserts/updates/deletes? »
Summary (details below): I'd like to make a stored proc call before any entities are saved/updated/deleted using a Spring/JPA stack. Boring details:...
(2) odpowiedzi
2017-01-27 16:01 SQL in a particular order »
I have data in below order: Bushing ID comp_Code Spot ID ---------------------------------------------- 1 R ...
(1) odpowiedzi
2017-01-27 12:01 How to check in Oracle if table is read only? »
I would like to make an ORACLE table read only. It is possible using: ALTER TABLE table1 READ ONLY; However when table1 is already read only, then a...
(2) odpowiedzi
2017-01-27 07:01 How to get min from 2 values using Oracle SQL »
I have 2 tables TAB1 and TAB2. Both have 3 columns each SEGMENT, LEVEL and VALUE. Below is the data from both tables: TAB1 SEGMENT LEVEL ...
(1) odpowiedzi
2017-01-26 16:01 Oracle - Group By Creating Duplicate Rows »
I have a query that looks like this: select nvl(trim(a.code), 'Blanks') as Ward, count(b.apcasekey) as UNSP, count(c.apcasekey) as GRAPH, count(d...
(1) odpowiedzi
2017-01-26 15:01 What GRANT privileges are required to use %TYPE in variable declaration »
As User1 I have the table: CREATE TABLE USER1.test ( id NUMBER ); As User2 I have the procedure: CREATE PROCEDURE USER2.passInATestId( in_id USE...
(1) odpowiedzi
2017-01-26 14:01 Listview shows 4 records. DataGridView shows 3 records? »
Originally I was using a Listview to display the oracle results however I've recently had to switch to a datagridview to work with the results a bit m...
(1) odpowiedzi
2017-01-25 19:01 Oracle sproc - CASE v_Variable WHEN 'value' OR 'value' THEN »
Here is a bit of pseudocode to explain what I am looking to do: CREATE OR REPLACE PROCEDURE sproc ( v_input IN VARCHAR2 DEFAULT NULL , refCursor ...
(2) odpowiedzi
2017-01-25 16:01 Select from table that does not exist »
I have a question regarding ORACLE, I wrote a PLSQL CODE that checks if a table exists, if it exists then I select something from this table..pseudoco...
(3) odpowiedzi
2017-01-25 13:01 Do conditions in a WHERE clause reduce the amount of rows covered for other conditions? »
Lets say I have a function, POINT_IN_SHAPE('shape_name', x, y) that is an expensive-ish call, so I would want to reduce the amount of times it would b...
(3) odpowiedzi
2017-01-24 16:01 Oracle SQL Error ORA-00933 on INSERT in Lucee »
Error ORA-00933: SQL command not properly ended Attempting to INSERT a row using the following cfscript statement: q.setSQL(" INSERT INTO SALES_OPT...
(1) odpowiedzi
2017-01-24 11:01 PL/SQL: ORA-12704: character set mismatch when insert varchar2 to nvarchar2 »
I try to populate a table TBL in a loop. And get ORA-12704: character set mismatch on a subquery. Here is a query I use: BEGIN FOR i IN (SELECT t....
(3) odpowiedzi
2017-01-24 09:01 Does GeoServer support ST_GEOMETRY for SDE (Oracle)? »
I have an Oracle TABLE of spatial data that I want to serve as WFS using Geoserver. The geometries are stored in an Oracle table in ESRI ST_geometry...
(1) odpowiedzi
2017-01-23 23:01 Accounts Negative for 6 months or more Regardless of Transactions »
I have few accounts Select * from Trans; AccountID PostDate Description Amount 1 07/01/2016 deposit 10.00 1 07/09/2016 ...
(4) odpowiedzi
2017-01-23 14:01 Loopback does not discover Oracle relations »
Following Loobback Docs: Discovering models from relational databases, Stackoverflow answer: Loopback not discovering models and Loopback datasource j...
(1) odpowiedzi
2017-01-23 12:01 how to get all line segments of a line intersecting a polygon in Oracle? »
The intersection of one line and one (concave) polygon can result in several line segments. When I use SDO_LENGTH on the result of SDO_INTERSECTION, ...
(0) odpowiedzi
2017-01-22 21:01 Is it possible to skip the particular SQL statement from auto sql tuning advisor job »
I am facing an ORA:7445 issue with auto sql tuning advisor. Auto sql tuning advisor keeps failing with ORA:7445 while it's tries to tune a par...
(1) odpowiedzi
2017-01-22 18:01 Oracle Forms many to many relationship »
I am new to Oracle Forms and PL/SQL. Here is one of many questions I have: I have three tables: A, B as main tables and AB as my cross reference tabl...
(0) odpowiedzi
2017-01-22 17:01 Java Entities Dates fileds and Oracle TIMESTAMP data types »
In my entities classes I use to define the temporal fields as follows: @Temporal(TemporalType.TIMESTAMP) @Column(name = "START_DATE") pri...
(1) odpowiedzi
2017-01-21 07:01 Multiple columns, multiple table columns to rows unpivot »
This is the ddl for the tables that I'm using. CREATE TABLE "BISAMPLE"."SUMLEDGER" ( "FUND" VARCHAR2(6 BYTE), "ORG" VARCHAR2(6 BYTE), ...
(1) odpowiedzi
2017-01-21 06:01 Numeric or value error when assigning more than 32K string to a clob variable »
I am getting the numberic or value error when I try to do the below. I am trying to assign 40000 length string to a clob variable, it should allow me ...
(1) odpowiedzi
2017-01-21 03:01 PLSQL insert and returning id form trigger on table »
I am trying to execute insert statement within PLSQL insert and returning out the id generated from trigger on table that use sequences but I am gett...
(1) odpowiedzi
2017-01-20 21:01 SQL command not properly ended with WHERE statement »
With this statement: SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) WHERE ROWNUM = 1; why do I get this error: ERROR at line 1...
(3) odpowiedzi
2017-01-20 15:01 Is it possible to insert an IF clause inside of a WHERE clause in a SELECT? »
sorry if this is a dumb question, I'm new to PL/SQL. I have a PL/SQL Stored Procedure which retrieves data from a table. There are 2 optional paramete...
(1) odpowiedzi
2017-01-20 08:01 Compare String in Oracle Case When »
i have an issue with oracle case when. SELECT CASE WHEN '7C54D3E133830A78E040A8C010014B7D' != '' THEN '7C54D3E133830A78E040A8C010014B7D' ...
(2) odpowiedzi
2017-01-19 18:01 Python - transpose a Pandas DataFrame »
I would like to transpose the following dataframe in order to export it to an Oracle table. 0 ID Available Quo...
(1) odpowiedzi
2017-01-19 14:01 Error while exporting clob field from oracle to text field on Azure DB »
I have a clob field on oracle that store a PDF file. When I try export this field to SQL Server Db on Azure I got this error: 2017/01/19 11:14:32 - ...
(0) odpowiedzi
2017-01-19 12:01 How to speed up oracle normal statement bulk operations? »
I'm developing tool to continuously export changes from MongoDb to Oracle database. I have problem with execution batch operation(Oracle). static vo...
(0) odpowiedzi
2017-01-18 18:01 Exception to schedule in DBMS_SCHEDULER job »
I have an Oracle DBMS_SCHEDULER job that normally runs every hour on the hour. No problem. But, I recently needed to make an exception to this, so t...
(0) odpowiedzi
2017-01-18 18:01 Haversine Formula unit errors - PL/SQL »
Overall goal: Find all zip codes within 30 miles of a given zip. Data Source: List of Zip Codes, with Latitude and Longitude as 'x' & 'y'. Examp...
(1) odpowiedzi
2017-01-18 14:01 Insert NULL into setDouble method Java »
My code attempting to insert NULL into setDouble method in PreparedStatement ps.setDouble(++i, balance.getAmount()); getAmount() is Double field. ...
(2) odpowiedzi