I have a table with 4 rows.. id..xx..yy..zz..
now out of the 4000 rows, some data has been taken out in the middle..eg:
220 shares money casino
221 shares2 penny dollar
225 stock hello moto
229 sucks help me
230 etc eg iou
I am slightly confused as to how I would go about sorting the...
As a newbie to sql, this question may be very basic
but I have a view called 'config' and I would like to see which fields it is pulling out without running it (i.e Select * from config)
Additionally I don't know where the .sql files are stored for this view.
Lastly, i have tried sp_help...
Hi
a newbie user to unix and have tried to load emacs using emm 'emacs' command
I get this error and have no idea what it means
Any ideas?
Error msg:
Error: 0EXEC cannot find executable for 'emacs' version '20.3.0.0'
thanks in advance
Hi - The cursor below is suppose to copy data from a perm. table into a temp. table then make changes to the data and copy it back into the perm. table
Once in this temp table, I am trying to get the cursor to fill all gaps of column points as this column must be consecutive numbers.
Currently...
I currently have a table where I have to remove the type1 data (see below)
id type
1 type1
2 type1
3 type1
5 type1
7 type1
8 type2
11 type3
14 type2
15 type2
16 type2
17 type2
...
.....
Now I have removed the type1 data using
update table statements
but I need to have the...
I have a .dat file that Iam accessing using unix / SQL:
File format is:
Row 1 Row2 Row3 Row4
x y w d
x t w d
x y w 5
I need to swap the data in row4 and row1 with each other .. the fields are defined as digits but of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.