Recent content by Beilstwh

why not use DBMS_LOB.COMPARE function or the dbms_crypto_toolkit.Hash Bill Lead Application Developer New York State, USA

What tek-tips really needs to do is add the ability to close or finalize a thread. I belong to other forums that do that and no new content is allowed on the thread. Bill Lead Application Developer New York State, USA

I am so sorry, I copied the user name from the comment previous to mariah1902, which was yours. I will edit my comment. Again I apologize Bill Lead Application Developer New York State, USA

Laser? a laptop doesn't use an optical drive as it's main storage. Ignore everything that mariah1902 said Bill Lead Application Developer New York State, USA

a couple of things. Load and use ccleaner on your machine. It will fix a lot of problems. Make sure you only get it from the following link. There are hacked versions out there. The free version works just fine. https://www.ccleaner.com/ccleaner/download And the second thing is that 4 gig for...

Yor results do not match your select. You said "I select the field "DTTM_STAMP" and look at "View SQL", it has "TO_CHAR(CAST((DTTM_STAMP) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF')" (result example: 04/10/2019 3:16:59PM)." a format mask of 'YYYY-MM-DD-HH24.MI.SS.FF' can't produce a result of...

What are the 12 actions? What order should they be in. The query isn't difficult but undo-able without those 2 pieces of information Bill Lead Application Developer New York State, USA

Here is a complete write up on the IP port 445 https://www.speedguide.net/port.php?port=445 Bill Lead Application Developer New York State, USA

windows cleans up old dns entries every now and then. To do it immediately simply run the following command in a command windows ipconfig /flushdns Bill Lead Application Developer New York State, USA

I would just purchase an HDMI switch. Amazon sells a 4 port one for way under $100.00. You just press a button to switch between devices Bill Lead Application Developer New York State, USA

There is another path. Upgrade to a version that windows supports. See the following link and according to the site, the software is free https://www.cardbox.com/ Bill Lead Application Developer New York State, USA

They are not saying that other processors or configurations will not work, they are saying that they have a list of processors and configurations that they have tested and certify that they will work. Try upgrading and it will almost always work. If it doesn't you not any worse off. You can...

Windows 10 has a built in tool for removing unneeded files. look at the following link https://support.microsoft.com/en-us/help/4026616/windows-10-disk-cleanup Bill Lead Application Developer New York State, USA

At a minimum use bitlocker on the drives. If the user doesn't login with a valid username password the drive is unreadable Bill Lead Application Developer New York State, USA

"the serial number is max + 1 at time of insert." Do you mean something like: INSERT INTO SomeTable (SerialNo, ...) VALUES ((Select MAX(SerialNo) + 1 From SomeTable), ... "in case where 2 users are submitting at same time , get the same serial no" Not if you COMMIT your transaction after every...