www.itsmetor.com

Oracle determine what tables have rows

Tor — Wed, 16 May 2012 16:15:14 +0000

To determine what tables contain row data

1
2
3
4
5

SELECT table_name, num_rows
FROM all_tables
WHERE owner IN ('USER')
AND num_rows > 0
ORDER BY table_name;

LOC Visual Studio

Tor — Wed, 09 May 2012 13:21:19 +0000

Visual Studio Plugin: http://www.wndtabs.com/

Powershell (counts non blanks):

1
2
3

PS C:\> (dir -include *.cs,*.xaml -recurse | select-string .).Count
8396
PS C:\>

Customize the extension list as needed:

1
2
3

PS C:\> (dir -include *.cs,*.cpp,*.h,*.idl,*.asmx -recurse | select-string .).Count
909402
PS C:\>

Slick Edit Gadgets http://www.slickedit.com looked promising but I didnt try it.

SMTP email through Microsoft 365 via C#

Tor — Tue, 08 May 2012 16:21:24 +0000

An example of how to use the System.Net namespace to send emails (useful for ssl or tls mail servers).

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

SmtpClient server = new SmtpClient("Smtp.mail.microsoftonline.com");
server.Port = 587;
server.EnableSsl = true;
server.Credentials = new System.Net.NetworkCredential("xxx@domain.com", "secret");

MailMessage mail = new MailMessage();
mail.From = new MailAddress("xxx@domain.com");
mail.To.Add("johndoe@domain.com");
mail.Subject = "test subject";
mail.Body = "this is my message body";
mail.IsBodyHtml = true;

try
{
server.Send(mail);
}
catch (Exception ex)
{
throw ex;
}

Taken from here: http://stackoverflow.com/questions/6656039/sending-email-using-smtp-mail-microsoftonline-com/7009204#7009204

Epson ESC commands

Tor — Thu, 03 May 2012 18:24:48 +0000

Useful commands for controlling Epson POS printers. Use ASCII values.

a. Cause a cutter activation TM-T88V

27 + 105 + 0
ESC + i + NULL

b. Cause a drawer kick command TM-U375

27 + 112 + 48 + 25 + 63
ESC + p + 0 + EM + ?

Note: other documentation indicated to use: 27 + 112 + 48 + 25 + 250

c. Case a drawer kick command TM-T88V

27 + 112 + 48 + 55 + 121
ESC + p + 0 + EM + y

d. Activate the slip port (Epson TM-H6000 III and Epson TM-U375)

Full Codes Listing (not verified): http://keyhut.com/popopen.htm

Manufacturer	Model	Drawer Codes	Cutter Codes
Axiohm	A715 A756 A794	27,112,0,48,251 OR 27,112,1,49,251	27,105 – Full 27,109 – Partial
Bixolon	SRP-275	27,112,48,55,121	.
Bixolon	SRP-280	27,112,0,64,240	.
Bixolon	SRP-350	27,112,0,50,250	.
Bixolon	SRP-375P	27,112,48,55,121	.
Code Soft	DP7645III	27,112,48,55,121	.
Dell	T200	7	.
EC-Line	EC-PM-520	27,112,0,40,168	.
Epson	?	27,112,48,55,121	.
Epson	TM-T20	27,112,32,25	.
Epson	M51PD	27,112,0,25,250	.
Epson	TM-T60	27,112,32,25	.
Epson	TM-L60II	27,70,0,50,50	.
Epson	TM-T70	27,112,48,55,121	27,109
Epson	TM-T81	27,112,0,25,250	.
Epson	TM-T85	27,112,0,25,250	.
Epson	TM-T80P	27,112,0,25,250	.
Epson	TM-T88	27,112,0,25,250	27,109
Epson	TM-T88II	27,112,0,25,250	27,121
Epson	TM-T88IIP	27,112,48,55,121	27,109
Epson	T88iii	27,112,0,25,250	27,109
Epson	T88iiiP	27,112,0,64,240	27,109
Epson	TM-88IV	27,112,48,55,121	27, 109
Epson	TM-88V	27,112,48,55,121	.
Epson	TM-90	27,112,0,25,250	27,109
Epson	M115A	27,112,0,25,250	.
Epson	M129C	27,112,0,64,240	27,109
Epson	M188A	27,112,0,25,250	.
Epson	M188B M188D	27,112,48,55,121	27,112,0, 5,250
Epson	M192C	27,112,0,64,240	27,109
Epson	M192H	27,112,0,64,240	27,109
Epson	T200	27,112,0,25,250	.
Epson	TM-200	27,112,0,64,240	.
Epson	TM-200	27,112,0,25,250	27,112,0,75,250
Epson	TM-U200B	27,112,48,25,250	.
Epson	TM-U200D	27,112,0,64,240	.
Epson	TM-U210PD TM-U210D	27,112,0,25,250	27,112,0,75,250
Epson	TM-220	27,112,0,25,250 OR 27,112,0,64,240	.
Epson	TM-U220	27,112,0,25,250 OR 27,112,0,64,240	.
Epson	TM-U220A TM-U220PD	27,112,0,25,250 OR 27,112	27,112,0,75,250 OR 27,105
Epson	TM-U220B TM-U220PD	27,112,0,25,250	.
Epson	TM-U220D TM-U220PD	27,112,0,25,250	27,112,0,75,250
Epson	TM-U295	27,112,48,55,121	.
Epson	ADP 300	27,112,0,25,250	.
Epson	TM-300D	27,112,0,25,250	27,105
Epson	LX-300+	27,112,0,25,250 OR 27,112,48,55,121	.
Epson	TM-U300PC TM-U300PD	27,112,0,25,250	.
Epson	TM-U325D	27,112,0,25,250	.
Epson	TM-U375	27,112,0,25,250	.
Epson	ECP-500	27,112,48,55,121	.
Epson	M665A	27,112,48,55,121	.
Epson	TM-T883P	27,112,0,50,250	27,109
Epson	TM-U950P	27,112,0,50,250	.
Epson	TM-H5000II	27,113,0,25,250 OR 27,25,247	.
Epson	TM-H6000	27,112,48,55,121	.
Epson	TM-J7100	27,112,48,55,121	27,109
Fujitsu	fp-350	27,112,0,48,251	.
Fujitsu	fp-410	27,112,1,49,251	.
HP	A799-C40W	27,112,0,8,8	.
IBM	4610	7	.
IBM	4610	27,112,0,50,250	27,12
IBM	Sure POS	27,112,0,250,250	.
Ithaca	PcOS 50	27,112,0,25,250 or 7	.
Ithaca	PcOS 51	27,112,0,25,250 or 7	.
Ithaca	PcOS 52	27,112,0,25,250 or 7	.
Ithaca	POSjet	27,112,0,25,250	.
Ithaca	80 PLUS	27,120,1	27,118
Ithaca	SERIES 90	27,120,1	.
Ithaca	SERIES 94	27,120,1	.
Ithaca	150	27,120,1	.
Ithaca	280	27,112,1,49,251	27,105 27,109
Ithaca	iTherm 280	27,120,1 27,120,2	27,118
Ithaca	POSjet 1000	27,120,1	.
MetaPace	T1	27,112,48,55,121	.
NCR	7167 7179 7197	Drawer #1 27,112,0,55 Drawer #2 27,112,1,55	27, 105 27, 109
NCR	7223	27,112,80,25,250	27, 112,1,55
NEXA	PX700	27,112,0,50,250	.
Obvios	ORP-800	27,112,0,25,250	.
Oki	OKIPOS 407	7	27,100,49
Oki	OKIPOS 1000	27,120,1	27,118
Olivetti	PRT-100	27,112,0,25,250	27,12,0,25,250
POS-X	XR-200	27,112,0,25,250	27,105
POS-X	XR-500	27,112,0,25,250	27,105
POS-X	EVO-RP1	27,112,0,25	27,105
Posiflex	CR 4200	27,112,80,25,250 OR 27,112,0,25,250	.
Posiflex	AURA 5600 AURA 8000	27,112,0,25,250 or 27,112,80,25,250	.
Posiflex	PP6000 PP7000 PP8000	27,112,0,25,250	.
Samsung	STP 131	27,112,0,48,50	.
Samsung	SRP 220	27,112,48,55,121	.
Samsung	SRP 270	27,112,0,25,250 OR 27,112,0,60,240	.
Samsung	SRP 270A	27,112,0,64,240	.
Samsung	SRP 275 SRP-275AP SRP-275C	27,112,48,55,121	.
Samsung	SRP 350	27,110,0,25,250	.
Samsung	SRP 350T	27,112,0,50,250	.
Seiko	ESC-POS RP-B10	Drawer #1 27,112,0,50,250 Drawer #2 27,112,1,50,250	Full cut 27, 105 Part cut 27, 109
Star	All?	27,7,11,55,7	.
Star	TSP 100	7	27,100
Star	TSP 100IIU	27,7,11,55,7	27,100,48
Star	SP200 SP200-2 SP212	27,7,11,55,7	.
Star	TSP200	27,7,11,55,7	27,100,48
Star	SP500	27,122,49,7 OR 27,7,11,55,7	27,100,48
Star	SP512	27,122,49,7	27,100,48
Star	SP550II	27,7,10,50,7	.
Star	TSP-600	7 OR 27,7,10,50,7	27,100,51
Star	TSP-650	7 27,7,10,50,7 27,7,11,55,7	.
Star	TSP-700	27,07,11,55,07	27,100,51
Star	SP2000	27,122,49,7	27,100,48
Star Micronics	TSP-650	27,112,0,48	.
Star Micronics	dp-8340fm	27,7,11,55,7	.
TEC	RKP300	27,112,0,100,250	27,105
TEC	TRST-A10	27,112,48,55,121	.
TEC	TRST-53	27,112,0,100,250	27,105
Toshiba	TRST-A10	27,112,48,55,121	.
Toshiba	SX2100	27,112,32,55,255	.
TOSHIBA TEC	DRJST-51	27,112,0,100,250	27,105
TPG	A776 A794 A798	27,112,1,49,251	.
TPG	A799	27,112,0,8,8	.
Tysso	PRP076	27,112,0,50,250	.
Unisys	EF4272	27,112,0,100,250	.
WASP	F100 WTP-100	27,112,49,48,48	27,105
WESTREX	4200	7	20

C# convert string to enum

Tor — Wed, 02 May 2012 14:27:03 +0000

1
2
3
4
5
6
7
8
9
10

enum Colour
{
Red,
Green,
Blue
}

// ...
Colour c = (Colour) Enum.Parse(typeof(Colour), "Red", true);
Console.WriteLine("Colour Value: {0}", c.ToString());

Taken from here:

http://blogs.msdn.com/b/tims/archive/2004/04/02/106310.aspx

Syntax for Wireshark Filters

Tor — Thu, 26 Apr 2012 14:52:12 +0000

Taken from here:

http://www.wireshark.org/docs/wsug_html_chunked/ChWorkBuildDisplayFilterSection.html

6.4. Building display filter expressions

Wireshark provides a simple but powerful display filter language that allows you to build quite complex filter expressions. You can compare values in packets as well as combine expressions into more specific expressions. The following sections provide more information on doing this.

You will find a lot of Display Filter examples at the Wireshark Wiki Display Filter page at http://wiki.wireshark.org/DisplayFilters.

6.4.1. Display filter fields

Every field in the packet details pane can be used as a filter string, this will result in showing only the packets where this field exists. For example: the filter string: tcp will show all packets containing the tcp protocol.

There is a complete list of all filter fields available through the menu item “Help/Supported Protocols” in the page “Display Filter Fields” of the Supported Protocols dialog.

XXX – add some more info here and a link to the statusbar info.

6.4.2. Comparing values

You can build display filters that compare values using a number of different comparison operators. They are shown in Table 6.4, “Display Filter comparison operators”.

You can use English and C-like terms in the same way, they can even be mixed in a filter string!

Table 6.4. Display Filter comparison operators

English	C-like	Description and example
eq	==	Equal ip.src==10.0.0.5
ne	!=	Not equal ip.src!=10.0.0.5
gt	>	Greater than frame.len > 10
lt	<	Less than frame.len < 128
ge	>=	Greater than or equal to frame.len ge 0x100
le	<=	Less than or equal to frame.len <= 0x20

In addition, all protocol fields are typed. Table 6.5, “Display Filter Field Types” provides a list of the types and example of how to express them.

Table 6.5. Display Filter Field Types

Type	Example
Unsigned integer (8-bit, 16-bit, 24-bit, 32-bit)	You can express integers in decimal, octal, or hexadecimal. The following display filters are equivalent: ip.len le 1500 ip.len le 02734 ip.len le 0x436
Signed integer (8-bit, 16-bit, 24-bit, 32-bit)
Boolean	A boolean field is present in the protocol decode only if its value is true. For example, tcp.flags.syn is present, and thus true, only if the SYN flag is present in a TCP segment header. Thus the filter expression tcp.flags.syn will select only those packets for which this flag exists, that is, TCP segments where the segment header contains the SYN flag. Similarly, to find source-routed token ring packets, use a filter expression of tr.sr.
Ethernet address (6 bytes)	Separators can be a colon (:), dot (.) or dash (-) and can have one or two bytes between separators: eth.dst == ff:ff:ff:ff:ff:ff eth.dst == ff-ff-ff-ff-ff-ff eth.dst == ffff.ffff.ffff
IPv4 address	ip.addr == 192.168.0.1 Classless InterDomain Routing (CIDR) notation can be used to test if an IPv4 address is in a certain subnet. For example, this display filter will find all packets in the 129.111 Class-B network: ip.addr == 129.111.0.0/16
IPv6 address	ipv6.addr == ::1
IPX address	ipx.addr == 00000000.ffffffffffff
String (text)	http.request.uri == “http://www.wireshark.org/”

6.4.3. Combining expressions

You can combine filter expressions in Wireshark using the logical operators shown in Table 6.6, “Display Filter Logical Operations”

Table 6.6. Display Filter Logical Operations

English	C-like	Description and example
and	&&	Logical AND ip.src==10.0.0.5 and tcp.flags.fin
or	\|\|	Logical OR ip.scr==10.0.0.5 or ip.src==192.1.1.1
xor	^^	Logical XOR tr.dst[0:3] == 0.6.29 xor tr.src[0:3] == 0.6.29
not	!	Logical NOT not llc
[...]		Substring Operator Wireshark allows you to select subsequences of a sequence in rather elaborate ways. After a label you can place a pair of brackets [] containing a comma separated list of range specifiers. eth.src[0:3] == 00:00:83 The example above uses the n:m format to specify a single range. In this case n is the beginning offset and m is the length of the range being specified. eth.src[1-2] == 00:83 The example above uses the n-m format to specify a single range. In this case n is the beginning offset and m is the ending offset. eth.src[:4] == 00:00:83:00 The example above uses the :m format, which takes everything from the beginning of a sequence to offset m. It is equivalent to 0:m eth.src[4:] == 20:20 The example above uses the n: format, which takes everything from offset n to the end of the sequence. eth.src[2] == 83 The example above uses the n format to specify a single range. In this case the element in the sequence at offset n is selected. This is equivalent to n:1. eth.src[0:3,1-2,:4,4:,2] == 00:00:83:00:83:00:00:83:00:20:20:83 Wireshark allows you to string together single ranges in a comma separated list to form compound ranges as shown above.

6.4.4. A common mistake

Using the != operator on combined expressions like: eth.addr, ip.addr, tcp.port, udp.port and alike will probably not work as expected!

Often people use a filter string to display something like ip.addr == 1.2.3.4 which will display all packets containing the IP address 1.2.3.4.

Then they use ip.addr != 1.2.3.4 to see all packets not containing the IP address 1.2.3.4 in it. Unfortunately, this does not do the expected.

Instead, that expression will even be true for packets where either source or destination IP address equals 1.2.3.4. The reason for this, is that the expression ip.addr != 1.2.3.4 must be read as “the packet contains a field named ip.addr with a value different from 1.2.3.4″. As an IP datagram contains both a source and a destination address, the expression will evaluate to true whenever at least one of the two addresses differs from 1.2.3.4.

If you want to filter out all packets containing IP datagrams to or from IP address 1.2.3.4, then the correct filter is !(ip.addr == 1.2.3.4) as it reads “show me all the packets for which it is not true that a field named ip.addr exists with a value of 1.2.3.4″, or in other words, “filter out all packets for which there are no occurrences of a field named ip.addr with the value 1.2.3.4″.

Howto Install BGInfo

Tor — Tue, 24 Apr 2012 19:01:33 +0000

1). Create c:\BGInfo\
2). Download exe, run exe, create your configuration, save bgi file as C:\BGInfo\bginfo.bgi
3). Click Start, Programs, right-click “Start Up” and choose “Explore all users”
4). Create a shortcut from BGInfo.exe into the startup directory
5). Right click the shortcut and choose properties, set the target to:
c:\BGInfo\BGInfo.exe c:\BGInfo\bginfo.bgi /timer:0
6). Run the shortcut and accept the license agreement

Taken From:
http://technet.microsoft.com/en-us/sysinternals/bb897557

Direct Link:
http://download.sysinternals.com/files/BGInfo.zip

Reset maintenance dashboard light 2008 VW GTI

Tor — Tue, 24 Apr 2012 16:15:12 +0000

1. Keys out of ignition- press and hold in trip odometer reset button “0.0″ on right hand side of display
2. Still holding this button down, insert key into ignition and put to the on position without starting the car.
3. Display will read “service now”

4. let go of the “0.0″ button and depress the “m” button on the left hand side of the display. this will re-set the service reminder. There is no confirmation on the display other than the words “service now” will disappear.

You can confirm that the service reminder has been reset, or check how many miles/days remain until service at any time by taking key out of the ignition and holding in the trip reset “0.0″ button for between 3 and 5 seconds. The MFD will display miles and hours until next service.

Note: Taken from Vortex

http://forums.vwvortex.com/showthread.php?2457779-reset-service-indicator

Rebuild INVALID Oracle Objects

Tor — Mon, 23 Apr 2012 17:18:47 +0000

1
2
3
4
5
6
7
8
9
10
11

SELECT
( case
when object_type = 'VIEW' THEN 'ALTER VIEW ' || object_name || ' COMPILE;'
when object_type = 'PROCEDURE' THEN 'ALTER PROCEDURE ' || object_name || ' COMPILE;'
when object_type = 'FUNCTION' THEN 'ALTER FUNCTION ' || object_name || ' COMPILE;'
when object_type = 'PACKAGE' THEN 'ALTER PACKAGE ' || object_name || ' COMPILE; ALTER PACKAGE ' || object_name || ' COMPILE BODY;'
when object_type = 'TRIGGER' THEN 'ALTER TRIGGER ' || object_name || ' COMPILE;'
else '' END) as script_item
FROM dba_objects
WHERE status = 'INVALID' and owner='AIMSUSER'
ORDER BY owner, object_type, object_name;

.Net special characters within strings cause Oracle problems

Tor — Wed, 18 Apr 2012 20:24:44 +0000

Without the string replaces, running this string against an Oracle database will result in the procedure getting created, but with a compile error.

1
2
3
4
5
6
7
8
9
10
11
12
13
14

string s = @"
create or replace procedure MYTEST (
myNumber IN Varchar2,
myString OUT Varchar2 ) AS

BEGIN
myString := 'hello world';
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('ERROR>> ' || SQLERRM);
END MYTEST ;
";
s = s.Replace(System.Environment.NewLine, "\r");
s = s.Replace("\t", " ");