Αποτελέσματα Αναζήτησης
3 Ιαν 2013 · You can just include null as a recognised value in your decode: col scr new_value script. set term off. set verify off. select decode('&partitions', null, 'CreateTables', 'CreateTablesPartitions') as scr from dual; set term on.
1 Ιουν 2023 · Oracle DECODE Function with NULL Values. As I mentioned above, the Oracle DECODE function is an exception to other functions in how it handles NULL values. It treats a NULL expression and NULL search as equal (so NULL == NULL). So, this example will return 1: SELECT DECODE(NULL, NULL, 1, 0) FROM DUAL;
28 Μαΐ 2012 · It is that ENTIRELY null entries are not made into a b*tree. If you have a concatenated index (on more then one column) and AT LEAST one of the columns is not null -- that'll find it's way into the index. Consider:ops$tkyte@ORA920> create table t ( f_seq int, t_seq int, x char(1) );Table created.
14 Ιουν 2007 · How can I check if a field is not null in a decode statement. select decode(field1, not null, 'Y', 'N')
9 Ιαν 2014 · Could anyone tell me which of the following statements would perform better? SELECT 1 FROM DUAL WHERE NVL (NULL, '-1') = NVL (NULL, '-1') SELECT 1 FROM DUAL WHERE DECODE (NULL, NULL, '1', '0') = '1'. Both will evaluate nulls as being equal.
6 Σεπ 2016 · DECODE. In a DECODE function, Oracle considers two nulls to be equivalent. If expr is null, then Oracle returns the result of the first search that is also null.
27 Απρ 2005 · I'd like to use a decode function with a NOT NULL condition as below: select decode(std_id, NOT NULL, decode(std_name,null, 'error'),concat(std_id,std_name)) from std_tbl;
