Sunday, October 4, 2009

Thanks a lot Recuva

There was a virus in my PC, so that I had to format it. While I was trying to back up my data, some of them were accidentally deleted (shift + delete). :(

I asked my friends about a software to recover deleted data and I found

Recuva

Thanks RECUVA, I successfully recovered most of deleted files.

But, there are some rules to keep in mind when recovering.

You can go through below links where I found this software.

Top 10 FREE Data Recovery Software

And, I downloaded this from
Download Recuva from FileHippo.com

:)

Wednesday, August 5, 2009

Oracle Report Builder Order by Issue

When we use Oracle, we can have SQL Navigator for back end packages, Form Builder for creating forms and Report Builder to generate reports. There was an issue in a report that was to order by using name for a sub data model query(not the main data model query) and several times this issue was reported, but when I go through the report, it was already ordered by name.

Assume,
branch and dept are tables in the database.
name and code are some table columns (fields) in these both tables.

Suppose the main data model query was,

SELECT branch.code, branch.name
FROM branch
ORDER BY branch.code;

And, sub data model query was,

SELECT dept.code, dept.name
FROM dept
ORDER BY dept.name;

As we know, according to the second query, department details should be ordered by name. But, in my case, this didn't happen.

The sub data model (not the sub data model query) in the Report Builder appeared as

code
name

So, we changed the positions of those fields (name to be in the first position) in the sub data model (not in the sub data model query).

Thereafter, it displayed like

name
code

Then, we run the report, it ordered properly and the issue was successfully sorted out. :)

But, even we don't change the field which is going to be ordered to the first position in the data model, it works for some cases. So, if anyone knows the exact reason for this, I wish, you will definitely share your ideas with me. :)

Sunday, May 17, 2009

Congratulations Sri Lanka

Congratulaions his Excellency Mahinda Rajapaksa, President of Sri Lanka, Sri Lankan soldiers and everyone who contended.

Finally, we won the freedom.

Sunday, May 3, 2009

Examinations...

We attend
And listen for lessons
But do not go thought..
After classes
Sleep like a log..
When exams come
We do not sleep
But study hard
And make efforts
To pass the exams..
After exams
Again...
We continue our
Normal lives
And after one or two years
We forget everything..
Are these exams practicable?
Can students get
A comprehensive knowledge?