sql - Generate 10,000 random values in a table -

-

i have oracle table. development purposes want generate 10,000 different values table. how can this?

create table errorlog(   errorid integer not null,   errorcontent clob not null,   errordate timestamp(6) not null )

if looking chaotic in clob (including length , content) may use dbms_random:

sql> select dbms_random.string('p',dbms_random.value(1,30)) rand_str dual connect level <= 10   2  /  rand_str                                                                         -------------------------------------------------------------------------------- #<a                                                                              tv&og8=:f}is/sr2l>f\7wcl)_v2                                                     /wbp y)v5zd.v                                                                    _yw(o_                                                                           b:5&e}7\a1gt]x}$}e*-w[6u=1                                                       l<hq:l^5}a(]<:}+8|-{.f%&`l                                                       g!l'rbgiw/o]r~`[@9d6fui3dc7                                                      .h_y;yeh`*ruk+\~8^i<g+;l76*                                                      ec}al                                                                            d3)uft)s2kda5

and same package can used generate values in other columns (but suppose errorid primary key, can use other method guarantess uniqueness - sequence).

sql> create sequence seq_x;  sql> select x_seq.nextval, dbms_random.string('p',dbms_random.value(1,30)) rand_str, systimestamp + numtodsinterval(dbms_random.value(1,40),'minute') rand_ts  dual connect level <= 10;     nextval rand_str                        rand_ts                                ---------- ------------------------------  -----------------------------------             1 a?=pk7ya|l8]d/)3!               24.03.14 19:47:18,750326032 +04:00              2 $n+k4vksvx(npxm^'#/%.aay5$,     24.03.14 19:50:48,361699672 +04:00              3  },7(1ix,2'e@i3u;wdg?.bb        24.03.14 19:35:15,711777571 +04:00              4 :s8x vj!m!:yi% flcy8$\y_}c      24.03.14 19:43:41,088255060 +04:00              5 /'ofj@+jov3ufzc\z;^2+9gg~       24.03.14 19:59:02,214021766 +04:00              6 8vth0}[hybedy{4\                24.03.14 20:06:34,600594460 +04:00              37 >u w9q)]c7/hb_butznr\oi!hwwo<& 24.03.14 19:36:39,010531153 +04:00              8 >gwzdbt8!?g}(<8;@i              24.03.14 19:51:52,118620451 +04:00              9 -] 'nxhux46"_(df"8.u:6pel"      24.03.14 19:44:04,152845952 +04:00             10 "haj                            24.03.14 20:00:24,933479299 +04:00

Comments

Post a Comment

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp
Read more

php - Magento - Deleted Base url key -

-
i working on cleaning url: http://mydomain.com/shop/shop/deals i going through settings in configuration tab in admin panel on magento , change secure , unsecure base urls remove first base url "shop" web page read: http://mydomain.com/shop/deals so changed unsecure base urls mydomain.com/shop mydomain.com , secure 12.345.67.89/shop 12.345.67.89. wrong thing do. i cannot reload page or admin console. how access these files through ftp , change correctly there?? when make changes in admin panel changes made in database not in file. have make changes in database. 1.go database , select core_config_data table under table find web/unsecure/base_url , web/secure/base_url . make changes here. don't forget clear cache in var/cache folder
Read more

android - How to disable Button if EditText is empty ? -

-
i have edittext , button in application. when button clicked,the text entered in edittext added listview. i want disable button if edittext empty.how ? this code button click imagebutton imb=(imagebutton)findviewbyid(r.id.btn_send); imb.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { edittext et = (edittext)findviewbyid(r.id.edittext1); string str = et.gettext().tostring(); web1.add(str); toast.maketext(shoutsingleprogram.this, "you entered...."+str, toast.length_short).show(); adapter1.notifydatasetchanged(); et.settext(""); } }); } how can ? edittext1.addtextchangedlistener(new textwatcher() { @override public void ontextchanged(charsequence s, int start, int before, in
Read more