Search Results

am using AIX and I have a string "There is no process to read data written to a pipe". I want to get the output 2 lines before and 4 lines after this string. The string is present like more than 100...

still not working, its giving me an error

I got an Oracle database statement which displays the data of the last 7 days in my script

The statement is :

select * from TABLE_NAME
WHERE DATETIME BETWEEN to_char((sysdate-7,MM),...

I am currently writing a script in AIX
I connected to the database using SQL *PLUS
I need to retrive data of Number of rows inserted today in the table(TABLE_NAME) which has column...

Its giving me error saying Table or View doesn't exist
I gave all the correct table details

Each table has actively maintained date column and I use toad to connect to oracle database.
Is there any way to find out that the certain table is the only table in the tablespace?

I need to write a unix shell script to connect to oracle database and retrieve data from a table, the script should count the total number of rows till date in that table
number of rows which are...

Thx a lot!

The code is perfect now

Can you guide me regarding how to get the next few lines attached to this date string (suppose 4 lines)

TODAY=$(perl -e '@now=localtime; printf "%02d/%02d/%02d\n", $now[4]+1,$now[3],($now[5]+1900)%100')

YESTERDAY=$(perl -e '@now=localtime(time - 86400); printf "%02d/%02d/%02d\n",...

Still not working



I am currently using AIX

I need a script to search for *.LOG in a directory, output the line after the current date and yesterday's date and also output the next 5 lines after the current date and yesterday's date

I have...