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

Save username into DB
OkaY so I got my blog to actually save the posts and whatever, all I need now is for it to keep the

a very simple php header question (sorry!)
Firstly...I do apologise if this annoys anyone....a header error

I'm do not know php &

do while conditions
i want to display 6 images in a 2x3 table
now what would be the correct logic to
count that th

An odd assignment statement. Can someone explain this assignment to me?
What purpose is served by the bit of code between the two equal signs in the $installurl set? Is th

Database connection failure
Hello All,

I am trying to create new connection to Oracle DB 10.1,
I could not see a

Passing an array of values From VB6.0 to Oracle PL/SQL Function
Basically we are using VB6.0.

When we try to pass an array from VB6.0 to an Oracle PL/SQL

Not Loading Function Into Div
I'm not sure whether to put this under the php forum or ajax forum but because I tink it's more of a

Weird MySQL error, why am I recieving this?
PHP Code:


<?php require "global_settings.php"; ?>
<titl

Keeping track of php uploads
Hello all.

I was looking at the way PHP handles file uploads.
It seems that PHP uses a tem

I need help with formatting date from mysql! with php!
Hello guys

*Note: this is a php question not MySQL question, please do not move it to mysql s