Recent content by ang90

Hello, I want to see '000.00' in a decode result. Can someone tell how to print it? I can print 999.99 but not 000.00. Its converting into 0.

Hi, Thank you ... My query involves 5 tables with multiple joins .. I am not retrieving data from 4 tables using join condition on a column from first table. Please take a look at the below code. Can you suggest how I can use full outer join here on all join conditions select PRO.EID...

Hello, Can someone show an example of full outer join on multiple table joins .. If I am joining 5 different tables using 4 different fields ... In my situation, I have no idea how much data is missing in various tables and so I am considering using full outer joins in all join clauses. Just...

Hello, I downloaded a database tool that reverse engineered the database creating logical model of the database. Its an ER diagram. The database has around 100 tables and so, the diagram won't fit in one screen. Does anyone has any idea how that diagram should be shown to someone or printed on...

Hi. Here week 20 of 2005 means the first day of week 20 of year 2005 (assuming that it is 05/07/2005. I think the actual date comes from a date function). That corresponds to Day0 column in the same record. Next Day1 column corresponds to the next day which is 05/08/2005. Day2 becomes...

Mufasa, Thank you. I was a bitr absent-minded that I forgot the + operator. It works . Thanks.

I am employed as a developer. Thank you.

I have a table as shown below. The table is: EmpId Week Year Day0 Day1 ..... Day14 100 20 2005 8 8 8 200 22 2003 0 0 8 300 25 2004 8 8 0 400 06 2005 0 8 8 500 08 2002 8 0 8 I am trying to select emp records as follows: EmpId, Date...

Hi, I am trying to select sum of two columns in a table for each row .. The table has ID, Value1, Value2 columns. I am trying to select ID, Value1, value2, sum(value1, value2) for every row. Can someone help? Thanks.