for example there are three names in table
ADAMS
DAVE
SMITH
i should get the name that has two A's in it
rahulae
Last Activity: Sep 22 '08, 08:05 PM
Joined: Jul 10 '08
Location:
-
How to find who is eldest from date of birth
how can we find who is eldest from his date of birth -
how to count no of times a letter occurs in oracle
im trying get the occurence of a particular letter and then depending on that result i have to find the name from table that has more than 1 occurence of particular letter -
calculate business days in a year(excluding holidays and weekends)
help me with this
I'm able to calculate total working days excluding weekends but how to exclude holidays,is there any other way apart from storing all the holidays in some table and not selecting those or else is there any other option -
thanx im able to do it using decodeLeave a comment:
-
case function does not work in oracle 8i,so can u please tell me how to use decode function.Leave a comment:
-
How to sort columns and rows in oracle
The output that i'm getting is
deptno sum(sal)
10 8750
20 10875
30 9400
when i execute the query select deptno,sum(sal) from emp group by deptno;
I should get the total sal of each dept in such a way that output should be like this
which is below
Output:
10 20 30
8750 10875 9400 -
Thanx for ur help it worksLeave a comment:
-
i have to write a query in such a way i have to get no of employees joined on a particular day.
i have written the following query
select count(*)"no of emp joined",to_char (hiredate,'day' ) "day" from emp group by to_char(hiredat e,'day');
output:
no of emp joined day
2 friday
1 monday
2 ...Leave a comment:
-
how to sort days in oracle
help me with this, i need to sort the order to be like sun,mon,tue,wed ,thu,fri,sat -
how to write a check constraint expression to solve my problemLeave a comment:
-
plz tell me how to write it
i mean syntaxLeave a comment:
-
Validation
How does that concept of constraints help solve my problem
see my problem is whenever i try to insert a room_type into a table it shouldn't allow any other types other than that i have listed.
what can i do to solve this.
will using a constraint solve this out.
if yes what type of constraint and give me an exampleLeave a comment:
-
Is there any way to validate that column without using different table and constraintLeave a comment:
-
can you tell me how to create constraint for that because the valid room types are around 4Leave a comment:
-
its not like that i have to write a procedure where in i should be able to insert a room and while inserting i should see that room type is valid.
valid types i have listed already.
I cannot use one more tableLeave a comment:
-
How to validate a column using stored procedure
I have a column name Room_type ,the valid room types are bedroom,dining room,living room,kitchen,ba throom.
I have to validate the room_type column such that only valid room types are allowed. -
Exception handling in stored procedures
How to do Exception handling in SQL Server stored procedures -
yes ur right after updating status i should be able to use trigger to update total_salesLeave a comment:
-
delerna or administrator plz help me outLeave a comment:
No activity results to display
Leave a comment: