06-01-2009
hi tony thanks for your response....
but am not having a ready made file with me.. i have a view in oracle database..
i have to query that view create a file containing the data that came out of the view..
then send the file to some ftpserver.
hope iam clear
regards
rajesh
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need to sort the 3rd column in ascending order , each and every column are seperated by ~.
sample input file :
2~Lead Time Metrics~jennife1
2~Lead Time Metrics~mmullis
2~Lead Time Metrics~lisah
2~Lead Time Metrics~pros
2~Lead Time Metrics~kenward
can any one help me out .
i... (1 Reply)
Discussion started by: krishnan_6015@y
1 Replies
2. Ubuntu
I currently have Win 2003 setup with a server residing in the DMZ as a gateway forwarding ftp traffic via port 44000 to the ftp server behind the firewall.
I want to setup the same with RedHat Linux. Need information on what software module would duplicate the above, and pass all ftp/sftp/ssl... (1 Reply)
Discussion started by: cdlvj
1 Replies
3. Shell Programming and Scripting
i want to do 2 things
1) i should wait for a file called A.txt to fall on a specific path on the server
2) once the file arrives immediately another script called B.sh should be executed.
Could you please throw somelight on this.
Any code if already present that would be helpful.
... (13 Replies)
Discussion started by: rajesh_tns
13 Replies
4. Shell Programming and Scripting
#!/usr/bin/ksh
Archive_Dir='/apps/SrcFiles/MTCHG_GFTS/BRGR/Archive'
Source_Dir='/apps/SrcFiles/MTCHG_GFTS/BRGR'
cd $Source_Dir
HOST='xyz.abc.com'
USER='abcOUT'
PSW='xyzOUT'
file="Request*.pgp"
for i in 1 2 3 4 5 6
do
sftp $USER@$HOST <<END_SCRIPT
$PSW
bin
if ] ; then
... (3 Replies)
Discussion started by: alfredo123
3 Replies
5. Shell Programming and Scripting
Given the scenario like this, if at all if have to use IFS on the below given example, how it should be used.
IFS=/
eg:
/xyz/123/348/file1
I want to use the last slash /file1 . So can anyone, suggest me how to pick the last "/" as a IFS. (4 Replies)
Discussion started by: raghunsi
4 Replies
6. Shell Programming and Scripting
hi all,
i have to schedule an email containing the information about some orphan connections existing on the server depending upon the system date. the format of the info to be sent in email is :
Process id username servername time when connection... (0 Replies)
Discussion started by: Priyanka S
0 Replies
7. Shell Programming and Scripting
hi,
i am having three files which is having following data
file1:
field1 field2 field3
1 A B
2 C D
3 E F
file2:
4 G H
1 I J
5 K L
file3:
4 M N (3 Replies)
Discussion started by: angel12345
3 Replies
8. Shell Programming and Scripting
Hi,
My input file contains
1,2
2,4
3,6
4,9
9,10
My expected output is
1,10
2,10
3,6
4,1
9,10 (6 Replies)
Discussion started by: pandeesh
6 Replies
9. Emergency UNIX and Linux Support
Hi,
my file has the data like below:
11,231,ABCVAV
22,AAHJHAj22,hdsjkhdls
22,dhskjhdkshd
22,gdgkdkadh
11,232,dgsjgdjh
22,ghdskahdkja
22,shdkajshs
11,233,ddjs
22,dhjkahkd
22,hsajhaah
11,231,sjkjsjj
22,ahkh
22,hsakh
From the above i need only the records which starts as 11,231... (5 Replies)
Discussion started by: pandeesh
5 Replies
10. Shell Programming and Scripting
Hello Folks
I am looking for logic help for below scenerio with respect to AIX n unix script
1) We need to get the date of all the saturday in yr
2) L_o left over days is weeks left over days for previous month for eg.
first sat of feb is 4th of feb in that week we have 29 - 30 - 31 from Jan... (2 Replies)
Discussion started by: joshiamit
2 Replies
LEARN ABOUT SUSE
alter_view
ALTER
VIEW(7) SQL Commands ALTER VIEW(7)
NAME
ALTER VIEW - change the definition of a view
SYNOPSIS
ALTER VIEW name ALTER [ COLUMN ] column SET DEFAULT expression
ALTER VIEW name ALTER [ COLUMN ] column DROP DEFAULT
ALTER VIEW name OWNER TO new_owner
ALTER VIEW name RENAME TO new_name
ALTER VIEW name SET SCHEMA new_schema
DESCRIPTION
ALTER VIEW changes various auxiliary properties of a view. (If you want to modify the view's defining query, use CREATE OR REPLACE VIEW.)
You must own the view to use ALTER VIEW. To change a view's schema, you must also have CREATE privilege on the new schema. To alter the
owner, you must also be a direct or indirect member of the new owning role, and that role must have CREATE privilege on the view's schema.
(These restrictions enforce that altering the owner doesn't do anything you couldn't do by dropping and recreating the view. However, a
superuser can alter ownership of any view anyway.)
PARAMETERS
name The name (optionally schema-qualified) of an existing view.
SET/DROP DEFAULT
These forms set or remove the default value for a column. A default value associated with a view column is inserted into INSERT
statements on the view before the view's ON INSERT rule is applied, if the INSERT does not specify a value for the column.
new_owner
The user name of the new owner of the view.
new_name
The new name for the view.
new_schema
The new schema for the view.
NOTES
For historical reasons, ALTER TABLE can be used with views too; but the only variants of ALTER TABLE that are allowed with views are equiv-
alent to the ones shown above.
EXAMPLES
To rename the view foo to bar:
ALTER VIEW foo RENAME TO bar;
COMPATIBILITY
ALTER VIEW is a PostgreSQL extension of the SQL standard.
SEE ALSO
CREATE VIEW [create_view(7)], DROP VIEW [drop_view(7)]
SQL - Language Statements 2010-05-14 ALTER VIEW(7)