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

Connection Timeout
I'm using xmii 12.0

I'm calling a transaction as a web service from a windows application

user validation always displaying invalid ? please help
Hello,

I have 2 accounts and there is a field in mysql called validated it can be either &quo

mysql query with single quotes in a variable
$sitedetails = "INSERT INTO vars (address, sitename, description, ownername, theme) VALUES ('$u

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

Operating System
How in PHP or other language can I detect Operating system, ie Windows XP Home, Windows 7 Ultimate,

sql error
I have been looking at this code for 20mins and can't work out what I am doing wrong. There is somet

PHP code for a proxy
I was wondering which function I could use to create an online proxy tool. I was thinking cURL would

foreach iterator
Hi Guys
Does the foreach loop have an inbuilt iterator ?

How could I combine these arrays??
Hello.. I'm trying to figure out a way to combine these first two arrays to get the last array..

php form help
Hey,

I use a control file to set my meta tags and titles

Here's an example
Code: &a