Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Israel
    Posts
    2

    Unhappy Unanswered: How can I insert names randomly?

    I need to insert 200.000 different names in my table.
    How can I do it?
    Thanks.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: How can I insert names randomly?

    Originally posted by dba_netanya
    I need to insert 200.000 different names in my table.
    How can I do it?
    Thanks.
    Do you mean REAL names like 'John Smith' or just random text strings like 'Afgcksdaslkoiudqdja'?
    You can get random text strings using DBMS_RANDOM.STRING.
    If you want realistic names, I don't know - maybe you can buy a mailing list database from someone?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •