oracle sql snippet of the day

wie erhält man schnell, und zwar besonders schnell in oracle eine tabelle mit x (test-)datensätzen?

create table test_table

as

select

level as id,

‘name ‘ || level as name

from dual

connect by level <= x

erzeugt mit x = 1 mio in weniger als 4 sec eine tabelle mit folgenden datensätzen:

1, ‘name 1’

2, ‘name 2’

3, ‘name 3’

Advertisements
This entry was posted in howtos and tagged , . Bookmark the permalink.

One Response to oracle sql snippet of the day

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s