anubina

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

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 …

Please how can I write a query to display only the top three earners in a table in desc order e.g Emp Sal John 100 Jam 120 Abi 90 Jo 170 the query should display Emp Sal John 200 Jam 170 thanks

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? …

Hello All, I need to generate a simple script according to the following: "Using only one update write query to update a salary by 10% for salaries below 100k and 15% for salaries above 100k" TIA

Hi i have two tables called GeneralTable and SpecializedTable which has Name and State in It LIke 1 .GeneralTable ( GName , State ) 2. SpecializedTable( SName , State ) i want to write an SQL query which display the State from where the majority of Person ( both General …

hi I have a coulumn named Status which can have only three values: 1. Available (Default) 2. Unavailable 3. CheckedOut How can I add this functionality while creating the table? i.e. while creating the table itself how can i specify that the column can hold only these 3 values and …

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 …

Hello, plz tell me a perfect book which includes all SQL Queries with solved examples. So i will do well practie with it.

Hi Friends I am working as an asst. DBA in a Software Company. I am using SQL SERVER and Oracle 9i both to create and maintain database. I am also pursuing my administration in Oracle. I usually analyze that most of the companies with high profile are using Oracle and …

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 …

i have a database containing 100 questions . i want to select random 10 from it. how to do that? there is another database containing 100 questions. questions are stored along with an attribute level. there are 10 levels. so there are 10 records whose level value is 1 and …