This article helps in identifying database design issues like certain fields missing, nullable fields, Primary key not found issues in production environment using SQL Server schema views.

SQL

Oracle

SQL-Server

Design

SysAdmin

Dev

Highly Effective Data Insertion at Case of Oracle DB

31 Oct 2016 by SlavaUtesinov

EF implementation of BulkInsert operation and "Arrays in a Bind" solution at case of absence of EF.

entity-framework

Oracle

Run Database and GUI Clients in Docker

6 Jul 2022 by DiponRoy

Quick start example to run DB and clients in docker

An Oracle OCI Data Source Class for Ultimate Grid, Part 2 - Building the OCI Data Source Class

22 May 2014 by djc2032

A three-part series demonstrating how to develop an Oracle Call Interface (OCI) custom data source for Ultimate Grid

Oracle-Style Global Temporary Tables for PostgreSQL

20 Mar 2017 by AlexeyYakovlev

A library to emulate Oracle-style permanent temporary tables in the PostgreSQL database

SQL

PostgreSQL

Oracle

Logging information in Oracle

30 Apr 2012 by Wendelius

This article describes techniques such as autonomous transactions and action information that can be used when logging information about operations in Oracle database.

Facade to disparate databases

19 Sep 2013 by G3Coder

Details using an ORM model to provide a common facade to multiple disparate databases.

Learn about Stored Procedures

14 Aug 2019 by essentialSQL

In this blog post, you will learn about stored procedures

Use of columns belonging to tables referenced on main query in a subquery

17 Feb 2011 by John Gathogo

Catastrophic results associated with unqualified use of columns belonging to tables referenced on main query in a subquery

Oracle 11g Report Installation on RedHat Linux 5x

22 Nov 2011 by Srivalsalakumar

Oracle 11g Report Installation on RedHat Linux 5x

Oracle

DBA

Encrypt Personal Data in Database using Bouncy Castle and Java Simplified Encryption

13 Feb 2012 by Chinthala Upender

Bouncy Castle provide encrypt/decrypt your personal data such as password, SSN, credit card numbers etc. using Simple JASYPT framework.

Java

Windows

Oracle

Reason to not use nullable number in Oracle?

22 Aug 2012 by Christian Graus

You said it all. They used to use VB6. They are morons. I am in the same hell, magic values, no use of null, etc. No, they are wrong.

VB6

Oracle

null

how to refer sequence without using sequence name

23 Oct 2013 by Amir Farid

hiuse dynamic query like this:declare seqName varchar2(100); seqVal number;begin execute immediate "select " || seqName || ".nextval from dual" into seqVal;end ;/

Oracle

how to join two tables in oracle11g and assign a dynamic coloum

4 Nov 2013 by Amir Farid

Hiyou can use nested query and DECODE() function for solve this problem, like this :select i.ISREQUEST, i.ISREQUESTTYPEID, i.ISREQUESTDATE, decode((SELECT count(*) from asas.tbl_isinterrogators s where s.isrequest = i.ISREQUEST ...

Oracle

What is the difference between CHAR(2) and CHAR(2 CHAR)?

12 Mar 2014 by CHill60

This comes down what is meant by a "character". Typically (historically) a character would have been stored in a single byte. Nowadays you can have multi-byte characters (e.g. chinese characters can be stored on the database). In order to ensure that the database can handle these and...

Oracle

How to Get current time zone in SQL and Oracle

7 May 2014 by Kornfeld Eliyahu Peter

You can use DBTIMEZONE or SESSIONTIMEZONE for that...http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions143.htm[^]http://psoug.org/definition/DBTIMEZONE.htm[^]

Real-time Oracle Database Monitoring Dashboard in ASP.NET

29 Sep 2014 by Omar Al Zabir

Oracle Performance Dashboard (OPD) is a small ASP.NET website that shows you performance & problems of one or more Oracle instances in near real-time. It uses the Dynamic Performance Views (DPV) and runs some popular DBA scripts in order to get meaningful, easy to understand information out of the s

Freeing Locks on an Oracle Database

23 Jun 2016 by jonyj

Queries and commands to discover what's locking the database

SQL

Oracle

User convert a number to have 2 decimal places in oracle

N 12 Apr 2024 by Richard Deeming

You're confusing a number with the string representation of a number. A number is just the digits that make up the number. There is no difference between 1234 and 1234.00 - they're both the same floating-point number. Databases shouldn't be...

Oracle

Dynamic Where Clause in Oracle 11g stored procedures

6 Feb 2011 by Kaveh Yazdi Nezhad

we are going to see how we can make a nice code to make search inside an oracle spc

Oracle

Using Asynchronously in .C# to Oracle database

31 Mar 2011 by Dylan Morley

If you're on .Net 4.0, you can use Tasks and Continuations to wrap your data access. E.g.var context = TaskScheduler.FromCurrentSynchronizationContext();var task = Task.Factory.StartNew(() =>{ DataTable data = SomeSortOfDatacontext.GetOrders(); return...

Oracle

How to display to exact database value in C# coding.

31 May 2011 by Toniyo Jackson

Try this in stored procedure. It should work.SELECT ROUND(columnname, 2, 1) from tablename // 2 is decimal place

SQL-Server

Oracle

ASP.NET

how to connect oracle9g database to c# web application

9 Jun 2011 by nitin bhoyate

For Connection Strings issue visitADO Connection Strings[^]and For Oracle Connectivityhttp://www.startvbdotnet.com/ado/oracle.aspx[^]Very good step by step...

Oracle

ASP.NET

copy data between 2 oracle tables

17 Jul 2011 by Espen Harlinn

Use oracle ODAC[^] and OracleBulkCopy[^] - if this doesn't do the trick, you're out of luck. If those 28000 doesn't contain a lot of blobs, you should be able to create something that does the job in well under a minute, maybe in less than 10 seconds.Best regardsEspen Harlinn

C#3.0

Oracle

sectiongroup problem in web.config

24 Oct 2011 by Espen Harlinn

My guess is that you'll find the 'oracle.dataaccess.client' sectionGroup in the[Windows directory]\Microsoft.NET\Framework\[Framework Version]\CONFIG\machine.config file.Adding it to your web.config file causes it to be defined twice.You can read about the asp.net configuration files...

C#2.0

Oracle

ASP.NET

Drop table using Function or procedure.

7 Nov 2011 by thatraja

Try thisDrop All Tables in a Single Query[^]

Oracle

Suggestion for Application Architecture

28 Dec 2011 by #realJSOP

0) Use SQL Server for the database.1) Create your app in the form of either a asp.net web page or a Silverlight module.Writing desktop apps that require deployment adds to the cost. A web site can be accessed by hundreds of users simultaneously, and if deisgned appropriately, it can allow...

Suggestion for Application Architecture

28 Dec 2011 by Wendelius

First question I'd ask is what tools, environments, languages etc you're familiar with. The second thing are the requirements. Do you need access to local (client side) resources (disks, drivers etc) or programs (Office interop and so on).Those two should narrow down the possibilities. If no...

Solving ORA-01882: timezone region not found

26 Mar 2012 by Wael Al Wirr

Solving the ORA-01882 error.

Solving operating system version: must be 5.0, 5.1, 5.2. Actual 6.1 Failed

26 Mar 2012 by Wael Al Wirr

Installing sqldeveloper on windows 7 64bit

how to take backup in oracle 10g

29 Aug 2012 by Prasad_Kulkarni

Refer:Backup and Recovery[^]Backing Up and Recovering Oracle Application Server 10g[^]Taking backup of Database in Oracle 10g Express edition[^]

Oracle

unable to open the database connection using OracleClient and OracleDbVersion 11.2.0 64 bit

2 Sep 2012 by Mohamed Mitwalli

Hi ,Make sure you add reference Oracle.DataAccessusing Oracle.DataAccess.Client;using Oracle.DataAccess.Types; string oradb = "Data Source=(DESCRIPTION=" + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.1)(PORT=1521)))" +...

Want help for SQL Query

22 Dec 2012 by __TR__

TrySELECT P.Id, P.Name, P.Amount FROM person PINNER JOIN ( SELECT Min(Id) AS Id, Name FROM person GROUP BY Name) T ON P.Id = T.Id

SQL

Oracle

MySQL

Sum Of Two Tables Using Join

29 Jul 2013 by Maciej Los

Try this:DECLARE @INSTOCK TABLE (WareHouse INT, Code VARCHAR(30), Qty INT)INSERT INTO @INSTOCK (WareHouse, Code, Qty)SELECT 1, '0001', 5UNION ALL SELECT 1, '5555', 4UNION ALL SELECT 2, '0001', 6UNION ALL SELECT 3, '0001', 2UNION ALL SELECT 3, '4444', 2 DECLARE @OUTSTOCK...

cannot implicitly convert type 'int' to 'system.data.dataset'

14 Aug 2013 by Ron Beyer

ExecuteNonQuery returns an integer of the number of rows/records affected by the operation. Instead of using ExecuteNonQuery you need to use ExecuteReader.ExecuteNonQuery -> Used for Updates, Inserts and Deletes mostly.ExecuteReader -> Returns a data reader that can load records, for...

Oracle

ASP.NET

database

SQL loader using in C# for text file data to database

24 Dec 2013 by Richard MacCutchan

You have called the Start method, before you set up the StartInfo properties.

Oracle

ASP.NET

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

Is it possible to inject(SQL Injection) if password is encrypted.If yes than How.

29 Oct 2014 by OriginalGriff

We do not condone, support or assist in the production of malicious code in any way, form or manner. This is a professional site for professional developers. If you want to know how to create such things, you need to visit a hacking site: but be sure to disable all firewalls and antivirus...

Oracle

ASP.NET

SQL data convert column to row values

18 Mar 2015 by Jörgen Andersson

This solution is quite generic.It works with gaps in your primary key as well as being very easy to change the number of columns in the query.Manchanx solution should be faster though.WITH ordered AS ( SELECT name ,Row_Number() OVER (ORDER BY name) -1 AS rn --change the...

SQL

Oracle

ANSI left join & left join(+)

1 Apr 2015 by Richard Deeming

Difference between Oracle's plus (+) notation and ansi JOIN notation?[^]The + syntax is older, and is only included for backwards-compatibility. It also has some restrictions which the ANSI JOIN syntax doesn't have.Oracle recommend[^] that you only use the ANSI syntax.

SQL

Oracle

Oracle 12c Installation on Windows 7 (Step by Step Solution)

5 Sep 2015 by Sadique KT

How to Install Oracle 12c, How to create listener, How to create TablesSpaces and How to restore database

Win7

Windows

Oracle

find the solution for this sql query

10 Sep 2015 by jaket-cp

I understand that this is SQL Oracle question.But I have not touched Oracle in more than a decade, so here is a way of doing it in tsql :)Hopefully you should be able to convert to be useful in Oracle.with employee as (--setup dummy data select 1 empno, 'A' ename, 7000...

SQL

Oracle

Uechi APM Web is an APM (Application Performance Management) Open Source Server Performance Monitor

7 Oct 2016 by Paulo Uechi

Uechi APM Web is an APM (Application Performance Management) Open Source Server Performance Monitor written and developed in Java and C # for all Linux and Windows platforms. The Uechi.APM.Web offers a complete resource for unlimited monitoring servers in real time. Have full control of the CPU cons

How do I load missing DLL

31 Jan 2017 by #realJSOP

Set the project's target to x86.

.NET2.0

Oracle

exceptions

What’s the Difference between a Full Index Scan and a Fast Full Index Scan in Oracle?

13 Jul 2017 by Wendelius

This is an alternative for "What’s the Difference between a Full Index Scan and a Fast Full Index Scan in Oracle?"

Issues after Upgrade to SQL Server 2017 – Cannot Bulk Load Data Into the Table with Primary Key Constraint on it

11 Jul 2018 by Satnam Singh CapGemini

Cannot Bulk Load Data Into the Table with Primary Key Constraint on it

Calling Oracle's Stored Procedures and Mapping User Defined Types (UDTs) from ASP.NET

26 Sep 2018 by MattiLindroth

An example on how to call Oracle stored procedures with UDTs from ASP.NET MVC / REST API

Data Visualization using Matplotlib

24 Apr 2019 by Azim Zahir

This article demonstrates Data Visualization using Matplotlib library of Python.

Country, State/Region/Province and City Database for a new site

27 Jan 2020 by Jörgen Andersson

Freely, your best bet is: https://en.wikipedia.org/wiki/ISO_3166-1 the list has clickable subdivisions, so it involves a bit of work. Same goes for this one: http://www.unece.org/cefact/locode/subdivisions.html You can also get it straight from the source here:...

SQL

Oracle

MySQL

Ambiguous column error in create query

25 Apr 2020 by MadMyche

Some simple formatting of your code shows the FROM portion to have 2 references to the same table with the same alias; any calls to elements from this table naturally are going to be confused FROM WC_POS_ITEM_F WC_POS_ITEM_F , ...

SQL

Oracle

Convert a string to a number in oracle

14 Feb 2022 by CHill60

To convert a string to a number in Oracle you use the Oracle / PLSQL: TO_NUMBER Function[^] (Try using your favourite search engine with the phrase "oracle convert string to number") Your problem, as Maciej has pointed out, is that "1.234.56" is...

Oracle

Use SQL to generate large data sequence

19 Feb 2015 by DrABELL

Generate large data series by using Cartesian Product and small data table

Reset PLSQL sequence value

24 Dec 2010 by Shahriar Iqbal Chowdhury/Galib

Reset PLSQL sequence value

difficult question when insert to DB oracle

5 Mar 2011 by CS2011

If i understand your qustion there is two form say form1 and form2 and whenever you insert some data into database using form1 it should be reflated on form2.If this is the case then you will need to use InotifyPropertyChanged interface.for deatils you can check this...

.NET

Oracle

ASP.NET

Asp.NET Web Project include Oracle

4 May 2011 by Ankit Rajput

Hi,Please go through with this article for PL-SQLPLSQL in Oracle.NET Framework Data Provider for Oracle It will help you.RegardsAR

Oracle

how to connect oracle9g database to c# web application

9 Jun 2011 by Kim Togo

Connection strings for Oracle[^], start there :-)

Oracle

ASP.NET

how to check remaining date?

10 Jun 2011 by Sergey Alexandrovich Kryukov

A date cannot be "remaining". Remaining can be the time span, for example from the current time to some stated date such as deadline. Here is how can it look in C#:int RemainingDays(System.DateTime setTime) { //setTime is from your data base System.TimeSpan span = System.DateTime.Now...

Oracle

ASP.NET

How to configure Oracle execute concurrently ?

12 Jun 2011 by Dave Kreskowiak

Adding threads won't help you. Adding more threads than you have cores is even worse.Changing the client version won't make anything faster. The problem is with your technique.Setup your data in whatever container you need to to use Oracles Bulk Insert[^].

Oracle

how to display image from oracle blob data

16 Jul 2011 by thatraja

Here you goFix linksCannot access a closed file[^]ObjectDisposedException - Cannot Access a Closed File[^]ObjectDisposedException - Cannot access a closed file[Solved][^]cannot access a closed file – FileUpload in ASP.NET[^]Read / Write BLOBs from / to Oracleusing C# .NET...

From where to download oracle.dataaccess.dll 2.102.2.20 version

17 Jul 2011 by DaveAuld

Visit this page;http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html[^]Then scroll down until you find the package that contains the DLL with the version you want. Its the second last package at the time of looking :).

Oracle

which datatype can accept the space in oracle?

4 Aug 2011 by Shameel

VARCHAR2 is the ideal data type to store text data.

Oracle

Windows authentication with WCF Service not working - ORA-01017: invalid username/password

6 Oct 2011 by Simon Bang Terkildsen

Now I'm not sure, but I beleave the account used as login to oracle is the one which runs the service not the one which has called the service.You should look into impersonationhttp://msdn.microsoft.com/en-us/library/ms730088.aspx[^]So in you WCF method do something like the below (taken...

Silverlight4

Oracle

WCF

Need help for SQL query

8 Sep 2011 by Wendelius

To add to Vikash answer:Don't use * in the SELECT clause. For example if a column is added to one of the tables, your query would fail since in UNION all the select statements must return exactly same number of columns and same data typesAnother thing. Don't use literals in the query if...

SQL

Oracle

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

30 Oct 2011 by Marvin Bland

The other option to review when you receive this error is to view your Application_Pools setting for the app_pool you are using for your application.Check the "Enable 32-Bit Applications". If this is "False", change it to "True". This may resolve your issue.

Oracle

ASP.NET

data fetching from oracle

13 Nov 2011 by thatraja

manita nangla wrote:how can i fetch bulk of data from oracle9i in asp.net in vb and show in a label?Are you kidding? Are you sure to show the bulk data in a single label?I think you want this one.Bulk Operations Using Oracle Data Provider for .NET (ODP.NET)[^]

Oracle

ASP.NET

Large CSV File creator in C#

14 Dec 2011 by Wonde Tadesse

Once you fetch the table data from the Oracle database, you can export the it similar way which is shown in the sample link.How to export data to CSV file in ASP.NET[^]NOTE: In order to fetch the exportable data, you may need to use Oracle data provider(ODP)[^] to .Net Framework. Here is...

Oracle

ASP.NET

Large CSV File creator in C#

15 Dec 2011 by Morteza Karimian Kelishadrokhi

you can try this. if this work better then use of it.private string ExportToCSV(DataTable DataTable, string path) { string fullpath = ""; fullpath = path; StreamWriter SW; SW = File.CreateText(fullpath); System.Text.StringBuilder...

Oracle

ASP.NET

find the 3rd column (all the data along with column name) in a table

9 Feb 2012 by Christian Graus

If you select all the data, and move to the third colum in the construct that contains it, then you can find the data in the third column. This[^] is apparently how you find column names. Note: I don't use Oracle, I just know how to google.

SQL

Oracle

Error generated while creating table in oracle

21 Feb 2012 by krumia

If you Googled ORA-00904 and followed the first link, you would have seen this:ORA-00904: string: invalid identifierCause: The column name entered is either missing or invalid.Action: Enter a valid column name. A valid column name must ...

Oracle

LPAD and RPAD functions in SQL

15 Mar 2012 by Member 10510822

LPAD and RPAD function works for padding in SQL Server

To Find the difference between two dates

26 Mar 2012 by Pablo Aliskevicius

The answer is hidden in the documentation for LAST_DAY:http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions072.htm#i83733[^]From there:SELECT SYSDATE, LAST_DAY(SYSDATE) "Last", LAST_DAY(SYSDATE) - SYSDATE "Days Left" FROM DUAL;The result is:SYSDATE Last...

SQL

Oracle

How to execute 3 Commands (SQL statements) to oracle tables at one shot?

24 Apr 2012 by Pete O'Hanlon

What you are actually looking to do is wrap them in a transaction. Fortunately for you, the OracleConnection class provides a BeginTransaction method (this returns an OracleTransaction). Simply call all your commands inside this connection, then call Commit() to save the changes if they execute...

Oracle

how to union two table with different datatype

15 May 2012 by Sandeep Mewara

Will this do:SELECT table1ColA AS COL1, table1ColB AS COL2, "" AS COL3, "" AS COL4FROM Table1UNIONSELECT "" AS COL1, "" AS COL2, table2ColA AS COL3, table2ColB AS COL4FROM Table2

MySQL

Oracle

SQL-Server

erd relationship types

22 May 2012 by Wendelius

If the management board is one entity and contains the management board and the year, for example (name+year is unique, id is primary key)managementboard---------------idnameyearand the person references a single management board, for example (managementboardid+name is...

Oracle

what is the sequence for learning to be a good .net web developer?

5 Jun 2012 by codeBegin

There's nothing like one thing is important and other is not. Each and every thing is important because you are a learner. Each thing gonna give you an experience you have to decide whether it was a good experience or not.You can start learning from basic languages like C, C++Refer some...

Query optimization in Sql

19 Jun 2012 by Tim Corey

Listing out each column name is the way you need to do it in order to have an optimized query. However, that doesn't mean you need to type it all out. You've listed a number of different SQL flavors (Oracle, MySQL, MSSQL, etc.) so this will be a bit different for each but in Microsoft SQL in...

Career Change from .net to informatica

26 Jul 2012 by Sandeep Mewara

This is not a programming question. More of a discussion/guidance. My suggestion would be to do what you like. Risks are always attached to everything. Better to post in Lounge[^] or similar discussion forum to get insights of experienced people.

C#2.0

Oracle

WinForms

How to connect java and Oracle?

1 Aug 2012 by Aditya Mangipudi

Have you registered the driver?DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());Try Following these steps (Check if you missed anything):1) Import the following packages in your java file:***********import java.sql.*;import oracle.jdbc.driver.*;import...

Java

Oracle

How can i find a part of a value from sql table

8 Aug 2012 by Santhosh Kumar Jayaraman

http://sqlserver2000.databases.aspfaq.com/how-do-i-search-for-special-characters-e-g-in-sql-server.html[^]

SQL

Oracle

How can i find a part of a value from sql table

8 Aug 2012 by _Amy

You should use LIKE[^] operator to get the specified data from database.Read more about LIKE here[^].--Amit

SQL

Oracle

how to create a stored procedure in oracle

16 Aug 2012 by Wendelius

Seems that either your call is wrong or you don't have the priviliges to execute the procedure.If you're executring the procedure from outside the package, the call should be something like:execute counttable.samplecount(the parameter for the cursor);You may also need to define the owner...

Oracle

Reason to not use nullable number in Oracle?

22 Aug 2012 by Wendelius

In my opinion, no valid reasons exist. The sole purpose of null value is to describe that the is no data or the data is unknown.I could imagine that this has been reasoned because of the indexing, foreign key and constraint related 'issues' but those things can quite easily be tackled with...

VB6

Oracle

null

Reason to not use nullable number in Oracle?

22 Aug 2012 by Sergey Alexandrovich Kryukov

A person who uses something like -5000 as a special magic value to conduct "not a value" is a complete idiot and moron. Actually, using VB6 does not have any excuses. The only reason to use it I can see is to sabotage.Here is one of the most difficult issue of your profession: one of your...

VB6

Oracle

null

inserting a query into DB

14 Sep 2012 by CPallini

I think you missed the closing brace instead.insert into sms_regis_info values('C0006','STU012001','JAVA',to_date('30/08/2012','DD/MM/YYYY'));

Oracle

How can i get only month from a field using sql query?

26 Sep 2012 by fjdiewornncalwe

You can use the DATEPART function to get the month number or DATENAME function to get the month name.select datepart(month,Mydate), datename(month,Mydate)Source[^]See Solution 2 for the oracle answer. (I didn't see that tag, sorry)

SQL

Oracle

backup of oracle 9i database

26 Dec 2012 by Sandeep Mewara

Have a look at the results returned from the following search[^]Top 3: http://en.kioskea.net/faq/6236-oracle-9i-database-backup[^]www.oracle.com/pls/db92/to_pdf?partno=a96519[^]http://www.orafaq.com/wiki/Oracle_database_Backup_and_Recovery_FAQ[^]

Oracle

How can i find the third highest value in a table?

9 Jan 2013 by Maciej Los

You need to use one of the ranking functions[^].For example, you can use ROW_NUMBER(). Try this:DECLARE @myTable TABLE (aValue INT)INSERT INTO @myTable (aValue)VALUES(123)INSERT INTO @myTable (aValue)VALUES(456)INSERT INTO @myTable (aValue)VALUES(789)INSERT INTO @myTable...

SQL

Oracle

database

Pass DateTime from c# to oracle

26 Feb 2013 by OriginalGriff

Just pass it as a DateTime using Oracle Parameter.AddWithValue[^] - you should not convert datatypes unnecessarily, so if the target accepts DateTime values (and all DB's do) then it is pointless converting it and introducing the possibility of errors due to incompatible formats.

Oracle

Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies. An attempt was made to load a program with an incorrect format.

2 Mar 2013 by Jörgen Andersson

The "incorrect format" is pointing to that you have a 32 bit oracle client on a 64 bit server or that you're running the application pool in 32 bit mode with a 64 bit client.Try to open your IIS Manager and click on "Application Pools" in the left pane.Right click the application pool your...

Oracle

ASP.NET

Examining the "Where" clause of a SQL in C#

5 Mar 2013 by Zoltán Zörgő

Statement parsing is quite complicated. Since you need to follow the syntax of that specific implementation. Even those implementation claim to be SQL:2001 compliant for example, for sure there will be considerable differences in the syntax. Thus for a complex and really robust solution, you...

SQL

Oracle

ASP.NET

connection code, SELECT, UPDATE, DELETE query

21 Mar 2013 by Sudhakar Shinde

Not sure why do you want to have seperate classes for DML operations as you can write separate methods for it. Please check this LINK which explains the basics of JDBC.Cheers,Sudhakar

Java

Oracle

converting date from mm/dd/yyyyy to dd/mm/yyyyy

5 Apr 2013 by Kenneth Haugland

You usually find all you need from the documentation :-)http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx[^]

Oracle

SUM on a column query

17 Apr 2013 by Maciej Los

Try it:SELECT SUM(P.ITEMAMOUNT) AS AMOUNT, P.COMPANYID AS COMPANY, SUBSTR(P.ACCOUNTID, 1,5) AS ACCOUNTFROM PRODUCTS P INNER JOIN ACCOUNTS A ON P.COMPANY = A.COMPANY AND P.ACCOUNTID = A.ACCOUNTIDWHERE P.ACCOUNTID LIKE '1%'GROUP BY P.COMPANY, SUBSTR(P.ACCOUNTID, 1,5)ORDER BY P.COMPANY,...

T-SQL

Oracle

Select query in oracle

20 Apr 2013 by Sudhakar Shinde

Please try below query..SELECT SUM(DECODE(STATUS_FLAG,'Y',1,0)) AS Success,SUM(DECODE(STATUS_FLAG,'I',1,0)) AS Processed,SUM(DECODE(STATUS_FLAG,'N',1,0)) AS PendingFROM TableName

Oracle