oracle - SQL*PLUS Concatenation Issues -

-

this question has answer here:

this sql*plus

i have table "patient" has 5 fields.

create table patient (pat_id         char (4) primary key,  pat_name       varchar (7),  admitted       date,  room           char (3),  doctor         varchar (7));  insert patient values (1001, 'fred', '30-mar-07', 101, 'payne');

i want create view output this:

patient      doctor       room         admitted     "-----------------------------------------------" 1001 fred    payne        101      march 31, 2007

the problem want concatenate pat_name , pat_id own separate "patient" column also have other 3 fields concatenated it(notice there no separation in 'dashes').

basically, have 5 fields. simplicity's sake, let's call them fields "1, 2, 3, 4, 5".

i want combine of them together, first, need combine fields 1 , 2. small column (fields 1 , 2 combined) called "patient". then, need concatenate fields 3, 4, , 5 patient column 5 fields concatenated 4 headings.

you concatenate expressions oracle || concatenation operator.

to spacing, can use rpad function pad out expressions specified length (or truncate them specified length if longer).

col myline heading "patient      doctor       room         admitted"  select rpad(p.pat_id,5)||rpad(p.pat_name,8)||rpad(p.doctor,13)        ||rpad(p.room,4)||to_char(p.admitted,'month dd, yyyy')        myline   patient p  order p.pat_id

the date value show on line formatted as

march     31, 2007

(with space in month name, oracle reserves space longest month name 'september' (?) in format model.

you may need add sql*plus directive specify length reserved display of column, e.g.:

col myline format a48

if work looks this:

patient      doctor       room   admitted     ------------ ------------ ------ ------------------ 1001 fred    payne        101    march     31, 2007

then this:

col patient  format a13 col doctor   format a13 col room     format a6 col admitted format a21  set lines 41 set feedback off  select rpad(p.pat_id,5)||rpad(p.pat_name,8) "patient"      , rpad(p.doctor,13) "doctor"      , rpad(p.room,6) "room"      , to_char(p.admitted,'month dd, yyyy') "admitted"   patient p  order p.pat_id

Comments

Post a Comment

Popular posts from this blog

java - Run a .jar on Heroku -

-
i trying run .jar file on heroku, , can't find instructions anywhere on how this. have read wants me compile uploading heroku. possible, , if is, how this? if helps, trying run minecraft craftbukkit server, , don't have pom.xml file yet. you didn't provide details i'll try give , people reaches question way it. first of all, create heroku account , create heroku application (assumed have done that). second, need generate application jar , upload heroku. so, open terminal , install heroku cli (assuming unix terminal): $ sudo npm install -g heroku-cli you need have npm , nodejs installed, can check link: https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-ubuntu-16-04 once done that, can use npm update node version acceptable heroku-cli: $ sudo npm install -g n $ sudo n 7.10.0 and run: $ sudo npm install -g heroku-cli in order deploy jars, need install deploy plugin: $ sudo heroku plugins:install heroku-cli-deploy ...
Read more

java - Jtable duplicate Rows -

-
Image
when add new rows in jtable duplicate rows many times this method update jtable public final void tableaucomande(){ ((defaulttablemodel)tabcommande.getmodel()).getdatavector().clear(); session s=hibernateutil.getsessionfactory().opensession(); criteria cr1= s.createcriteria(commande.class); list <commande> lcs=cr1.list() ; criteria cr2= s.createcriteria(lignecommande.class); list <lignecommande> lck=cr2.list() ; if(lcs.size()!=0 && lck.size()!=0) { (commande lc:lcs) { for(lignecommande lig:lck){ ((defaulttablemodel)tabcommande.getmodel()).addrow(new object[]{ lc.getid_cmd(),lc.getnumcmd(),lc.getdate_cmd(),lc.getclient().getnomprenom(), lig.getproduit().getlib_prd(),lig.getquantite(),lig.getproduit().getid_prd() }); } } // tabcommande.setrowselectioninterval(tabcommande.getrowcount()-1,tabcommande.getrowcount()-1); } } this code add add data rows displaye...
Read more

validation - How to pass paramaters like unix into windows batch file -

-
i need pass various parameters .cmd file unix format file.cmd -configuration=value -source=value -flag but, try this: startlocal @echo off cls setlocal set cmdline=%* set configuration= set source= set badargs= set validation= goto main :splitargs echo splitargs(%*) if "%*" neq "" ( /f "tokens=1,2,* delims== " %%i in ("%*") call :assignkeyvalue %%i %%j & call :splitargs %%k ) goto :eof :assignkeyvalue echo assignkeyvalue(%1, %2) if /i %1==-configuration ( set configuration=%2 ) else if /i %1==-source ( set source=%2 ) else ( rem append unrecognised [key,value] badargs echo unknown key %1 set badargs=%badargs%[%1, %2] ) goto :eof :validate echo validating set validation=fail if defined configuration ( echo -configuration ok if defined source ( echo -source ok if not defined badargs ( set validation=success ) ) ) goto :eof :main cl...
Read more