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 ?

No comments posted yet

Your Answer:

Login to answer
262 Like 17 Dislike
Previous forums Next forums
Other forums

How can use this array as a key?
Say I have this array for example:


print_r($array);

Prints:
Code: [Select]Array

need help with this contact form
I made this form and I need it to read the data and write the data to a table and its not working ca

Displaying returned XML in another PHP page
I have an online payment form that will return XML given if a payment is successful or declines. I

j1inmis Ouput layout changes
Hi,

Can anybody tell how can j1inmis output layout can be changed so that vendor names ge

Help with lottery style system?
I'm working on a currency system for forums and it is going to have a type of lottery system built i

regex for quoted text within a string
I am still getting the hang of regex expressions, but I cant seem to figure out how I would escape q

Help! refer to a friend script with captcha code
Hi guys, I am posting on here in desperate need for some help with an ongoing search I have been doi

Help If user voted, block them
On my Prayer request site, i let users Click a button to Pray for somone that has posted a pray, i g

Interpret Order
Hello all,

I'm wondering if I have this:

Code: $switch = array(
'one' =>

Need help with unexpected T-STRING error
I'm a newbie and I'm still learning PHP. However this error has me stumped. I've googled, searched t

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash