Search Results

Hi,
In the course of my script i have to compare SYSDATE with the 15th of the current month:
if it is greater than i should set a variable date to 15th of the next month
if less than i should set...

Try %u it is the unsigned integer format specifier used in C programming just like printf command.
I hope it will work with awk.

If you want the absolute value of the number you want to print,
why don't you store it as an absolute value in the first place,
i.e., c = abs (a - b)
note that you should include the external...

Hey! I asked the dba manager at my departement and he showed me the code. I thought of sharing it with you.
As he said using sys.Tables would exhaust the server and it is forbidden in live...

the same error keeps coming over and over again... it might be security settings.
I'll ask about it.
thank you anyway vidyadhar85

thank you anyway,
but i recieved an error ORA-00942: table or view does not exist ...
should i then create a view to see all the tables??
then how do i do that with unix?

Using ksh and sqlplus... does anybody have an idea of how we can possibly extract all table names from server :confused:?

thanks in advance.

Thank you a lot Vi_Curious and jim!
This itty-bitty line of code works great! :b:

Well,
This table is used in billing at a telecommunications company, so it contains all subscribers' tel. numbers and bill amounts, bill dates,... supposedly.
if i only select the subno column and...

:rolleyes: hi there everybody,
i need help,... thanks anyway!
i am working on a very huge table with the name table1. the problem is that i know only one field name in this table...,
working with...