Search Results

Have you tried putting those commands into a script?

ie:

echo "cd <path>" >file1.ksh
echo "cat <filename>" >> file1.ksh
chmod +x file1.ksh

make sure it's owned by <username>

then try...

Cute .. learn something new everyday :)
I guess I'm done for today ... G'night everyone! :p

Define "full path" .
is it:

1) starting with a slash "/" ?
then just check first character for a "/"


IAMIN=`pwd`

if [[ `echo $IAMIN | cut -c1` == "/" ]]
then
echo true
else
...

I was able to do it this way .. no as "slick" as a 1-line awk pilnet posted .. but still works :)
might be easier to read, as well? for us rookies, anyway

for i in `cut -f1 file1`
do
if...

Increase the size of your TEMP tablespace - it's not big enough ..

Ok, and what does this file look like:

. /home/bscs6/.kshrc

?

Can you show results of these commands:


which sqlplus

sqlplus
(log in manually)

exit;

export ORACLE_SID=SEGODI

sqlplus /nolog

connect sysadm/sysadm

SQL> create table junk
2 (field1 number,
3 field2 number,
4 field3 number )
5 /

Table created.

SQL>
SQL> insert into junk values ( 3291234567, 333991123456789,...

Again .. don't do this:

sqlplus -s <login>/<password>@<CONNECTION_NAME>

it leaves the password visible by anyone else logged into the system.

do:

sqlplus -s /nolog << EOF
connect...

Irregardless of your final destination, you have a problem, and are troubleshooting.

Create a script file for test purposes .. and see how it behaves ...
You just might find how much easier it...

As an Oracle DBA, I'd strongly recommend some changes to the way you're doing things.

don't use:
sqlplus -s <login>/<password>@<CONNECTION_NAME>

That makes your password visible to anyone...

Ah, must have misread you then .. no worries :)

Can you show an example? I read over the man page and couldn't see any reason it should exclude a date 29 days ago, when you indicate 14
:confused:

That seems like a pretty generous round off...

that command seems to work fine for me ... shows me files from Nov 17, Nov 3, and older,
but not a file from Nov 28.

Can you show some ls -ltr commands and getfacl commands on the files you...

Simple method might be something like:


for i in `cat $file2`
do
head -$i $file1 | tail -1
done


not sure if there's a cleaner or more efficient way, though :)

You're using "NUMTODSINTERVAL"
you probably want to use: "NUMTOYMINTERVAL"
instead ;)

Data Types (http://docs.oracle.com/cd/E11882_01/server.112/e41084/sql_elements001.htm#i128552)

Probably a rookie answer here, but if you're talking just scanning for the first error in a given log file, I've used this logic successfully in the past:


LN=`grep -n "<error>" <log_file> |...

I'm an Oracle guy, not very familiar with MYSQL .. :) I was thinking his issue was the fact that:

where column = 'today'

is not the same as:

where column = today

if today is some...

Notice how you're using the "columns" here in quotes?

between 'today' and 'monthago')


try doing the same thing when selecting:


select id, 'today', 'monthago', today, monthago
from (...

it looks like it's *trying* to remove tabs and spaces, with a single space.
the items in square brackets are the list of matches it'll look for, the "*" after the square bracket says "0 or more of...

I suppose you could try:


cat missing_revenue_20141112.csv | tr -d '\n'


however, I doubt that'll have the effect your expecting :)

hint: read the man page MadeInGermany provided ;)

It wasn't fine before .. you changed it.

2nd version added this:


case "$id" in


turning the underlined portion into part of a case statement - and it's the wrong syntax for a case...

Yep :) (sorry if I didn't make that clearer earlier :) sometimes you get so used to things, you "assume" they're obvious .. :D )

Well, that's why I suggested external tables first :)

But from a DB standpoint, I see the data as needed in the database, hence the load. Agreed, he didn't explicitly ask how to load it, but...

unix variables generally are not available within SQL.

You need to pass them in to use them ...

Again, I'd definitely handle this using SQL*loader, or external tables, not via unix. Might...