03-02-2009
You may want to add
SET LINE n
Where n is the max length of the line a record will be.
From the SQL*Plus doc:
SET LINESIZE sets the total number of characters that SQL*Plus displays on one line before beginning a new line.
If LINESIZE is too small, columns that cannot fit next to each other are put on separate lines.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I want to read a data from a read command and store it in a file......
Plz send me how I can do that
Ex:
read val
and I want to store this val in a file called temp. (2 Replies)
Discussion started by: krishna_sicsr
2 Replies
2. Shell Programming and Scripting
Hi,
I need to email a data in excel sheet from unix using shell scripting.I could able to generate the data file with tab delimiter with extension .xls could able to email it.
The problem is when a coulmn with 16 digit number is exported, it is showing in scientific format. Any help in... (1 Reply)
Discussion started by: sparan_peddu
1 Replies
3. Shell Programming and Scripting
Hi,
Can any one tell me how to copy data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column.
Say my text file data is:
15-dec-2008 15-dec-2009
16-dec-2008 16-dec-2009
... (7 Replies)
Discussion started by: tucs_123
7 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I need to automate a script.
The process in the script is as follows
Running the script abc.ksh
The report is stored in xyz (flat file)
Need to store the flat file content in an excel sheet.
Your reply is highly appreciated.
Thanks,
Karthick (2 Replies)
Discussion started by: karthickrn
2 Replies
5. Shell Programming and Scripting
Hii friends,
I am a newbie to unix/shell scripting and got stuck in implementing a functionality.Dear experts,kindly spare some time to bring me out of dark pit :confused:..
My requirement is somewhat wierd,let me explain what i have and what i need to do...
1) there are several excel... (1 Reply)
Discussion started by: 5ahen
1 Replies
6. Shell Programming and Scripting
Hi All,
I need to convert the data from excel to database table in sybase. Please provide some sample script..
thanks,
Royal. (1 Reply)
Discussion started by: royal9482
1 Replies
7. Shell Programming and Scripting
hi everybody,
Asking for something that I´m not sure if it´s possible to implement. I hope be clear enough.
Well, my issue is that I´m looking how to copy or extract a particular table content of a website. I get the content from a external feed (Iframe format), the content is updated every... (1 Reply)
Discussion started by: cgkmal
1 Replies
8. Shell Programming and Scripting
I need to write a script to store the contents of a table in a csv file
I'm using Toad, it's a Oracle database. (5 Replies)
Discussion started by: ladyAnne
5 Replies
9. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
10. Shell Programming and Scripting
Hello,
I have a file with the below contents :
Policy Name: Backup_bkp
Policy Type: Catalog_bkp
Active: yes
Effective date: 08/07/2013 02:02:12
Mult. Data Streams: no
Client Encrypt: no
Checkpoint: no
Policy Priority: ... (11 Replies)
Discussion started by: rahul2662
11 Replies
LEARN ABOUT LINUX
set_constraints
SET
CONSTRAINTS(7) SQL Commands SET CONSTRAINTS(7)
NAME
SET CONSTRAINTS - set constraint checking modes for the current transaction
SYNOPSIS
SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE }
DESCRIPTION
SET CONSTRAINTS sets the behavior of constraint checking within the current transaction. IMMEDIATE constraints are checked at the end of
each statement. DEFERRED constraints are not checked until transaction commit. Each constraint has its own IMMEDIATE or DEFERRED mode.
Upon creation, a constraint is given one of three characteristics: DEFERRABLE INITIALLY DEFERRED, DEFERRABLE INITIALLY IMMEDIATE, or NOT
DEFERRABLE. The third class is always IMMEDIATE and is not affected by the SET CONSTRAINTS command. The first two classes start every
transaction in the indicated mode, but their behavior can be changed within a transaction by SET CONSTRAINTS.
SET CONSTRAINTS with a list of constraint names changes the mode of just those constraints (which must all be deferrable). The current
schema search path is used to find the first matching name if no schema name is specified. SET CONSTRAINTS ALL changes the mode of all
deferrable constraints.
When SET CONSTRAINTS changes the mode of a constraint from DEFERRED to IMMEDIATE, the new mode takes effect retroactively: any outstanding
data modifications that would have been checked at the end of the transaction are instead checked during the execution of the SET CON-
STRAINTS command. If any such constraint is violated, the SET CONSTRAINTS fails (and does not change the constraint mode). Thus, SET CON-
STRAINTS can be used to force checking of constraints to occur at a specific point in a transaction.
Currently, only foreign key constraints are affected by this setting. Check and unique constraints are always effectively not deferrable.
Triggers that are declared as ``constraint triggers'' are also affected.
NOTES
This command only alters the behavior of constraints within the current transaction. Thus, if you execute this command outside of a trans-
action block (BEGIN/COMMIT pair), it will not appear to have any effect.
COMPATIBILITY
This command complies with the behavior defined in the SQL standard, except for the limitation that, in PostgreSQL, it only applies to for-
eign-key constraints.
SQL - Language Statements 2010-05-14 SET CONSTRAINTS(7)