Search results for query: *

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...

Look into the Logitech K750 keyboard. It has NO replaceable batteries, it uses solar cells on the keyboard and need to be exposed to 1 hour of light (sun light or office lights) per week to be fully charged. I have used it for over a year and it works great Bill Lead Application Developer New...

I would use the datapump utility expdp to export all the tables with their structure, data, indexes, and constraints. Then use the impdp to load it into the new database. Bill Lead Application Developer New York State, USA

If you have an old dos application, look up the free software for windows 10 called dosbox The link is below. It will run dos applications on a windows 10 system by running the application under a dos emulator. inside a window. I have used it in the past and it works very will...

SELECT Nbr, CASE WHEN Mon = 'Y' THEN 1 ELSE 0 END + CASE WHEN Tue = 'Y' THEN 1 ELSE 0 END + CASE WHEN Wed = 'Y' THEN 1 ELSE 0 END + CASE WHEN Thurs = 'Y' THEN 1 ELSE 0 END + CASE WHEN Fri = 'Y' THEN 1 ELSE 0 END + CASE WHEN Sat = 'Y' THEN 1...

WITH Mytable AS (SELECT Shrtckn_pidm, Shrtckg_grde_code_final AS Grde_code_final FROM Shrtckn, Shrtckg WHERE Shrtckn_pidm = Shrtckg_pidm AND Shrtckg_term_code = Shrtckn_term_code AND Shrtckn_seq_no = Shrtckg_tckn_seq_no...