Actually, the below command gives the time as per GMT :

date -u


where as on using date , we get the time according to what we have set our time zone (TZ) as.

Hi Dipti,

You can use the below querry to get the table names in your DB:

select * from tab;

I am working on UNIX, and using CC to compile the code.

Hi,

Is it possible to display the output of a C program in different font sizes by setting it in the code? If yes, please guide regarding the same.

Thanks.

Yeah.. that worked... Thanks... :)

Hi,

I am writing a shell script, and need help with a small piece of code.
It is as below:

CUST_1=filename
b=1
c=$CUST_$b
echo $c

If you are just interested in viewing the names and not the other info about tables, you can use

select * from tab

Yes buddy, the extra sub querry is needed, as in below case :

select * from <tab> where rownum <=5
order by <a> desc

the first 5 rown are getting sorted and then ordered, which would not...

Hi,

I am not able to use any USB device on my PC(Win XP). and looking for help on this issue. Whenever I connect any pen drive or i pod to the USB port, it shows a balloon saying the name of the...

Got the soln, as below

select * from (select a from <tbl> order by a DESC) where rownum<=5;

Thanks.

Hi ,

Can we have an sql query to get the max 5 values from a column?
Please paste a sample code if its possible.

Thanks in advance.

can also name the file as shellProgramming.sh and diretly run it by giving it as

sh shellProgramming.sh

on the prompt.