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

This is driving me nuts!
This insert query looks to be alright, however I get this error:

QuoteYou have an error in yo

SAP BCS. BPS
Hi all,

I am seeking reading note on the following in BW

BCS, BPS
ADVANCE

PHP5 - Verifying a secure mail is secure
I need to send an e-mail from a form to a external department and because it contains personal custo

Object Interfaces
EDIT: Never mind, I just updated to php 5.

Hey all,

I'm currently experimenting with p

LSB (PHP 5.3) problem with static value!
hello,

i'm having a problem. static::$text variable gets lost at some point. can someone plea

help with Get_
ok some how this is not working i am not sure what i am doing wrong here but what this does is when

Expandable Post Code
Hi,

Hope you can help. Which currently I haven't upgraded to connect to a mysql server, so i

Change Sort Order to Display Newest File First
Hi Guys,

I have a page that sorts the contents (PDFs) of a directory and displays them on the

First root of a number
Hi,

I can't find any function in php to give me the first root of a number.
Is there any

How to separate records and ORDER BY
Let say i have 100 records and displayed in one page, then i want to get the records from 50-100 and