Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: patrickman
- Order by date
-
how to create table script
Cool, thank you very much. It worked. Only thing comma is at the beginning instead of at the end. that's ok. i can create script. Thanks.- patrickman
- Post #8
- Forum: AWK
-
how to create table script
Hi, Is there is any way to take out last comma from the output. create table EMP ( EMP_NO NUMBER(10), ENAME VARCHAR2(10), SAL NUMBER(10), ) See here SAL column at the end their is comma, is it possible to take out that comma. appreicate your help.- patrickman
- Post #6
- Forum: AWK
-
how to create table script
You are just wonderful, It worked. if you can explain a bit that will be more helpful. Again thank U very much.- patrickman
- Post #5
- Forum: AWK
-
how to create table script
I don't know much, but i tried with the following. It is giving wrong. cat aa|nawk -F"\t" '{prev="";if ($1 == prev) print "CREATE TABLE "$1 ; else print $2" "$3};prev=$1'- patrickman
- Post #3
- Forum: AWK
-
how to create table script
Hi, I need help , I have a file which lot of other entities like below, i want to create for each entity a sepearate create table script like below, Any help is much appreciated. EMP EMP_NO NUMBER(10), EMP ENAME VARCHAR2(10), EMP SAL NUMBER(10) DEPT DEPTNO VARCHAR2(10) DEPT DNAME...- patrickman
- Thread
- Replies: 7
- Forum: AWK
