zelark

# Try it out. It works!

x = [[1,2], [3,4], [5,6]]
x = [x for x in x for x in x]

# x = [1, 2, 3, 4, 5, 6]

zelark

a = [[1, 2], [3, 4], [5, 6]]
b = [x for l in a for x in l]

# b = [1, 2, 3, 4, 5, 6]

zelark

import traceback

def foo():
    x = [1, 2, 3]
    print(traceback.extract_stack())

if __name__ == '__main__':
    foo()

zelark

def foo():
    x0 = [[1, 2], [3, 4], [5, 6]]
    y = [x2 for x1 in x0 for x2 in x1]
    print y

def bar():
    x = [[1, 2], [3, 4], [5, 6]]
    x = [x for x in x for x in x]
    print x

zelark

create table tmp_t1
(
  amount number,
  txt varchar2(50 char)
);

insert into tmp_t1
   (amount, txt)
 values
   (1, 'text 1');

zelark

select regexp_replace(str, '(foo|foos|fooes)', 'bar', 1, 1, 'i') as val
from   (select 'aa_fOo_bb' str from dual);

zelark

>>> my_list = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
>>> my_list
[1, 2, 3, 4, 5, 6, 7, 8, 9, 10]

zelark

# http://tech.blog.aknin.name/2010/04/02/pythons-innards-introduction/
# http://tech.blog.aknin.name/category/my-projects/pythons-innards/
# http://akaptur.github.io/blog/2013/08/14/python-bytecode-fun-with-dis/

# from vm import VirtualMachine
# vm = VirtualMachine()
# vm.byte_LOAD_CONST('a')
# vm.byte_LOAD_CONST('b')
# vm.byte_BUILD_LIST(2)
# vm.byte_BUILD_LIST(0)

zelark

from random import randint

def kill_negative(n):
    if n < 0:
        n = 0
    return n

def calc_attack(level):
    return level*6

zelark

with data as (
    select 50 as col1,  0 as col2 from dual union all
    select  0 as col1, 20 as col2 from dual union all
    select 20 as col1, 10 as col2 from dual union all
    select 20 as col1, 10 as col2 from dual
)
select avg(nullif(col1, 0)) as col1_avg_no_zero,
       avg(nullif(case when col2 = 0 then 0 else col1 end, 0)) as col1_avg_no_zero_with_col2        
from   data;