Is there a way to use oracle text to compare two columns and show the difference between those by highlighting it? I tried searching the forum and using google but couldn't find anything (maybe I was just using wrong wording).Denes Kubicek http://deneskubicek.blogspot.com/http://www.opal-consulting. ...
Is there a tool out there which appends two columns together. this is a .txt file. ...
looks silly but needs help on ..i have to update two columns of a table in a single query ..Update table_nameset column1='X' and column='Y"Error at line 2ORA-00933:Sql command not properly endedwhats the correct syntax. ...
i want to display two columns from two tables. i have column name in table1 and another name column in table2. both column have no common values. In both tables one other column(say id) have same value. i want to display both columns in single select. i tried out with select table1.name,table2.col f ...
How to swap two columns of a table.can any body give sample query. ...
I am trying to merge two columns(col_a,col_b), I want col_a's initial letter and col_b,together put them into col_c.So, my script is:UPDATE table1 aSET col_c = (select substr(col_a,1,1)||col_bfrom table2 bWHERE a.col_n = b.col_n ); Then I got the error:ORA-01427: single-row subquery returns more tha ...
i want to compare the two columns A and B which contain numbers and then select a table with "A is smaller", "B is smaller" or "A and B are equal".for example if i have this table:A______________B 1______________53______________24______________79______________-12______________2the result should look ...
HI, The problem is this, I have two columns: start_date and end_datePrompt one : start date (for example 08/08/2008)Prompt two: End Date (for exampl 04/30/2009)so these are two different columns, do you know how to get all the data between these two dates...If I use the "between function" I only can ...
there is my next question on sql.It is possible to put two columns in one and when, how do I implement it? If there is an opportunity, may I asked to explain it on a example. =)best ...
i have to create tabular form to update Value.select "S_NO", "S_NO" S_NO_DISPLAY, "BILL_NO", "ITEM_NAME", "QTY", "RATE", "AMOUNT", from "#OWNER#"."DUMY_AC_LED_PURASE" i want if i change QTY or RATE then Multipl ...
i'd like to know if there is an ability to set two columns as a primary key ?if yes ... please tell me how to achieve that ...else .... what can i do ...
Is there any way to combine two columns(fields) in reporting without using combined analysis. i.e i have two picklist , if suppose picklistA has the following values A,B,Cand picklist B has the following values D,E,F then the resulting column should have the following values A,B,C,D,E,F.I can achiev ...
All if i had two tables which had the same column name market in them, is there a way to select both columsn via join like SELECT cv.market, ab.marketFROM tabl1 cv JOIN table2 aboncv.tradedate = ab.tradedate But instead of getting market market_1test test2 Can you get markettesttest2 ...
Inputs Table1 | Col1 (Number) | 1 |2 |3 |4 |5 |6 | and table 2 Table2 | Col1 (Number) | 7 |8 |9 |10 |11 |12 | No relation between the two tablesI want to write a select statement that will result Column 123456789101112 No sorting is required, I just need to have all the values listed in a single col ...
I need to insert 2 columns, e.g. from the table Country_ZIPCountry_Code ZIP DE 65000into the Country_ZIP_Compact tableCountry_ZIP DE65000How can I do this? ...
I have two tables have no relations, but one have first_name, last_name and address in text fields, table B has name , address but i need to search in the field to find the match. EX: Table A first_name: LLoyd last_name: Fernanda address: 123 cololbl av Table B name: peter lloyed Fernanda address: 1 ...
I have two tables ...create table1 ( col1 varchar2(20) ); create table2 ( col1 number(10) ); with their data as belowwith table1 as ( select 'xx' col1 from dual union all select 'yy' col1 from dual union all select '01' col1 from dual union all select '02' col1 from dual union all select '03' col1 f ...
i have this type of dataempno experience_years experience_months place_of_work0111 3 6 mmm2 3 nnn0112 4 6 bbb5 8 xxxHow can i get the results like empno tot_exp0111 5 years 9 months0112 10 years 2 monthsRagards ...
I am running a report that includes a first name field and last name field. Is it possible to write the query such that they are returned as one variable?like..SELECT (firstname lastname) AS fullname, title, degreeFROM facultyMake sense? New to apex, thanks for any help, I imagine this is a dumb que ...
How to find the sum of salary departmentwise after the increment from the following table?EmpId ** DeptId ** Salary ** %OfIncrement001 ***** 100 ***** 20000 ***** 30002 ***** 100 ***** 15000 ***** 25003 ***** 200 ***** 10000 ***** 15004 ***** 200 ***** 17500 ***** 10I want the SQL statement which gi ...
I have 1 tables. Scripts and some values are given below.create table T1(s_id varchar2(30), rs_id varchar2(30));insert into T1(s_id,rs_id ) values (s1,rs1 );insert into T1(s_id,rs_id ) values (s1,rs2 );insert into T1(s_id,rs_id ) values (s1,rs3 );insert into T1(s_id,rs_id ) values (s1,rs4 );The valu ...
i queried on my database as follow, SELECT C.LKP_ID ID,D.LKP_ID AS ID,C.ROOT_CAUSE_CODE AS CODE,D.PART_DISPOSTN_DESC AS CODEFROM(SELECT DISTINCTA.LKP_ID AS LKP_ID,D.PART_CNDTN_CD as ROOT_CAUSE_CODE,C.LKP_NM as ROOT_CAUSE_DESC,A.CREATED_DT AS OD_CREATED_DATE,A.UPDATED_DT AS OD_LAST_UPDATED_DATE,CURRE ...
I am using sql*plus to write reports. I want to simplify one of my reports that has multiple sub queries that calculate some of the column values. I need to add the results of two columns (queries) as well as display the results in their normal column, say columns 3 and 4 with the addition of column ...
For eg: i have a data in a table with columns A & B of same sizeA B ----------1 223 14 25 36 57 18 4910 8Through a select i want the output of my data in one single columns, Well I can do this by using union. But my output should be likeif I select by condition where A=2 my output should be 2137 ...
Ok, does anyone have a link, or advice, or information regarding howto concatenate two columns from seperate tables into a datastore?TIA,Ki ...
I have to perform a query like x,y not in(select x,y from k). How to do this. These two columns are composite primary keys in both tables although no references exists.A sample table and expected result.create table v(name varchar(10),place varchar2(10));create table t(name varchar(10),place varchar ...
How would I find the maximum of two columns in an sql statment. e.g.I want all names of employees with either the salary or the bonus, which ever is the maximum.e.g.Brown 1000Smith 200 ...
There is a requirement in our project, where we have two columns A and B and I have to find all the linked records from these columns based on the criteria mentioned for column A or B. Like if i enter in my criteria search for all the linked accounts where condition = 9A B1 21 31 44 53 66 77 89 111 ...
I want to get the value from two columns in the same table by substracting the value of one from the other.For exampleSELECT (column_a - columnb)cost FROM tablez;This syntax gives me a null value.column_a's value is larger than columnb's, so I should get some output and Ifigure it must be my syntax. ...
My query look like this. But I got this messageORA-01403: no data foundSql query(.....returning ... sqlWhat I can do ? I want to concatenate my two columns in one. -----Résultats de la rechercheBEGINDECLARErequete varchar2(5000);v_code_type varchar2(2000);v_ordre varchar2(500);BEGIN:P1_NOM_BENEFICI ...
I have table with picture. I can display common sql report(horizontal or vertical). Is it possible to display this to two columns (eshop).Two vertical columns (for example field of records 10x2).Message was edited by: user542927 ...
I want to have a check constraint for two columns (for example, C1 and C2) in a table. If C1 is not null, C2 should be 'A', but If C1 is null, C2 can be 'B', 'T', O' or others but can not be 'A'.I tried to create different kinds of Check constraint, but I can not get all of results which I respected ...
I want to have a check constraint for two columns (for example, C1 and C2) in a table. If C1 is not null, C2 should be 'A', but If C1 is null, C2 can be 'B', 'T', O' or others but can not be 'A'.I tried to create different kinds of Check constraint, but I can not get all of results which I respected ...
I am using SQL Loader to load data from a comma delimitted file. Is there a way to insert data from one field in the comma delimitted file into two columns of a table? ...
Can anyone help me out in concatenating the values of two columns ?? Please ASAP... ...
I Am struck in writing a query to merge two rows into two columns of one row.Here is the Sample data i am working with,Col 1 Col 2 Col3 Col4 Col Col65000 573-3000 2 0 Phone 5000 573-3036 1 0 Fax5000 893-5703 3 0 WOrk 3000 232-5656 1 0 Phone 3000 353-5656 2 0 FAxHere Col,Col3,Col4 form the Key.now wh ...
I have a 1000 rows in a table I would like to update with a unique value. This unique value is a cocatenation of two columns in teh same row.Each row has a date and a (ii) time and a (iii) date_time column. I would like to update the date_time (iii) column with a cocatenation of the date and (ii) ti ...
select "HOST_NAME","STATUS_NAME","STATUS_NAME" as "UC4_NAME" from "SERVERS"LEFT OUTER JOIN "STATUS" on "STATUS_ID" = "ID"LEFT OUTER JOIN "STATUS" as "UC4" on "UC4"."STATUS_ID" = "HOST_UC4"I have two columns (HOST_UC4 and HOST_STATUS) that use a lookup table named "STATUS" for its values. How should ...
How can I modify the header on an interactive report so that one column title can span two columns? I.E. column A and column B have different values but have the same column header of "A plus B" ...
I am trying to multiply two number values in two different textbox and write it to another textbox. I can use a calculate button but I prefer it to be instantly calculate the value and write it.That will be great if you can help ...
I want to have a column header span two columns while still retaining two individual column headers beneath. as an example i want to have the word salary span two columns and below this have two columns for max(salary) and avg(salary). i have included some HTML belowis it possible to do this using a ...
I want to create partitions on two dates by RANGE paritition dates are service_dt and process_dt these dates are different from each other when I try usingpartition by range(service_dt,process_dt) gave me an error'ORA-14018: partition bound list contains too few elements'How shall I specify these tw ...
hiIn a Form i want to display textbox merging two columnswhen i increading the width of textbox , elements(textbox,selectlist) in the column 2 move right side ...
I have data in two columns and i want to concatenate the two columns and concatenate sign as well. For ExampleInputidx a b 1 123.34 -23.4562 987.2111 -23.987 I know how to concatenate two columns, I want '||' as well in my output as given in required output my query does not workmy queryselect a||b ...
HiI have two columns from two different tables. How do I write a query to list the information into one result column?I have TABLE A TABLE B _Column A_ _Column B_ a d b e c f What I want isRESULT_COLUMN a b c d e f Any help here much appreciated ...
how to write a query to interchange data between two columns ?I have tried a query, does NOT work.update tmp t1 set t1.m1=t1.m2 and t1.m2=(select t2.m1 from tmp t2 where t2.student_id = t1.student_id) Thanks.Edited by: user533361 on Oct 23, 2009 2:04 PM ...
I have the following query with meselect case when F.ITEM_UOM = 'Cubic Feet' then ROUND(((H.SLURRY_VOL_ACTUAL * 5.6146)/H.SLURRY_YIELD)) when F.ITEM_UOM = 'Pound' then ceil((ROUND(((H.SLURRY_VOL_ACTUAL * 5.6146)/DECODE(H.SLURRY_YIELD,0,NULL,H.SLURRY_YIELD)))*94)*F.ITEM_PERCENT/100 ) when F.item_uom= ...
I would like the Split the single amount column into two columns : fisrt column should be positive and second column should be negtive.Pls help ...
Hello, I am creating a unique index with two columns, one number(9) and one date.This becomes a function based index with the number column and a hidden sys-column (the date).When I do queries that use this index the autotrace tells me it does things like this: sys_nc00001$>SYS_OP_DESCEND(dateval ...
How to add Two Columns in SQLFor ExampleJan Feb 215 NULLHow to add these two values in SQL ...