Giant oscillator strength of excitons in bulk and nanostructured systems