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

ALV List display - header width adjust
Hi,

I am using REUSE_ALV_LIST_DISPLAY for my ALV display.The width of the ALV varies for

Simple image grab script.
I was wondering if it was possible and if anyone knew how to make a simple php script that looks at

Custom Container in module pool program
Hello everyone,

I have created a custom control in my module pool screen. Now I want to s

check if value exists
I have googled this for a while and I am getting lots of different results. Is there a standard meth

RSS poster script?
I have found a script that posts RSS's for me on a site that I'm building. However I would like to a

Need help PLEASE
ok i have this warning showing up

Warning: in_array() [function.in-array]: Wrong datatype for

Select Lists into MYSQL
Hello All, I am new to PHP @ 1 week. So borrowing code anywhere I can. I am making progress, but h

str_replace help
Hey there,

I'm a PHP newb, I'm having troubles with the str_replace function. I want to clean

split values
I have values that are returned to me in this format:

name=>test,age=>49

storing results of a function - previous result overwritten with new result
I have created a function to validate input.

function validate_dimension($value,$name) {
<