Data dodania Pytanie
2017-01-17 17:01 i try use stored procedure in apirest but don't work »
I need your help I have a program in C # That has entity frameworks 6.0.0.0 In which I am using an apiRest to access data from the ORACLE database T...
(0) odpowiedzi
2017-01-17 15:01 Convert comma separated values to rows in Oracle »
I have a table named student_info in my database.There are multiple columns out of which two columns store comma separated values class_id studen...
(4) odpowiedzi
2017-01-17 08:01 Alternate of using NVL with IN clause in Oracle 11g »
I have a workplace problem to which I am looking for an easy solution. I am trying to replicate it in a smaller scenario. Problem in short I want ...
(2) odpowiedzi
2017-01-16 20:01 Oracle PL/SQL: Conditional Where Clause »
Can someone guide me on how to approach the following: x CHAR:= 'Y'; --VARIABLE SELECT a.id, a.name, a.description FROM Table1 a WHERE (IF x = 'Y' T...
(1) odpowiedzi
2017-01-16 15:01 Oracle PL/SQL: Function Error when passing parameters »
When I pass a parameter to a function call, I get the following error: Error: PLS-00306: wrong number or types of arguments in call to 'GET_NUM...
(2) odpowiedzi
2017-01-16 12:01 Update Oracle BLOB value in a batch »
I'm trying to update a series of BLOB values using the following code. Note how we're not using Blob objects, but just calling setBytes. try (Prepare...
(0) odpowiedzi
2017-01-15 15:01 PL/SQL procedure to insert id to rows having same information »
I have contact details data in Oracle table something like below... I want to insert new column to assign same ID to the contacts having matching i...
(2) odpowiedzi
2017-01-15 12:01 Roll balance foward fill in the gap »
guys I'm a bit stumped on this one and wonder if you guys can help me. I have a table DDL like such. CREATE TABLE "BISAMPLE"."G_LEDGER" ( "FUND" ...
(2) odpowiedzi
2017-01-15 07:01 Once we pinned one hash plan for SQL ID in Oracle, will Oracle change the plan in the future? »
Once we pinned one hash plan for SQL ID to a particular SQL profile, will Oracle change the plan in the future? E.g. if we are doing some DB upgrade o...
(2) odpowiedzi
2017-01-14 21:01 Advantage of Internal Procedures Forward Declarations in PL/SQL Packages »
Say I have the Package below (please take note of the comments): Create or replace package test_package_fdec as procedure ext_proc1; procedu...
(1) odpowiedzi
2017-01-14 15:01 Oracle sql query to xml »
I have the below query. SELECT DISTINCT P.PLAYERID, P.FIRSTNAME, P.LASTNAME, P.POSITION,PT.POINTS, PT.MINUTES, CALC_TENDEX(P.PLAYERID, PT.TEAMID, 200...
(1) odpowiedzi
2017-01-14 01:01 Incorrect Count(*) of Table Records »
I am trying to take a count of a table in oracle. When I run a very simple count such as: SELECT COUNT(*) FROM EDW.SCADA_VALUE_HIST; --Returns [1143...
(1) odpowiedzi
2017-01-13 18:01 PL/SQL Oracle - Selecting from internal table »
EDITED I have a problem with performing some PL/SQL code. I have real table a. I want to take only elements with range<=100. I make a collection i...
(3) odpowiedzi
2017-01-13 12:01 Need help on writing sql query with dynamic columns »
I have to write a query which does below. I tried but couldn't write. Please help me. I have table which returns below result set. select * from ta...
(4) odpowiedzi
2017-01-13 12:01 Use Pivot Function to Merge Column sets in Oracle »
I have a table in the below format: id colA1 colB1 colA2 colB2 1 100 499 500 999 I need it in the below format, id colA colB 1 100 499 ...
(2) odpowiedzi
2017-01-12 21:01 Oracle - Max value from each date with date/time »
I have table with column Date with timestamp, value in seconds and have query like Table 2017-01-10 06:45:00 PM 1119 2017-01-10 03:30:00 PM 1054 ...
(2) odpowiedzi
2017-01-12 10:01 UTC Time is not getting stored in oracle column(TIMESTAMP WITH TIMEZONE) using JPA »
I am getting UTC time in string format that we need to persist into database. from UTC datetime string Calender object created using below code. Dat...
(1) odpowiedzi
2017-01-12 09:01 subtract values selecting by timestamp self join »
I have the following problem: Table1: id, timestamp, value1,value2,value3 1, 12.01.2017 09:00:01, 234, 345, 456 2, 12.01.2017 09:00:05...
(1) odpowiedzi
2017-01-11 19:01 PLSQL Performance Issue »
This is more of a doubt than a problem. I have a requirement of just selecting some of the common fields from one table and insert it into a different...
(1) odpowiedzi
2017-01-11 10:01 Oracle: Combine two group by queries (which use aggregate function count()) by union or so to get a consolidated result »
I have two tables. TABLE_A and TABLE_B. Both tables maintain columns to save CREATION_USER. But this column has different name in respective tables. ...
(3) odpowiedzi
2017-01-11 03:01 What is the difference between Join and Natural Join? »
I'm learning Oracle SQL and now I'm stuck on Joins chapter. I can't understand the difference between Join and Natural Join SELECT employee_i...
(1) odpowiedzi
2017-01-10 13:01 Oracle date seems equals »
there is a table INCASSO in my database: CREATE TABLE "GEC_AP"."INCASSO" ("ID_INCASSO" VARCHAR2(50 BYTE) NOT NULL ENABLE, "ID_FATTURA" VARCHAR2(50 ...
(2) odpowiedzi
2017-01-10 11:01 Invalid identifier error while running plsql block »
Since my school does not allow me to post the code, hence i had to come back home and put up an example to show the issue i am facing. My school asked...
(1) odpowiedzi
2017-01-10 07:01 edition$ in Oracle 11g »
While checking v$sql in my database, I came across this query. select p_obj#, flags, code, audit$ from edition$ where obj#=:1 Can anybody please ex...
(1) odpowiedzi
2017-01-09 17:01 Oracle SQL Index DATE vs Index TRUNC(DATE) »
I have a Table named DEXTRACTO and I need to consult a period of time based on column F_EXTRACTO (witch is DATE format) with a BETWEEN DATE1 AND DATE2...
(2) odpowiedzi
2017-01-09 05:01 Zero Copy with databases »
Is it possible to perform a zero copy between a database (preferably oracle) and a socket? Zero Copy : http://www.linuxjournal.com/article/6345 ...
(0) odpowiedzi
2017-01-09 03:01 What is wrong with the WHILE Loop on PLSQL? »
I'm practicing collections on PL/SQL, and now I've code a simple WHILE Loop to print on screen the values of the sparse associative array. I received ...
(1) odpowiedzi
2017-01-08 21:01 Updating a table in Oracle based on data from another table and 3 keys »
All, Here is my two tables: Table customer First_Name | Last_Name | Purchases| Age John Rambo 10 55 George Washington...
(1) odpowiedzi
2017-01-08 21:01 While Loop Terminating after ResultSet.execute »
I am trying to make TABLE COMPB equivalent to TABLE COMPA by Update and Delete operations on Table COMPB based on Table COMPA. The code works perfectl...
(3) odpowiedzi
2017-01-08 18:01 Oracle Stored Procedure with User Defined Type in C# »
I am trying to use a stored procedure for variable data refcursor; execute MyPkg(to_date('2010-08-11','yyyy-MM-dd'), TEXT_ARRAY('tempa','tempb'), :d...
(1) odpowiedzi
2017-01-07 20:01 Bulk data insert from SQL to Oracle using C#.NET »
The following code snippet for for bulk insert of data from SQL DB into Oracle database. I have used stored procedure in oracle database with 2 para...
(1) odpowiedzi
2017-01-07 15:01 pass string without single quote in spring jdbctemplate »
my requirement is to create a insert statement through Spring JDBCTemplate in which I can pass oracle function which execute at database. e.g - lets...
(1) odpowiedzi
2017-01-07 08:01 How to delete a node from Oracle XMLTYPE based on a condition? »
I have a XML data stored in a CLOB column and I would like to delete some nodes based on a specific condition. Example XML Data : <?xml version="...
(4) odpowiedzi
2017-01-06 19:01 too many declarations of »
I am getting the following error message while running the below code. I am new to coding world of pl/sql (oracle) and I request your assistance for t...
(2) odpowiedzi
2017-01-06 12:01 With Oracle, how can I restore a table that I dropped accidentally? »
I have actually dropped instead of deleting a table in Oracle SQL. Drop table emp; Is there any way to retrieve it back? ...
(3) odpowiedzi