anubina

[QUOTE=kartheeee;1293268]Hi, I have oracle table for Leave LeaveNo FromDt ToDt 1 01/01/2010 31/03/2010 2 01/02/2010 31/05/2010 3 01/04/2010 30/04/2010 4 25/04/2010 15/05/2010 5 01/05/2010 31/05/2010 I want find out who was leave on 01/04/2010 to 30/04/2010. how to write oracle sql? tks in advance kartheeee[/QUOTE] [CODE] -- With hour SELECT …

[QUOTE=RicardoE;1195138]Hi, I have a table which stores 2 values as follow REC_TEST Id_Customer Id_Apply Id_Apply can take 2 values, "YES" or "NO" if he passes the test I've designed or not. I want to know if there is a way to take all "YES" and all "NO" from the same …

[QUOTE=debasisdas;835486]Try this [code=sql]select * from emp where rownum<4 order by sal desc[/code][/QUOTE] Hello, Before solution is incorrect. The good solution: [code=sql]SELECT * FROM (SELECT * FROM emp ORDER BY sal DESC) WHERE ROWNUM <= 3[/code] First step - Obtain the records with all fields in the correct order (view-inline) Second …

[QUOTE=cutedipti;951552]hello! As i am trying to insert multiple rows using following command [ICODE] insert into customer(c_id,c_name,c_city,c-street) values('C101','Hayes','Downtown','Main'), ('C102','Willum','Perryridge','North'), ('c103','Smit','Brooklyn','Park'); [/ICODE] It always gives me an error that [TEX] ERROR at line 2: command not properly ended [/TEX] Please tell me why this error is occuring & what's solution to it? …

[code] update employee set salary = salary*(case when salary < 100000 then 1.5 when salary > 100000 1.1 else 1 end); [/code] You can use a CASE ... END stament for address the factor of multiplie salary. And when the salary = 100.000 exactly? Well in this case the factor …

[QUOTE=grohit;883079]Something in these lines, dont have the exact data sample, [CODE] Select GName,SName,count(State),State from GeneralTable genTb, SpecializedTable spTb where genTb.State = spTb.State group by State [/CODE] If you could give more idea about ur sample data in the two tables and the intended result, it would be easier.[/QUOTE] i suppose …

You can create the constraint at the moment of the creation of the table [code] drop table itself; create table itself ( status varchar2(11) default 'Available' check (status in ('Available','Unavailable','CheckedOut')) ); [/code] Or you can create the constraint on the fly: [code] alter table itself add constraint ck_itself_status check ((status …

[QUOTE=cutedipti;916120]hello, I am not getting which SQL statement should be used to insert multiple data at a same time without writing [ICODE]insert into...[/ICODE] again and again. suppose whenever i want to insert data into 'customer' table then i may write statement as [ICODE]insert into customer(c_id,c_name,c_city,c-street) values('C101','Hayes','Downtown','Main')[/ICODE] But it will create …

[QUOTE=debasisdas;920125]Try the following [URL="http://www.oracle.com/pls/db102/homepage"]link[/URL] and select [B]SQL Reference[/B][/QUOTE] 100% The official documentation is excellent and the technically correct one. In the "SQL Reference" look for (Better 11g): · 2 Basics (formats models) · 3 Pseudocolumns · 4 Operators · 5 Functions (regular) · 6 Expressions · 7 Conditions **** 9 …

[QUOTE=aman_dba;900444]Offcourse we need to decide as per the organizational needs, but the question is same, what needs diffrentaite them. Or lets take like that, how company decides that it need to use SAP or Oracle. what are the features that differentiate them??[/QUOTE] Hello, I'm in MAPFRE (Spain); We have multiples …

[QUOTE=haria_kishore;863232]hi I have 3 tables - table1,table2,table3 table1 has 3 columns named col1,col2 and col3 and has 1 dummy record with values 0,1,2 respectively. The other records are my master records col1 col2 col3 0 1 2 A B C AA BB C D E F table 2 has the …

Solution for >=Ora10g (only query): [code=sql] SELECT q_level, r_number_1, r_number_2 FROM (SELECT 1 AS lev FROM dual UNION SELECT 2 AS lev FROM dual UNION SELECT 3 AS lev FROM dual UNION SELECT 4 AS lev FROM dual UNION SELECT 5 AS lev FROM dual UNION SELECT 6 AS lev …