Oracle

Great Reads

Hadoop For .Net & AngularJS Developers

by Bert O Neill

Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)

Nullable datetime column in .NET DataGrid with DateTimePicker

by vic_ch2000

A nullable datetime column in .NET DataGrid with DateTimePicker.

The Oracle Call Interface (OCI) and ODP.Net - Part 1

by Espen Harlinn

Proven techniques for fast Oracle Database access using .NET 5.0 and native C++

Aggregate Product function extends SQL

by DrABELL

Technique to extend capability of standard SQL by adding the Aggregate Product Function

Latest Articles

Deploy MySQL and WordPress on an always free tier Arm shape

by Frédéric -lefred- Descamps

How to install WordPress on Oracle Cloud Infrastructure (OCI) using always free tier

Deploy Arm Instances on Oracle Cloud Infrastructure (OCI) using Terraform

by Frédéric -lefred- Descamps

How to deploy Arm instances on Oracle Cloud Infrastructure (OCI) using Terraform

Why Do I Have Questions to GO

by Alexey Shtykov

Lot of fancy languages were born and have died since I started working in IT, but a few of them continue their pitiful existance.

Executing Raw SQL Queries using Entity Framework Core 6

by DiponRoy

Run Raw SQL Query - Entity Framework Core 6

All Articles

top

Oracle

"OR" condition in Materialised view

4 Jul 2012 by Sandeep Kumar Sinha

select * from myMatialisedView where Col1>'0' or Col2>'0'when executing this query. getting error like "Invalid Characeter"

Oracle

"Unimplemented or unreasonable conversion" error when trying to save images into oracle BLOB having more than 4k size. Im using Oracle 11g with asp.net 4.0 .

19 May 2015 by Member 11445380

Please Help me Its way too urgent!!!and i need to store images itself not their pathI have the requirement to save image into Database.Description of my question is : I have a asp.net 4.0 web application that uploads a image and then my application converts that image into byte...

C#4.0

Oracle

database

"Unimplemented or unreasonable conversion" error when trying to save images into oracle BLOB having more than 4k size. Im using Oracle 11g with asp.net 4.0 .

2 Jun 2015 by Member 11445380

Problem has been resolved by using Oracle Transaction!!!

C#4.0

Oracle

database

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'intTableNo' at line 19

20 Jan 2014 by Rajib Mahata

CREATE PROCEDURE `FetchSupplierByRequest`(intConferenceId int, intRank int,intTableNo int)BEGINSELECT Distinctc.ID , c.CompanyName,c.TypeFROM conferencetabletop cp, companies c,meeting mWHERE cp.ConferenceID = intConferenceId AND c.ID = m.SupplierIDand...

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'intTableNo' at line 19

22 Jan 2014 by idenizeni

According to the information I can find, older versions of MySQL cannot use variables in the LIMIT clause and constants must be used. Similar issue posted to StackOverflow with some useful information.http://stackoverflow.com/questions/2875238/passing-limit-as-parameters-to-mysql-sproc[^]

.Net and oracle pipelined function

28 Dec 2010 by Prasenjit Purohit

Hi, I am searching for a way to access an oracle function from .NET, which returns a USER DEFINED TYPE(Table or Object/collection type) and the function is pipelined. Please help me with some sample code of PLSQL and C#. I am using ODC11G.Thanks

.NET

Oracle

.Net and oracle pipelined function

28 Dec 2010 by TweakBird

Hi Have a look on These1) http://programmerfindings.blogspot.com/2009/02/how-to-access-oracle-function-in-net.html[^]2) Execute-Oracle-Function-Returns-Reference-Cursor-CSharp[^]Using Pipelined Table Functions:http://www.codeguru.com/cpp/data/mfc_database/oracle/article.php/c4285[^]

.NET

Oracle

.NET Reporting Tool Tutorial - 1

28 Apr 2013 by emadns

A basic tutorial for ReportMax tool

.NET Reporting Tool Tutorial - 3

23 Apr 2013 by emadns

Using the Chart control in ReportMax

00904. 00000 - "%s: invalid identifier"

3 Jun 2021 by Member 15229094

SELECT entertainer_id, entertainer_groupname FROM casestudy_entertainer INNER JOIN casestudy_availability ON casestudy_entertainer.entertainer_id = casestudy_availability.availability_entertainerid INNER JOIN casestudy_calendardates...

Oracle

00904. 00000 - "%s: invalid identifier"

3 Jun 2021 by OriginalGriff

There is no example of the string "%s" in that code, which means one of two things: 1) It's part of your code that queries the DB - since "%s" is the C / C++ printf / sprintf format code for a string, it's possible that it's being reported on...

Oracle

00904. 00000 - "%s: invalid identifier"

3 Jun 2021 by Wendelius

I take it you're running this for example in SQL*Plus. & indicates a substitution variable so you need to define a value for it prior to using. Try using something like define Entertainer_TYPE = 'Something goes in here' define Event_date =...

Oracle

01861 literal does not match format string

22 Mar 2016 by vpinraj

I have a query to select last 5 vehicle are recently reported. which is stored in "VEHICLE_IN" table. SELECT R.REG_NO FROM (SELECT G.REG_NO FROM VEHICLE_IN G INNER JOIN VEHICLE_MASTER M ON G.REG_NO=M.REG_NO WHERE to_date((IN_DATE||' '||IN_TIME),'YYYY-MM-DD HH24:MI') >=...

SQL

Oracle

100+ automatic tables shown during open connection

11 Jan 2016 by Member 10192073

hi,please help me i am going to expand the tables in SQL Developer but its showing near 100+ tables.i want to see tables that i have created so how is it possible please?i have created a connection in oracle SQL Developerwhen i connect that connection then when i am going to open table...

Oracle

100+ automatic tables shown during open connection

11 Jan 2016 by Mehdi Gholam

Generally people use a naming convention for this like a 3 letter subsystem prefix etc. so associated tables are listed next to each other.

Oracle

11 important database designing rules which I follow

25 Feb 2014 by Shivprasad koirala

This article will discuss about 11 important database designing rules.

2 server orcale have the same database

5 Sep 2011 by marjavic

hi alli have 2 orcale server : 1- ser1 have database1 2- ser2 have database2* datebase1 and daabase2 is the same i need when i insert , delete or update in database1 dynamically effect in database2 with the same statementthanks in advance

Oracle

2 server orcale have the same database

6 Sep 2011 by Wendelius

There are several options for this. One quite easy way is that you create a database link between the databases. See: http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_5005.htm[^]Using that link you can execute statements against the remote server for example from a...

Oracle

64 Bit ASP.NET Project - Attempt to load Oracle client libraries threw BadImageFormatException.

24 Mar 2018 by jobin007007

I am getting a "Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed."I have a main ASP.NET project which is 64 bit(set to Auto though) and another oracle database...

64 Bit ASP.NET Project - Attempt to load Oracle client libraries threw BadImageFormatException.

18 Mar 2011 by Patrick Kalkman

Normally, you don't have to explicitly set the platform for a Microsoft .Net program. You specify AnyCPU in Visual Studio and your program gets compiled to IL code. At runtime Microsoft.Net compiles just in time the IL code into x86 or x64 depending on the OS. By explicitly specifying the...

64 Bit ASP.NET Project - Attempt to load Oracle client libraries threw BadImageFormatException.

19 Mar 2011 by jobin007007

I might have found out why i am having this problem. I was checking all the modules loaded in my ASP.NET project and I see that all the references are to the 32 bit dll's instead of the 64 bit dlls( The modules can be checked by going into Debug-> Windows->Modules . Below is a few of the post...

64 Bit ASP.NET Project - Attempt to load Oracle client libraries threw BadImageFormatException.

19 Mar 2011 by jobin007007

WOW...Solved this issue finally!!!!I guess I got confused by all the posts I was reading that told me to set the 32 bit Enabled =true in the Application pool for IIS.The solution seems to be to set 32 Bit Enabled=false in IIS because for some reason setting 32 bit Enabled =true seems to...

64 Bit ASP.NET Project - Attempt to load Oracle client libraries threw BadImageFormatException.

3 Apr 2011 by Jörgen Andersson

IIS 32 bit enabled and 32 bit Oracle client works.IIS 32 bit disabled and 64 bit Oracle client works too.Nothing strange really, it's just a PITA to debug.More fun when you realize that Visual Studio is a 32 bit program that won't work with 64bit client.

64 Bit ASP.NET Project - Attempt to load Oracle client libraries threw BadImageFormatException.

5 Mar 2012 by KK shah

FOR DESKTOP MODULE SET SOLUTION PROPERTY ADVANCE COMPILE OPTION TARGET CPU TO X86 IT WILL SOLVE THE CONNECTIVITY ISSUEWHILE IN WEBCREATE ONE DIFFERENT APPLICATION POOL IN IIS ASSIGN NAME TO IT SET ENABLE 32 BIT APPLICATION POOL=TRUE.AND ASSIGN THAT APPLICATION POOL TO PARTICULAR...

64 Bit ASP.NET Project - Attempt to load Oracle client libraries threw BadImageFormatException.

2 May 2013 by Mohd Ismail Siddiqui

Solved!!!!I've run it similar issues with the Oracle Data Access Components before. My guess is that you built your .exe using the AnyCPU platform target in your console application's build configuration. This means that when it's run on your 32-bit development machine it will be loaded...

64 bit WCF application to connect with 32bit oracle 10g- project setting and oracle client insatllation

16 Apr 2018 by garvjain007

my pc is 64 bit windows 7 and i need to develop a .net web services which will connect to 32 bit oracle[10g] server... please suggest what project setting and what oracle client will be required What I have tried: i tried any cpu setting with oracle 32 bit client installation but receiving...

.NET3.5

Oracle

64 bit WCF application to connect with 32bit oracle 10g- project setting and oracle client insatllation

16 Apr 2018 by Wendelius

The error message you received happens because native Oracle client is either 64 or 32 bit, not both. In your project settings, try setting the architecture explicitly to x86,

.NET3.5

Oracle

800ac350 missing parameter: OLEDB provider

25 Nov 2014 by Rohit Gupta

I am debugging an application written in Classic ASP. The app connects to Oracle db in cloud but I get this error :Code: 800ac350Description : missing parameter OLEDB provider.Does anyone has any idea why I am getting this error.I am using x64 bit drivers for Oracle...

Oracle

ASP

OleDb

[ASK] - Reset Auto Incremental as ID in oracle

19 Aug 2010 by Teamsar Muliadi

Hi experts, :)Would u like to help me ? I wanna reset id (auto incremental) in oracle, but i don't know how to do that.. i've tried to find the solution, but i've not found that.. :(Help me please experts... :( Thank you.

Oracle

[ASK] - Reset Auto Incremental as ID in oracle

19 Aug 2010 by Nyarost

As soon as I remember there is no auto_increment in Oracle. It is done through sequences. So you need to find sequence and update it. If it is not possible then drop and recreate.

Oracle

[Create table] MS SQL to oracle

1 Sep 2016 by Member 12716184

Hello.Please change under the sql statement to Oracle syntax.Thank you.-----------------------------------------------------------------------CREATE TABLE [dbo].[E_QUALITY_IF]( ...//create some fieldsCONSTRAINT [PK_E_QUALITY_IF] PRIMARY KEY CLUSTERED ([PROD_DT] ASC, ...

Oracle

[Create table] MS SQL to oracle

1 Sep 2016 by Mehdi Gholam

Try reading the documentation first :Oracle / PLSQL: CREATE TABLE Statement[^]Oracle - SQL - Create a Table[^]

Oracle

[Solved] concurrency violation : Updated 0 of the expected 1 records

10 Dec 2019 by ramakrishna Namburu

Hi All,When i am trying to update the database table using the Dataadapter.update method in C#, throws the error "concurrency violation : Updated 0 of the expected 1 records".Please help me how to get this resolved.Regards,RamakrishnaUPDATE from OP:OP was able to resolve he issue...

Oracle

[Solved] concurrency violation : Updated 0 of the expected 1 records

2 Feb 2011 by Eduard Keilholz

Hey Ramakrishna,Most of the time's I've experienced this exception was when one or more columns in the dataset (or datatable) to be updated are automated, or the database gives one or more fields different values due to triggers.I had tables with a DateCreated and a DateModified field....

Oracle

[Solved] concurrency violation : Updated 0 of the expected 1 records

2 Feb 2011 by Abhinav S

Have a look at this[^] blog - this should give you enough info to get started with the resolution. Follow the references given at the bottom of the blog.

Oracle

[Solved] concurrency violation : Updated 0 of the expected 1 records

3 Feb 2011 by ramakrishna Namburu

HI All,I got this resolved by specifying the datatable.acceptchanges().once this is done set added property of each row to true and you are there with the correct working of application.Thanks all for the replies.

Oracle

[Solved] concurrency violation : Updated 0 of the expected 1 records

5 Mar 2014 by aricode

Hi All,This blog http://blogs.msdn.com/b/spike/archive/2010/04/07/concurrency-violation-the-updatecommand-affected-0-of-the-expected-1-records.aspx[^]defines the cause of the related problem, however most specifically the cause can be best understand from the msdn...

Oracle

[Solved] concurrency violation : Updated 0 of the expected 1 records

20 Jul 2018 by Member 11126085

I had this issue after using an my Update statement for my TableAdapter. I solved it by refilling my TableAdapter again after the Update method. It then retrieved the data again. It does the because we are using "Optimistic Concurrency" which you can disable in Advanced Options when...

Oracle

[Solved] Conflict of parameter passing in web service

17 Jun 2015 by Renjith V S

Hi, I have used the following code for joining two tables. But it doesn't return any value.OracleDataReader oraReader = null;OracleCommand oraCommand = new OracleCommand("select name,code,age,city from personal inner join address on personal.NO=address.NO where NO='" + NO+ "'",...

Oracle

ASP.NET

webservice

[Solved] Conflict of parameter passing in web service

17 Jun 2015 by Sreekanth Mothukuru

I think you missed the table name in the where clause. It should be like where address.NO or personal.NO

Oracle

ASP.NET

webservice

A Closer Look at Lookup Tables

20 Oct 2016 by Bryan Kowalchuk

The two most common database lookup table patterns are examined

A Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 5

19 Sep 2009 by Paul Rony

A Programmer's Guide to Starting a Software Company and Building an Enterprise Application

A propertymapping Extension for DataReaders

26 Jan 2016 by Jörgen Andersson

A propertymapping extension for DataReaders

a question about Oracle Portal

31 Oct 2010 by KaRaMiLo

Hello , I want to know how to download a file from a server using Java programming language and the website which i want to download file with is based upon oracle portal.and thanks in advance.

Oracle

A Small Utility to Generate Cascading Delete SQL Script in Oracle

22 Feb 2011 by ronald.cao@gmail.com

The article is to introduce a utility to generate cascading delete script for an Oracle table.

A Very Simple Oracle Query Tool

11 Jul 2008 by Syed M Hussain

This is a very simple tool, to query an Oracle XE database

About Cursor in Oracle

28 Jun 2012 by pinki30dec

HiCan anyone explain me difference between ref cursor and simple cursor in oracle with proper example.Thanking you in advance,Shilpi

Oracle

About Cursor in Oracle

28 Jun 2012 by Sandeep Mewara

REF cursor is a dynamic cursor that supports change of query at runtime. Typically, REF cursor is used to return a record set or a cursor from stored procedure. where as Normal cursor is a static cursor where the query is assigned at design time and it can not be changed at...

Oracle

Abstract Nonsense in Software Development. Databases

18 Jan 2014 by Petr Ivankov

Application of abstract approach to database domain

Access database to data warehouse

26 Oct 2014 by psychic6000

Is there any way to convert a access database to Oracle or MS SQL database or data warehouse?I have this assignment of performing actions over a data warehouse (any plat form, Oracle or anyother) but i have a database of access at this point, is there any way to convert this database to data...

SQL

Oracle

MS-Access

Access database to data warehouse

26 Oct 2014 by Maciej Los

MS SQL:Download MS SQL Server Migration Assistant for Access[^], install it and use it ;)Oracle:This tutorial: Migrating a Microsoft Access Database to Oracle Database 11g[^] explains how to do it in a simple way.

SQL

Oracle

MS-Access

Access oracle 10g in LAN

29 Aug 2017 by Member 12931084

hi guys i'm right now on database application and i need to access to my database(oracle 10g on my computer) from another pc connected via Local Area Network . what i should modify (in tns listener ) and how can i access to a data base licated in another pc in the same network Help me please...

Access oracle 10g in LAN

29 Aug 2017 by KarstenK

At first the database must be configured for network access. With that credentials you can access the database. Read the Oracle documentation for the details.

accessing distributed database over lan

16 Apr 2011 by gaurish thakkar

i am working on a c# based application which requires access to a database distributed between two computers .the application accesees two databases which are horizontally and vertically fragmented .'it is just to implement the concept of distributed systems which acceses remote data.i...

Oracle

accessing distributed database over lan

16 Apr 2011 by dan!sh

You will have to have a two separate connections and other needed objects to access those databases. If your relates to load balancing, then this reply does not holds good. Edit your question so that people responding are aware of exact scenario.

Oracle

accessing mysql database after every 1 hour and insert records into oracle database

14 Jun 2011 by krutipathak

hi,I want to access mysql database and select the records from its tables and insert into oracle database tables after every 1 hour,I am using dot net with C#.can anyone provide me solution for this?Will i have to use scheduler for that?how to use it?pl help.

MySQL

Oracle

ASP.NET

accessing mysql database after every 1 hour and insert records into oracle database

14 Jun 2011 by Kim Togo

Use MySql Connector/Net[^] and Oracle Data Access Components (ODAC)[^] for database connections and use Windows Scheduler for the timer job.

MySQL

Oracle

ASP.NET

Active directory & oracle connection approach for large data

7 Jul 2019 by VenkataRamana.Gali

Hi all my application is connecting Active Directory pulling some data (around 500K records), store & reconciliation happens in Oracle 11g database. we will be writing a batch in C# (4.5.2 framework) to do this. any recommendations/best practices to do this? Entity Framework or any other...

active-directory

Oracle

add data to database throw jsp

4 Jun 2010 by mahesh bandi

i am creating automatic creating table to add new rows in the table. i am trying to add content on table to add the database. can any one help me.

HTML

Oracle

add header to an existing grid which repeated for the full grid

29 Jul 2010 by agrace27

the grid looks like this a1 a2 a1 a2 ...................a1 a2 m n mn x y xy mnxy m n mn x y xy mnxy C1 C2 c3 C30r1 10 10 20 5 5 10 30 10 10 20 5 5 10 30r2 10 10 20 5 5...

Oracle

Adding an http Security Header to Web Reference and Using Oracle CRM Stateless

4 Jun 2012 by Ismael Almonte

Adding an http security header to web reference and using Oracle CRM stateless

.NET

Oracle

Dev

Adding Permissions to Add/Edit Data Models and Add Reports in BI Publisher 12c

20 May 2016 by Khrystyna Popadyuk

Provides steps to add permissions to adding or editing data models or adding reports in Oracle BI Publisher 12c.

Oracle

Adding table names in oracle database to combo box in visual studio 2012

13 Feb 2016 by Nareen Nair

I have tried to display the names of table in oracle database in visual studio 2012 in combo box but i am not sure why it is not displayingprivate void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { try { con.Open(); ...

Oracle

Visual-Studio

Adding table names in oracle database to combo box in visual studio 2012

14 Feb 2016 by KaraUgur

Hello Nareen,i would suggest that your SQL statement is false.afaik this is MySQL and won't work with an OracleDBSELECT table_name FROM tabs where table_name...For Oracle you need this line of code (PL/SQL)SELECT table_name, owner, tablespace_name FROM all_tables where table_name...

Oracle

Visual-Studio

Adding table names in oracle database to combo box in visual studio 2012

14 Feb 2016 by Nareen Nair

private void Form2_Load(object sender, EventArgs e) { try { con.Open(); OleDbDataAdapter oda = new OleDbDataAdapter("SELECT table_name FROM tabs where table_name Not Like 'S%' AND table_name Not Like 'L%'", con); ...

Oracle

Visual-Studio

ADF popup disappear on filtering data

27 Mar 2022 by Muhammd Aamir

I have been implementing a popup on button click, however when I want to filter the data, Like in highlighted snap & press ENTER the popup disappear. The issues is on every popup. I am using 12.2.1.4.0 version of Jdeveloper. Please help to get...

Oracle

JSP

ADO can't connect oracle database in OS Authenticated mode

14 May 2014 by chinaprogramer

I have a question, I use c++ connect oracle database,i want use OS Authenticated to connect the oracle database,but i always failed,I have try many means to try,but all are can't do it.these are i had use ,but can't do it.OLE DB Provider for Oracle (from Oracle).For Standard...

C++

Oracle

ADO

ADO.Net - How to Check existence of a table in Oracle

18 Sep 2013 by Member 10454592

I got a piece of code to check the existence of a table from . This is applicable for [^]. The revised code for OleDB is below:public bool CheckTableExist(OleDbConnection conn, string tblName){ bool b = false; string[] restrictions = new string[] { null, null, tblName }; ...

Oracle

table

ADO.Net - How to Check existence of a table in Oracle

18 Sep 2013 by hypermellow

You can usually find this in Oracle by checking the user_tables object.Something like this should do it:SELECT COUNT(table_name) FROM user_tables WHERE table_name='tlbNameToCheckFor'

Oracle

table

ADO.NET connect string for Oracle 11g Express Edition

18 Dec 2011 by CNU

I am trying to connect to a database on Oracle 11g Expres Edition. The following connect string is not working:All the...

Oracle

ADO.NET

ADO.NET connect string for Oracle 11g Express Edition

19 Dec 2011 by Not Active

Have you tried www.connectionstrings.com[^]?

Oracle

ADO.NET

ADO.NET connect string for Oracle 11g Express Edition

19 Dec 2011 by Om Prakash Pant

this might helphttp://www.connectionstrings.com/oracle[^]

Oracle

ADO.NET

ADO.NET connect string for Oracle 11g Express Edition

19 Dec 2011 by Wendelius

Defining simply IP address isn't enough for Oracle. You have to define a name that is defined in your TNSNAMES.ORA description file. Typically in XE installatoins this is simply XE

Oracle

ADO.NET

ADO.NET DataTable as XML parameter to an Oracle/SQL Server Database Stored Procedure

27 Jan 2010 by Bibhas Paul

ADO.NET DataTable as an XML parameter to an Oracle/SQL Server database Stored Procedure.

ADO.NET Interview Questions: Part 1

20 Mar 2012 by Shivprasad koirala

Ado Dot Net Interview Question Part 1

After insert Trigger Update Problem

12 Feb 2011 by kumar_jadhav

Hello Friends currently i am Working on one Banking project...And my problem Regarding Trigger i.e..CREATE OR REPLACE TRIGGER INSERT_BRANCH_CODEAFTER INSERT on DPMASTERFOR EACH ROWDECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGINUPDATE DPMASTER SET BRANCH_CODE = (SELECT...

Oracle

After insert Trigger Update Problem

10 Feb 2011 by Praveen Kumar Upadhyay

I didn't get the meaning that your SYSPARA table contain only one record.ok what i got from your code and from your explanation I am sending you the code, please check it...If your problem is, you want to update each BRANCH_CODE of DPMASTER by newly inserted BRANCH_CODE of SYSPARA table...

Oracle

After insert Trigger Update Problem

10 Feb 2011 by Wendelius

Hi,Instead of updating the new record, could you simply use BEFORE INSERT trigger and set the value of the BRANCH_CODE without autonomous transactions. I.e. your trigger could be something like:CREATE OR REPLACE TRIGGER INSERT_BRANCH_CODEBEFORE INSERT on DPMASTERFOR EACH ROWBEGIN...

Oracle

Aggregate data in oracle day wise or week wise or month wise

12 Oct 2017 by planetz

Hi All, I could not explain my problem in my last question so I am posting a fresh question. I have a table: ename | edate emp1 | 01-10-17 emp1 | 01-10-17 emp1 | 01-10-17 emp1 | 02-10-17 emp2 | 01-10-17 emp3 | 01-10-17 emp3 | 01-10-17 emp3 | 02-10-17 emp3 | 02-10-17 Expected output after...

Oracle

Aggregate data in oracle day wise or week wise or month wise

12 Oct 2017 by Maciej Los

[EDIT] If you would like to get only these data where count is bigger than 1, you can use HAVING clause[^] to limit result set as a source of pivot. SELECT ename, edate, COUNT(*) AS CountOfDates FROM tblName GROUP BY ename, edate HAVING COUNT(*)>1 As to your second question: there's a way to...

Oracle

Aggregate data in oracle in specific no of days

13 Oct 2017 by planetz

Hi All, My table has data like: country date count India 01-10-2017 49 USA 03-10-2017 42 Japan 04-10-2017 55 Russia 01-10-2017 87 UK 02-10-2017 17 UAE 03-10-2017 13 Australia 04-10-2017 63 India 01-10-2017 38 USA 02-10-2017 67 USA 03-10-2017 73 Japan 01-10-2017 70...

Oracle

Aggregate data in oracle in specific no of days

13 Oct 2017 by Maciej Los

Check this: Aggregate data in oracle day wise or week wise or month wise[^]

Oracle

Aggregate function and then group by query

21 Jun 2013 by wonder-FOOL

Hello I have a query which gives me the following result:Company FileCount Type TotalABK 233 SEA 39610ABK 452 AIR 63280ABK 2683 GROUND 375620OPL 675 SEA 114750OPL 11 ...

Oracle

Aggregate function and then group by query

21 Jun 2013 by gvprabu

Hi,Check the below code...DECLARE @Test TABLE (Company VARCHAR(10), FileCount INT, Type VARCHAR(20), Total NUMERIC(10,0))INSERT INTO @Test(Company,FileCount,Type,Total)SELECT 'ABK',233,'SEA',39610UNION ALLSELECT 'ABK',452,'AIR',63280UNION ALLSELECT...

Oracle

Aggregate Product function extends SQL

19 Feb 2015 by DrABELL

Technique to extend capability of standard SQL by adding the Aggregate Product Function

Ajaxauto complete with oracle database (c#) Error

22 Mar 2013 by akash02asp

This code is Getting Executed but when i type a letter in textbox it pops System.Data.DataRow[System.Web.Script.Services.ScriptMethod()] [System.Web.Services.WebMethod] public static List GetName(string prefixText) { OracleConnection con = new...

Ajax

Oracle

ASP.NET

Ajaxauto complete with oracle database (c#) Error

21 Mar 2013 by Sivakrishna Donepudi

What is the error you getting ? seems to be code correct but I have one suggestion use foreach instead of for loop.

Ajax

Oracle

ASP.NET

Ajaxauto complete with oracle database (c#) Error

22 Mar 2013 by akash02asp

dt.Rows[0].ToString() ---> dt.Rows[0][i].ToString()Solved.Thank you ThePhantomUpvoter.

Ajax

Oracle

ASP.NET

Ajaxauto complete with oracle database (c#) Error

22 Mar 2013 by akash02asp

Solved Codeusing System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Configuration;using System.Data.OracleClient;using System.Data;public partial class ajaxautocomplete :...

Ajax

Oracle

ASP.NET

Alibaba Cloud Object Storage vs. IBM Cloud and Oracle Cloud Equivalent

5 Jan 2018 by Brien M. Posey

In this article, we compare the object storage offerings of each of these cloud providers.

cloud

Oracle

alter column data type preserving stored data

16 Dec 2012 by mido_h_89

hello everybody ...I have an oracle 10g db ,I want to modify a column datatype in a table , this column is not empty , it contains some data , I was advised to create a new column , move the old data to it , modify the old column data type , then return the data back to this column ... Is this...

Oracle

alter column data type preserving stored data

16 Dec 2012 by Jörgen Andersson

No need to copy the data twice. Have a look at this tiny script:ALTER TABLE mytable ADD new_column VARCHAR2(64); --exchange 64 for the size you needUPDATE mytable SET new_column = old_column;ALTER TABLE mytable DROP COLUMN old_column;ALTER TABLE mytable RENAME COLUMN new_column to...

Oracle

Alternate to unpivot for oracle 10g

30 May 2019 by Member 13094043

I am using unpivot to convert my result columns as rows. which is working fine on oracle 12c but i need to run the same script on lower version of oracle i.e 10g. so need an alternate way to do that as oracle 10g doesn't support unpivot operator. Below is the code which i am using. What I have...

SQL

Oracle

database

Alternate to unpivot for oracle 10g

30 May 2019 by CHill60

There are alternatives discussed on this article … Columns to Rows[^] at Oracle Knowledge Share

SQL

Oracle

database

Alternative tnsping utility

3 Jan 2013 by hevesir

Alternative tnsping for Oracle Instant Client.

Always use Binding Variables in SQL queries

19 Apr 2011 by Amit Kumar Tiwari

Boost application speed and performance

Always use Binding Variables in SQL queries

28 Apr 2011 by reshi999

Thanks for that. In MS SQL Server, I use the following technique to avoid full compile:DECLARE @sql VARCHAR(100)DECLARE @pk INTSET @pk = 2SET @sql = 'SELECT id, pcname FROM pod WHERE id = ' + CAST(@pk AS VARCHAR)EXEC (@sql)-- or -- EXEC sp_sqlexec @SQL

Ambiguous column error in create query

25 Apr 2020 by Surabhi Tripathi

CREATE TABLE WC_COVID1 AS SELECT '1060' COMPANY_CODE, 'AP' STATE_CODE, WC_POS_ITEM_F.X_DRC_CODE MARKET_CODE, 'AP' MARKET_NAME, 'AP' PPAC_DIST_CODE, 'AP'DISTRICT_NAME, W_INT_ORG_D.X_SAP_ID DISTRIBUTOR_CODE, W_INT_ORG_D.X_NAME,...

SQL

Oracle