Sponsored Content
Top Forums Programming SQL for table with column (varchar2 2000) and line break in it Post 302422007 by spidermike on Monday 17th of May 2010 09:00:37 AM
Old 05-17-2010
Perfekt, that's it then!

Thanks again for your help Smilie

cheers
Mike
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Installing Ms Sql Server 2000 On Unix

Hello As per requirements, can i Install a MSSQL SERVER on UNIX , is it possible., can i install or not.., could u plz give me reply with some installation details.......... Regards&Thanking You sreedhar G (1 Reply)
Discussion started by: sreedhargunda
1 Replies

2. Shell Programming and Scripting

how to break mysql dump sql file

Hi folks I have mysql dump which having insert queries, i want to break that file when 10 complete "INSERTS" lines so extract that line and store in 1.sql and 2.sql and for next 10 insert lines. pls guide me how can i do that. Regards, Bash (2 Replies)
Discussion started by: learnbash
2 Replies

3. UNIX for Dummies Questions & Answers

Extracting column names from a table.. SQL with UNIX

: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 a ksh environment i don't know how to view the table to check out the field names :confused:. ... (4 Replies)
Discussion started by: fmina
4 Replies

4. AIX

problem using VARCHAR2

Hi... i have currently installed db2 version 9.1.2 on my AIX machine... No matter what i do,.... VARCHAR2 just doesn't seem to be working! This is the error i ketp getting after i ran a simple create statement... $db2 "create table tst (name VARCHAR2(30));" DB21034E The command was... (2 Replies)
Discussion started by: VGR
2 Replies

5. Shell Programming and Scripting

the easiest way to break down this column?

i have a one column txt file, which has a large amount of data which look like this a 11 3 b 45 77 r 7 9 blah blah blah what i am trying to do here is for every 3 lines, i want to move the 2nd and 3rd line to the first line, so it will look like this a 11 3 b 45 77 r 7 9 (8 Replies)
Discussion started by: fedora
8 Replies

6. Shell Programming and Scripting

BASH: Break line, read, break again, read again...

...when the lines use both a colon and commas to separate the parts you want read as information. The first version of this script used cut and other non-Bash-builtins, frequently, which made it nice and zippy with little more than average processor load in GNOME Terminal but, predictably, slow... (2 Replies)
Discussion started by: SilversleevesX
2 Replies

7. Shell Programming and Scripting

Break a line content and print as column

Hi, I have urls in my input file like this http://unix.com/abc/def http://unix.com/kil/min I want to use the / as separator and print the last content as another column like this http://unix.com/abc/def def http://unix.com/kil/min min I was using awk -F option and then joining the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

8. Shell Programming and Scripting

Split column data if the table has n number of column's

please write a shell script Table -------------------------- 1 2 3 a b c 3 4 5 c d e 7 8 9 f g h Output should be like this --------------- 1 2 3 3 4 5 7 8 9 a b c c d e f g h (1 Reply)
Discussion started by: Priti2277
1 Replies

9. Shell Programming and Scripting

Split column data if the table has n number of column's with some record

Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records Table --------- Col1 col2 col3 col4 ....................col20 1 2 3 4 .................... 20 a b c d .................... v ... (11 Replies)
Discussion started by: Priti2277
11 Replies

10. Shell Programming and Scripting

Break a line content and print as column

Hi, I have urls in my input file like this (1 Reply)
Discussion started by: tmonk1
1 Replies
substrate(6x)							XScreenSaver manual						     substrate(6x)

NAME
substrate - Grow crystal-like lines on a computational substrate SYNOPSIS
substrate [-display host:display.screen] [-foreground color] [-background color] [-wireframe] [-max-cycles cyclecount] [-growth-delay delayms] [-initial-cracks numinitial] [-max-cracks nummax] [-sand-grains numgrains] [-circle-percent circlepercent] [-fps] DESCRIPTION
Lines like crystals grow on a computational substrate. A simple perpendicular growth rule creates intricate city-like structures. Option- ally, cracks may also be circular, producing a cityscape more familiar to places for which city planning is a distant, theoretical concern. Ported from the code by j.tarbell at http://complexification.net OPTIONS
substrate accepts the following options: -wireframe (Default: False) Don't draw sand-painting colored effects, only make a wireframe. -max-cycles cyclecount (Default: 10000) Maximum number of growth cycles before restarting. The higher this is, the more complex the art. -growth-delay delayms (Default: 18000) Delay in ms between growth cycles. More delay, slower (but smoother and less CPU intensive) art. -initial-cracks numinitial (Default: 3) Initial number of cracks in the substrate -max-cracks nummax (Default: 100) Maximum number of cracks in the substrate at a single time -sand-grains numgrains (Default: 64) Number of sand grains dropped during coloring. More grains cause a denser colour but use more cpu power. -circle-percent circlepercent (Default: 0) The percentage of the cracks will be circular. -fps Display the current frame rate and CPU load. ENVIRONMENT
DISPLAY to get the default host and display number. XENVIRONMENT to get the name of a resource file that overrides the global resources stored in the RESOURCE_MANAGER property. SEE ALSO
X(1), xscreensaver(1) COPYRIGHT
Copyright (C) 2003 by J. Tarbell (complex@complexification.net, http://www.complexification.net). Ported to XScreensaver 2004 by Mike Kershaw (dragorn@kismetwireless.net) AUTHOR
J. Tarbell <complex@complexification.net>, Jun-03 Mike Kershaw <dragorn@kismetwireless.net>, Oct-04 X Version 11 5.15 (28-Sep-2011) substrate(6x)
All times are GMT -4. The time now is 02:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy