How to insert random unique values in 2 columns ?

Posted on 16th Feb 2014 07:03 pm by admin

I have table with 2 columns

Create Table code_for_code (
first_code varchar2(10) unique not null,
second_code varchar2(10) unique not null );

and i want to make PL/SQL code to insert random unique values in both columns , for instance 20 records ........ how can i do something like that ?

Your Answer:

Login to answer

Other forums

Preg_match question
I want to use preg_match to make sure a string is always 6 characters long and only contains 0-9 and

Create comparison matrix?
I want to create a comparison script for forum software and was wondering is there any tutorial or b

Pop-up Banner
Hello Friends,I need to use banner in our client site.Example: www.example.com if i enter this site

JSON SORT WITH PHP
I have two products that I want to sort by say "Id:17, value: xxx" using php
The page w

PHP using IF to display error
i have a MySQL query and i want to display 1 thing only if the number of affected rows is >=1

Help with php code
Hello, can anyone tell me why this php word trap fails to work,
and the trigger words get blow r

replacements
I have a variable in my PHP script like

ASSFDDDDDDDDDDDDDASDDDDDDDDARYTRHKKHHHHHHHHHHH and p

RadioButtonList item spacing
I have a RadioButtonList and I can't put any spacing between the items. They are arranged verticall

How to display value in drop down list after form has been reloaded
Please bear with me as I am very new to php and html.

I have a form with several drop down me

Help with form post data and arrays
Hi all,

I am new to this forum... It has been awhile since i have worked with arrays, and i a