coalesce is supported in both Oracle and SQL Server and serves essentially the same function as nvl and isnull. (There are some important differences, coalesce can take an arbitrary number of arguments, and returns the first non-null one. The return type for isnull matches the type of the first argument, that is not true for coalesce, at least on SQL Server.)
Related Posts:
- Is there a combination of “LIKE” and “IN” in SQL?
- Selecting COUNT(*) with DISTINCT
- What is a stored procedure?
- Self Join to get employee manager name
- How do I UPDATE from a SELECT in SQL Server?
- SQL query to select dates between two dates
- When should I use CROSS APPLY over INNER JOIN?
- How can I do an UPDATE statement with JOIN in SQL Server?
- How do I escape a single quote in SQL Server?
- T-SQL split string based on delimiter
- How do I escape a single quote in SQL Server?
- IDENTITY_INSERT is set to OFF – How to turn it ON?
- Column name or number of supplied values does not match table definition
- Can a foreign key be NULL and/or duplicate?
- SQL Server FOR EACH Loop
- Each GROUP BY expression must contain at least one column that is not an outer reference
- PLS-00103: Encountered the symbol when expecting one of the following:
- DateTime2 vs DateTime in SQL Server
- How to parse XML data in SQL server table
- What is the equivalent of ‘describe table’ in SQL Server?
- Error converting data type varchar to float
- I want to use CASE statement to update some records in sql server 2005
- Conversion failed when converting the varchar value ‘simple, ‘ to data type int
- Must declare the scalar variable
- SELECT DISTINCT on one column
- Exclude a column using SELECT * [except columnA] FROM tableA?
- Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)
- ORA-06502: PL/SQL: numeric or value error: character string buffer too small
- TSQL PIVOT MULTIPLE COLUMNS
- SQL “select where not in subquery” returns no results
- Equivalent of Oracle’s RowID in SQL Server
- Is it possible to specify condition in Count()?
- SQL Server dynamic PIVOT query?
- How to write a foreach in SQL Server?
- Error converting data type varchar
- Temporary table in SQL server causing ‘ There is already an object named’ error
- I want to use CASE statement to update some records in sql server 2005
- How to calculate age (in years) based on Date of Birth and getDate()
- ORDER BY items must appear in the select list if SELECT DISTINCT is specified
- Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
- How can I group by date time column without taking time into consideration
- ORA-01779: cannot modify a column which maps to a non key-preserved table
- “select * into table” Will it work for inserting data into existing table
- SUM OVER PARTITION BY
- Update query using Subquery in Sql Server
- Varchar invalid for Sum operator
- What is an MDF file? [closed]
- What is the difference between varchar and nvarchar?
- LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- ORA-00904: invalid identifier
- LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- How to drop a table if it exists?
- SQL Server: Difference between PARTITION BY and GROUP BY
- Insert Data Into Temp Table with Query
- How to create Temp table with SELECT * INTO tempTable FROM CTE Query
- T-SQL split string
- Efficiently convert rows to columns in sql server
- Nested select statement in SQL Server
- ORA-01843 not a valid month- Comparing Dates
- Inserting data into a temporary table
- How to Select Top 100 rows in Oracle?
- CREATE VIEW must be the only statement in the batch
- ORA-12560: TNS:protocol adaptor error
- What is the meaning of the prefix N in T-SQL statements and when should I use it?
- Oracle Apex column link from LOV values
- What’s the difference between RANK() and DENSE_RANK() functions in oracle?
- Sql Server string to date conversion
- Operand type clash: int is incompatible with date + The INSERT statement conflicted with the FOREIGN KEY constraint
- Keeping it simple and how to do multiple CTE in a query
- ORA-01861: literal does not match format string
- Difference between numeric, float and decimal in SQL Server
- SQL Server Insert if not exists
- SQL Server: Invalid Column Name
- “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
- How to get a date in YYYY-MM-DD format from a TSQL datetime field?
- SQL Server IF NOT EXISTS Usage?
- How do I query for all dates greater than a certain date in SQL Server?
- String or binary data would be truncated. The statement has been terminated
- How to insert date values into table
- How to concatenate text from multiple rows into a single text string in SQL Server
- Count(*) vs Count(1) – SQL Server
- MS SQL compare dates?
- How do I reset a sequence in Oracle?
- Regex pattern inside SQL Replace function?
- Subtract one day from datetime
- MySQL equivalent of DECODE function in Oracle
- SQL: IF clause within WHERE clause
- Replacing NULL with 0 in a SQL server query
- SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
- Get everything after and before certain character in SQL Server
- Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
- LEFT function in Oracle
- What datatype should be used for storing phone numbers in SQL Server 2005?
- What are database constraints?
- Inner Joining three tables
- Comma separated results in SQL
- How do I view the Explain Plan in Oracle Sql developer?
- Filter data based on date in sql
- Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
- ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’