Oracle : quelques commandes intéressantes
Posté par patrick le mars 20, 2007
Quelques commandes que j’utilise (avec sqldeveloper) pour produire le code de mes classes métier:
- SELECT ‘public static readonly string ‘ || REPLACE(INITCAP(cname),’_',”) || ‘ = “‘ || cname || ‘”;’ FROM col WHERE tname = ‘tablename’
- SELECT ‘, new CAttributTable ( ‘ || REPLACE(INITCAP(cname),’_',”) || ‘ )’ FROM col WHERE tname = ‘tablename’
- SELECT ‘public string Value’ || REPLACE(INITCAP(cname),’_',”) || ‘ { get { return CUtilConversion.ToString(DataValue,’ || REPLACE(INITCAP(cname),’_',”) || ‘); }}’ FROM col WHERE tname = ‘tablename’
- SELECT ‘MyValue += ” ‘ || REPLACE(INITCAP(cname),’_',”) || ‘=” + CUtilConversion.ValueSQL(Value’ || REPLACE(INITCAP(cname),’_',”) || ‘) + “\n”;’ FROM col WHERE tname = ‘tablename’
