kamleong

#!/usr/bin/env python3
import sys
print(sys.argv[0])  ## __file__

filepath = sys.argv[1] if len(sys.argv) > 1 else r"C:\Windows\win.ini"
print(filepath)

#f2 = open(r"B:\a.txt","a+")
#f2.write("Hello \n")
#f2.close()

kamleong

Oracle 9i XMLAgg String Aggregation: Concat Data from Rows to Col
=================================================================

Below is supported in 9i (may appear complicated at first look, but actually is rather simple). There are other advance features in this area for 10g & 11g

WITH table1 AS (
  SELECT 1 attr1 FROM DUAL UNION
  SELECT 2 attr1 FROM DUAL UNION
  SELECT 3 attr1 FROM DUAL UNION
  SELECT 4 attr1 FROM DUAL