Posts

Showing posts from May, 2015

javascript - Radio button selection for paypal form issue -

need help so have paypal form has 2 radio buttons. 1 shipping value, , 1 without. here link actual form http://www.topchoicedata.com/test.php what want happen if person selected first radio box("$19.99 shipping – database sent on cd rom"), 19.99 automatically added "hdwppamount" amount set @ $175, when person press's "pay now", make grand total of $194.99 on paypal page. and if person selected second option instead("free shipping – database sent via email") instead, of course no value added "hdwppamount" amount , $175 total paypal page. now code work if person chooses on or other options, , not alternate between radio buttons deciding 1 choose. kind of buggy because if choose first option, decided second option, , on , forth alternating, either error page or if did choose free option, 19.99 still gets added. i need if first option chosen, 19.99 gets added, , if second option chosen, nothing added. any appreciated. ...

Python: checking file and outputting to a new file -

i have sample filename file: chr7 149601 merged_del_2_39754 t . 141.35 . ac=0;af=0.00;an=2;dp=37;mq=37.00;mq0=0;1000galt=<del>;af1000g=0.09;afr_af=0.01;amr_af=0.03;asn_af=0.27;eur_af=0.04;ts=hpgom;tsseq=t,t,g,t,t;canc=t;ganc=t;oanc=t;msc=0.000;grp=-2.16;map20=1 gt:dp:gq:pl:a:c:g:t:ir 0/0:37:99:0,111,1458:0,0:0,0:0,0:18,18:0 chr7 149616 rs190051229 c . 108.65 . ac=0;af=0.00;an=2;dp=35;mq=37.00;mq0=0;1000galt=t;af1000g=0.00;asn_af=0.01;cpg;ts=hpgom;tsseq=c,c,c,c,c;canc=c;ganc=c;oanc=c;msc=0.000;grp=-2.15;map20=1 gt:dp:gq:pl:a:c:g:t:ir 0/0:35:78.65:0,79,1305:0,0:17,17:0,0:0,0:0 chr7 149628 rs3814456 . 129.31 . ac=0;af=0.00;an=2;dp=37;mq=37.00;mq0=0;1000galt=g;af1000g=0.14;afr_af=0.16;amr_af=0.07;asn_af=0.27;eur_af=0.06;ts=hpgom;tsseq=a,a,a,a,a;canc=a;ganc=a;oanc=a;msc=0.000;grp=-2.23;map20=1 gt:dp:gq:pl:a:c:g:t:ir 0/0:37:99:0,99,1290:14,22:0,0:0,0:0,0:0 chr7 149634 rs146001818 g t 1375.63 . ac=2;af=1.00;an=2;baseqranksu...

javascript - Elasticsearch https cors enabled but still getting No 'Access-Control-Allow-Origin' header is present on the requested resource -

i have enabled settings cors in index called myindex, here settings it. when try pull data elasticsearch simple javascript cors headers set error xmlhttprequest cannot load http://elasticsearchdomain.com:9200/myindex/_search/ . response preflight request doesn't pass access control check: no 'access-control-allow-origin' header present on requested resource. origin ' http://localhost:8000 ' therefore not allowed access. i running javascript include script run when open html page through python server. { "state": "open", "settings": { "index": { "http": { "cors": { "allow-credentials": "true", "enabled": "true", "allow-origin": "*" } }, "creation_date": "1461087830891", "number_of_shards...

ios - Setting a view to hidden causes frame adjustments -

i'm working in collection view 1 of our cells able collapsed or expanded button press. original developer of feature gone, i'm trying understand going on. can tell, when user presses button, following code gets called: - (void)expandcell{ [expandcollapsebutton settitle:@"-" forstate:uicontrolstatenormal]; [textview sethidden:no]; isexpanded = yes; [self.delegate celldidexpandcollapse]; } our collapse cell virtually identical except don't hide it, set isexpanded variable no , set title "+" instead of "-". celldidexpandcollapse delegate method calls updatecollection method, i've copied below. - (void)updatecollection { [self.collection performbatchupdates:nil completion:nil]; [self.amountcell updatetable]; [self.collection setneedslayout]; [self.collection layoutifneeded]; } and that's it. yet, when layoutifneeded called, system sets frame of textview have different origin , height of 0. i...

C++ contact card, re-running program trouble -

for assignment, have make customer card info required. able run program fine, when re-run "do wish run again? (y/n)", first 2 questions appear on same line , messes program. me fix issue? #include <iostream> #include <cstdlib> #include <iomanip> int main() { char answer; system("cls"); cout << "*********************************************" << endl; cout << "*********************************************" << endl; cout << "*** w e l c o m e ! ***" << endl; cout << "*** in program creating ***" << endl; cout << "*** customer contact card! ***" << endl; cout << "*********************************************" << endl; cout << "*********************************************" << endl; system("pause"); { string name; string city; string address; st...

javascript - Trying to understand JS functions - what am I doing wrong? -

i'm working way through beginner's javascript course on treehouse , keep getting stuck on functions. in effort understand better, tried creating calculator converts human years dog years. here code far: html: <div id="calculator"> <form> <label>what current age in human years? <br> <input type="text" id="humanyears"></label> <br> <button type="text" id="calculate">calculate</button> </form> </div> js: function calculate() { var humanyears = document.getelementbyid("humanyears").value; var dogyears = (humanyears * 7); document.write(dogyears); } document.getelementbyid("calculate").onclick = function(){calculate(); }; the page flickers , keep seeing form, no result. i know code incorrect don't understand why. know can copy other people's code github , have functioning calculator kind of defeats purpose...

postgresql - PHP result from a query with alias -

when want data sql query on php system, write like <?php echo $sqlresult['fieldfromresult'];?> i wondering if can put alias directely on 'fieldfromresult'. example: select tb1.*, tb2.*, tb3.* tableone tb1, tabletwo tb2, tablethree tb3 id = 1 , tb1.idcolumn=tb2.idcolumn , tb1.idcolumn=tb3.idcolumn you see, should easy if specify want every table (one, 2 or three), want all. name of of these columns same. example: tableone , tablethree has column named "description". what want in php a <?php echo $sqlresult['tb1.description'];?> if use <?php echo $sqlresult['description'];?> doesn't work. is there way make without specify columns want on query? in order output contain table name column name you'd need write own output class/function this, referencing table schema/meta data , creating own array keys this. or you simpy name them assosciation as such that: select tb1.description t1_de...

html - How to open url to the same tab if its already open in browser -

i facing challenge- lets consider have menu , under have 3 links- about contact faqs by default home page menu item. when clicking on " contact us " , want open new tab on same browser window. , without closing if again clinking on " contact us " first tab, this time not want open new tab because have open tab contact us , wanted navigate same 1 earlier opened. how handle scenario in jsp. is there way this. please me. you can put name in target go same window/tab <a href="somerandomurl.com" target="mywindow">contact us<\a> its not possible control on internet explorer. can change how ie behaves: -internet options -tabs -always open pop-ups in new tab -open links other programs in: new tab in current window target="_blank" make sure opens in new window http://www.w3schools.com/tags/att_a_target.asp it refresh page same url you can have link return javascript window object , able return window any...

ruby on rails - Payment plan is accepted and created, but $0 is sent instead of the amount due -

Image
i using ruby on rails 4 , , paypal rest sdk . i've created plan (recurring) , agreement, , user agreed plan, , user has subscription plan. the plan , agreement: plan = paypal::sdk::rest::plan.new( name: 'test month', description: 'test desc', type: 'infinite', payment_definitions: [ { name: 'payment', type: "regular", frequency: 'month', frequency_interval: 1, cycles: 0, amount: {currency: 'usd', value: '10'} } ], merchant_preferences: { cancel_url: 'https://google.com/', return_url: 'https://google.com/', auto_bill_amount: 'yes' } ) plan.create plan.update(path: '/', op: 'replace', value: { state: 'active' }) agreement = paypal::sdk::rest::agreement.new( name: 'test agreement', description: 'agreement desc', plan: {id: plan.id}, st...

Android VideoView playback issues on recorded files -

the problem have trying program playback .amr file has been recorded using default android voice recorder. have downloaded mp3 voice recorder , tried playback on doesn't work either. have downloaded .amr , .mp3 files work it's ones recorded don't seem work. code dump: private static final string recording = new string(environment.getexternalstoragedirectory().getpath()) + file.separatorchar + "my documents" + file.separatorchar + "my recordings"; arraylist<string> songlist = new arraylist<string>(); private listview playlist; private videoview videoview; private mediacontroller mediacontroller; private void loadplaylist() { songlist.clear(); file home = new file(recording); if (home.listfiles( new amrfilter()).length > 0) { (file file : home.listfiles(new amrfilter())) { songlist.add(file.getname()); } } if (home.listfiles( new mp...

python - Pyenchant store_replacement doesn't work? -

i trying of functions in pyenchant , when tried store_replacement , didn't work me , have no idea why. here's code: d = enchant.dict('en_us') d.check('alllow') out[1]: false d.suggest('alllow')` out[2]: ['allow', 'all low', 'all-low', 'wallop', 'allot', 'alloy', 'willow', 'allele', 'allover'] d.store_replacement('alllow', 'alloy')` d.suggest('alllow')` out[3]: ['allow', 'all low', 'all-low', 'wallop', 'allot', 'alloy', 'willow', 'allele', 'allover'] according docs pyenchant: store_replacement(mis, cor) : store replacement spelling miss-spelled word. method makes suggestion spellchecking engine miss-spelled word in fact correctly spelled cor. such suggestion typically mean cor ...

qt - Confused between QSQLITE and SQLITE -

i'm creating music library manager on qt. i'm confused whether should use qt's driver sqlite(qsqlite) or raw sqlite grabbed website. i'll need create .dll raw code though. if use qt's native library, believe i'll have install drivers inorder use app on different system. i'm newbie both qt , sqlite. kind of help/advise awesome :) thanks! i highly recommend use qsqlite driver. it part of qt sql module provides support sql databases in "qtish" way. you'll save lot of time , effort. there's no need additional installation. have include driver (sqldrivers/qsqlite.dll) in deploy folder. after all, if don't pay comercial license, when deploy qt application you'll have carry several dynamic libraries. don't think 1 more make difference.

ios - CLLocation Change in local update database -

i have local database has field "distance" based on user's current location. have added logic update database if there change in location every 30sec. if there change in location 1 time in 30 sec working fine, when device location changes more 1 location within 30 sec, database updated distance changing. can please let me know whats mistake have done here.

Oracle APEX - Setting a value from Interactive Report column to a Item -

i have created dashboard interactive report (apex 4.2), in report displaying info column displays whether record has attachments or not. if click link pop-up modal window (i using jquery window display list of attachments in classical report). problem is, not able set record_id in modal window hidden item retrieve corresponding attachments. somebody, please throw light how set value dynamically interactive report value hidden item attached modal window. thanks sudhakar here tutorial helped me problem.

yesod - Haskell/Persistent: Reusing "selectList" -

i trying write api in servant , writing lot of handlers this: gettablea :: handler [arecord] gettablea = xs <- rundb (selectlist [] []) let records = map (\(entity _ v) -> v) xs return records gettableb :: handler [brecord] gettableb = xs <- rundb (selectlist [] []) let records = map (\(entity _ v) -> v) xs return records gettablec :: handler [crecord] gettablec = xs <- rundb (selectlist [] []) let records = map (\(entity _ v) -> v) xs return records and on. i want able have more like gettable :: handler [a] gettable = xs <- rundb (selectlist [] []) let records = map (\(entity _ v) -> v) xs return records however error couldn't match expected type ‘sqlbackend’ actual type ‘persistentitybackend val’ relevant bindings include getall :: handler [val] (bound @ src/novation/handler.hs:101:1) in first argument of ‘rundb’, namely ‘(selectlist [] [])’ in stmt of 'do' block: xs ...

javascript - Why in jsfiddle display ReferenceError: function is not defined? -

my code in jsfiddle : https://jsfiddle.net/oscar11/1xstdra1/ when run script in jsfiddle, in console exist error : referenceerror: dopagination not defined . whereas when tried on localhost, works. no error any solution solve problem? thank you the jquery library not included. can clicking settings button in javascript field, , select version of jquery @ "frameworks , extensions".

R get max, keyed by another function (like in Python) -

in python, can max(stuff, key=lambda x: abs(x.foo)) which return element of stuff has member foo highest absolute value. how in r? so suppose stuff must list of vectors (or lists) named elements, this: stuff <- list( first = c(bang=1, qux = 2, foo = 3), second = c(bang=6, qux = 0, foo= 100), third = c(bang = 1, qux = 7, foo = 0)) you can element "foo" using sapply: sapply(stuff, function(.) .['foo']) ... find maximum of it: which.max(sapply(stuff, function(.) .['foo'])) ... , use index list: stuff[which.max(sapply(stuff, function(.) .['foo']))] or magrittr: stuff %>% {.[sapply(., "[", "foo") %>% which.max]}

How to set or change the default software path in R -

i have program called "bowtie2" , changed default path in terminal: $export path=/opt/ngs/bowtie2-2.2.8:/usr/local/sbin:/usr/local/bin:/usr/sbin $bowtie2 --version /opt/ngs/bowtie2-2.2.8/bowtie2-align-s version 2.2.8 but when call r it's still old version other path: > bowtie2="bowtie2" > system2(bowtie2,"--version",stdout=true)[1] [1] "/usr/bin/bowtie2-align version 2.1.0" my question how change default path program in r (so version "/opt/ngs/bowtie2-2.2.8/bowtie2-align-s version 2.2.8" rather "/usr/bin/bowtie2-align version 2.1.0") you need add export path=/opt/ngs/bowtie2-2.2.8:/usr/local/sbin:/usr/local/bin:/usr/sbin end of .bashrc(linux) or .bash_profile(mac) file in home folder. vi ~/.bash_profile and add export command @ end of file, otherwise work current shell session. when use system command in r, launches new shell session, export command won't apply to. see this link find...

javascript - How to dynamically chain function calls using RXJS? -

i need cache result of request on first call read cached value subsequent calls. to achieve goal, using promises , chaining them. have working solution convert rxjs's observables instead of promises. here working solution: private currentpromise: promise<{ [key: string]: }>; private cache: any; public getsomething(name: string): promise<number>{ return this.currentpromise = !this.currentpromise ? this._getsomething(name) : new promise((r) => this.currentpromise.then(() => this._getsomething(name).then((res) => r(res)))); } private _getsomething(name: string): promise<any> { return new promise((resolve) => { if (this.cache[name]) { this.messages.push("resolved cache"); resolve(this.cache[name]); } else { // fake http call. use angular's http class. settimeout(()=> {this.messages.push("resolved server"); this.cache[name] = name; resolve(this.cache[name]); }, 2000 ...

machine learning - SVM classification - normalization in R -

i want work svm classification. how possible normalize (or scale) features per column in dataset before use svm model? train <- read.csv("train.csv") test <- read.csv("test.csv") svm.fit=svm(as.factor(type)~ ., data=train, core="libsvm",kernel="linear",cross=10, probability=true) you can use scale function in sapply : scaleddf <- as.data.frame(sapply(train, function(i) if(is.numeric(i)) scale(i) else i)) if data contains variables nan values or 0 variance, first process , subset original dataset before using function above. # vector of variables drop dropvars <- sapply(train, function(i) { if((is.numeric(i) & !any(is.nan(i)) & sd(i) > 0) | is.factor(i) | is.character(i)) true else false } # subset test dropping columns don't fit criteria smallerdf <- test[, dropvars] then apply original sapply function above smallerdf

java - ViewPager doesn't display the second and third views when height wrap_content -

i have viewpager works views (not fragments). default viewpager has 1 view display sectionslayout , , depending on webservice response might add 1 or 2 views viewpager. ( promo1, promo2 ) the viewpager being small part of activity layout, height should height of first child : sectionslayout , if needed add 1 or 2 other pages, ( promo1, promo2 ) should have same height sectionslayout . now, viewpager shows me correctly first embedded layout doesn't display second , third ones when height of viewpager set wrap_content (it show them when height fixed on dps , know it's common , known issue on viewpager, created custom viewpager based on answers here on takes height of first element. flexibleviewpager.java : public class flexibleviewpager extends viewpager { public flexibleviewpager (context context) { super (context); } public flexibleviewpager (context context, attributeset attrs) { super (context, attrs); } @override pub...

php - How to add a second language at a later time for internationalization? -

i have following schema: <!-- language: lang-xml --> <table name="blog" phpname="blog"> <column name="id" type="integer" required="true" primarykey="true" autoincrement="true" /> <column name="title" phpname="title" type="varchar" size="100" required="true" /> <column name="short_link" phpname="shortlink" type="varchar" size="64" required="false" /> <column name="description" phpname="description" type="longvarchar" required="false" /> <column name="content" phpname="content" type="longvarchar" required="false" /> <column name="visibility" phpname="visibility" type="integer" default="-1" required="true" /> ...

wso2 - issue running mvn eclipse:eclipse on platform tag 4.0.3 -

i have checked out platform 4.0.3 tag, , have hit issue secverifier when running mvn eclipse:eclipse . i've cleaned maven cache secverifier : rm -rf %userprofile%\.m2\repository\org\wso2\carbon\secverifier rm -rf %userprofile%\.m2\repository\org\wso2\carbon\integration then tried mvn eclipse:clean eclipse:eclipse : c:\wso2\src\wso2carbon_platform_tags_403>mvn eclipse:clean eclipse:eclipse [info] scanning projects... [error] build not read 1 project -> [help 1] [error] [error] project org.wso2.carbon:secverifier:4.0.0 (c:\wso2\src\wso2carbon_platform_tags_403\products\integration\security-verifier\pom.xml) has 1 error [error] non-resolvable parent pom: failure find org.wso2.carbon:integration:pom:4.0.0 in http://repo.maven.apache.org/maven2 cached in local repository, resolution not reattempted until update interval of central has elapsed or updates forced , 'parent.relativepath' points @ wrong local pom @ line 22, column 13 -> [help 2] i found ...

sql - Understanding correlation in mysql -

i have table duplicate ids representing person has placed order. each of these orders has date. each order has status code 1 - 4. 4 means cancelled order. using following query: select personid, max(date), status orders status = 4 group personid the problem is, while return unique record each person recent order date, not give me correct status. in other words, assumed status correctly correlated max(date) , not. pulls, seemingly @ random, 1 of statuses 1 of orders. can add specificity say, in basic terms, give me exact status same record whatever max(date) is. unfortunately, there no simple way want. other rdbms vendors don't consider queries using aggregate functions valid unless non-aggregated result fields in group by. general solution these kinds of questions involves subquery "last" records, joined original table rows. depending on structure of data may or may not possible. instance, if have multiple rows same personid , date th...

java - xor operator find the number which appears once explain -

i don't understand algorithm. for array given in program, if i = 0, num = num ^ arr[0] => num = 0 ^ 3 = 3 = 1, num = num ^ arr[1] => num = 3 ^ 1 = 2 = 2, num = num ^ arr[2] => num = 2 ^ 5 = 7 ...etc...and last result in num printed. what's going on here? how did delete numbers same value? this algorithm finds element appears in array once, how? class ideone { public static int a() { int arr[] = {3,1,5,1,5,3,4,7,7}; int num = 0; for(int = 0; < arr.length; i++){ num ^= arr[i]; } return num; } public static void main (string[] args) throws java.lang.exception { system.out.println(a()); } } the other answers completely right , think have nice way think i'll share thoughts you. this long read, super simple , think understand algorithm , ^ , or xor, does. the easy way! remember these rules! n ^ n = 0 n ^ 0 = n and n can any number. for examp...

java - Lucene Search with MultiThreads -

i need execute in machine learning project >3000 queries in index 3gb size. in order speed performance create 4 threads(i got 4 cores in macbook pro) , gave each 1 part of total queries(if got n queries in total each thread got n/4 queries). i open index via fsdirectory.open(file) , share indexsearcher threads. the problem don't see performance improvement neither cpu increase. played different number of threads still no change. to save whole index in ram not possible! i saw on other threads solution open index read use lucene 4.3 write options removed reader no worries read mode anymore! i aware this page , tips give looks quiet out of date. so question how can parallel index search in order improve performance real lucene? below example code using: list<string> querylist = new arraylist<string>(); list<thread> threads = new arraylist<thread>(); for(int i=0;i<number_threads;i++){ list<string> querysublist = qu...

oracle - SQL sub query. Dont know how to start -

the table called people , has columns: id, fname, lname, state, jobtitle, salary, cat i want display 50 states, number of people in state cat value of y, number of people in state cat value of n , total number of people in state. 4 column headings should state, yes, no , total. i know supposed use sub queries not sure how begin. here: select upper(p.state) state, (select count(*) people p2 p2.state = p.state , p2.cat = 'y') yes, (select count(*) people p3 p3.state = p.state , p3.cat = 'n') no, count(*) total people p group upper(state) if have doubt it, fell free ask.

java - Eclipse Crashed when Started -

the last thing remember changing web browser preferences in eclipse. had changed webkit chrome. trying test dynamic web project, , changed browser , ran application, eclipse crashed.... it generated error log when restarted it, here- https://www.dropbox.com/s/p6g8mitc2ywcz60/hs_err_pid4856.log if -clean works great else change workspace , import project again fix problem

Shop module is not properly working with Magnolia CMS 5.4 -

i have tried shop module 2.3-snapshot magnolia cms 5.4, have noticed ui components not same used in shop module , magnolia cms 5.4. once installed shop module /travel page not work. knows workaround or better version of shop module work smoothly magnnolia cms 5.4 ? 2.3 version has quite few changes (hence new major version number) , afaik demo have not been updated yet. either use w/o demo (since it's snapshot no guarantee nothing else broken) or stick version 2.2 released , there's number of installations version , magnolia 5.4.x. alternatively, figure out broken in demo , provide patches issue. community driven module after all. hth, jan

java - Array being accessed out of bounds? -

so have problem still working on class. need encrypt message using basic character change. have coded having issues loop suppose handle character replacements.for reason keeps trying access array outside of bounds thought using array length limit. missing not sure where. should work. have 2 files. taking message, changing char array, comparing letters find out , replacing them needed. point out have missed? also note: know not suppose use == if use .equals, .compareto, or "char cannot dereferenced" error. time doesn't if use ==. if let me why thing or @ least point me can understand why happening grateful. driver /** program name: driver date:4/14/2016 program description: program going handle window user enters data. going going call methods of actions class methods: driver(),destination(), message(), */ import javax.swing.*; // swing classes import java.awt.event.*; // actionlistener interface import java.util.scann...

c++ - Program that reads vowels and erases them won't run properly -

i have c++ program finds , erases vowels in giving string. problem is, doesnt work , can't find reason why. have use 2 functions removes vowels , determines if character vowel , of should operate in loop. this code: #include <iostream> #include <string> using namespace std; bool isa_vowel(string s); string remov(string s); int main() { string s; string ans = "y"; while((ans == "y") || (ans == "y")) { cout << "please enter word or series of letters: "; cin >> s; cout << "old: " << s << endl; cout << "new: " << remov(s) << endl; cout << "would go again? <y/n> "; cin >> ans; } } bool isa_vowel (string s) { if (s == "a" || s == "e"|| s == "i" || s == "o" || s == "u" || s == "a" |...

Fastest way to do MySQL query select with WHERE clauses on an unindexed table -

i have big unindexed table called table rows this: ip entrypoint timestamp 171.128.123.179 /page-title/?kw=abc 2016-04-14 11:59:52 170.45.121.111 /another-page/?kw=123 2016-04-12 04:13:20 169.70.121.101 /a-third-page/ 2016-05-12 09:43:30 i want make fastest query that, given 30 ips , 1 date, search rows far week before date , return recent row contains "?kw=" each ip. want distinct entrypoints recent one. i'm stuck know it's relatively simple inner join don't know fastest way it. by way: can't add index right because it's big , on db serves website. i'm going replace indexed table don't worry. rows table select ... very_big_unindexed_table t only within past week... t.timestamp >= now() + interval - 1 week that contains '?kw=' in entry point , t.entrypoint '%?kw=%' only latest row each ip. there's couple of approaches that. correlated subquery ...

how to know how many shared preference in shared preferences in android -

Image
i want know how many shared preference in shared preferences found in file explorer coding , there method return total number of shared preferences ? to number of entries can use sharedpreferencesinstance.getall().size() to retrieve keys stored can use keyset() , shown in following snippet: sharedpreferences prefs = this.getsharedpreferences("myshared", context.mode_private); map<string,?> entries = prefs.getall(); set<string> keys = entries.keyset(); (string key : keys) { }

android - RecyclerView and IndexOutOfBoundsException: Invalid index #, size is # -

i have simple recyclerview , want remove items onclick. continuously running crash depending on when clicked on items in list above error. if you're having similar issues, here's how solved it: public void onbindviewholder(final cardviewholder holder, final int position) using position here useful things, if used when removing items list, causing crash, instead using: holder.getadapterposition(); resolved issues immediately.

Oracle SQL Developer Create View Assignment -

i've got assignment following instructions: create view named a11t1 (that's a-one-one-t-one, not a-l-l-t-l) display concatenated name, jobtitle , salary of people have cat value of n , salary @ least 30 percent higher average salary of people have cat value of n. 3 column headings should name, jobtitle , salary. rows should sorted in traditional phonebook order. note 1: always, concatenated names must appear 1 space between first , last names. note 2: concatenated names , job titles must displayed in proper case (e.g., mary ellen smith, assistant manager) task. note 3: remember, person11 data messy. sure n , n when identifying people cat value of n. what have far is: create view a11t1 select initcap(fname||' '||lname) "name", initcap(jobtitle), salary person11 upper(cat) = 'n' group initcap(fname||' '||lname), initcap(jobtitle), salary having salary >= 1.3 * round(avg(salary),0) order lname, fname error @ command line:...