Displaying keyword search results 1 - 10
Created by Dr. Xi on November 21, 2009 02:07:07 Last update: September 10, 2013 18:51:14
This is from Oracle 10g documentation . Data Lock Conversion Versus Lock Escalation A transaction holds exclusive row locks for all rows inserted, updated, or deleted within the transaction. Because row locks are acquired at the highest degree of restrictiveness, no lock conversion is required or performed. Oracle automatically converts a table lock of lower restrictiveness to one of higher restrictiveness as appropriate. For example, assume that a transaction uses a SELECT statement with the FOR UPDATE clause to lock rows of a table. As a result, it acquires the exclusive row locks and a row share table lock for the table. If the transaction later updates one or more of the locked rows, the row share table lock is automatically converted to a row...
Created by Dr. Xi on September 06, 2007 03:11:40 Last update: January 31, 2013 12:13:45
The built-in function SYSDATE returns a DATE value containing the current date and time on your system. For example,
UPDATE ACCOUNT SET LAST_MODIFIED = SYSDATE;updates the LAST_MODIFIED column to the current system time.
select to_char(sysdate, 'MM-DD-YYYY HH24:MI:SS') N...prints the current date & time.
Created by Dr. Xi on February 06, 2012 12:14:11 Last update: February 07, 2012 15:39:35
Oracle sqlplus command line tools does not support command line editing out-of-the-box. But on Linux there's a handy utility that enables command line editing with any command line tool: rlwrap - readline wrapper. Install rlwrap:
$ sudo apt-get install rlwrapCreate a keywords file .sql.dict (optional, but convenient):
false null true access add as asc begin by chec...It would be nice to add the tables names also. Create an alias for sqlplus (put it in .bashrc ):
alias sqlplus='rlwrap -f $HOME/.sql.dict sqlplus'
Created by voodoo on July 14, 2010 23:37:46 Last update: November 16, 2011 12:00:33
Run gpedit.msc Find Administrative Templates -> Windows Components -> Terminal Services -> Limit Maximum color depth. Right click on "Limit maximum color depth", click "Properties", then select "Client Compatible". Update: for Windows 7 the color depth policy was moved to Administrative Templates -> Windows Components -> Remote Desktop Services -> Remote Desktop Session Host -> Remote Session Environment
Created by freyo on August 03, 2011 13:27:22 Last update: August 04, 2011 08:40:50
If your app is not available from Android Market but is downloaded to a PC, you can copy the APK to an SD card and install it following these steps. Copy the Android app APK file to the SD card. Enable "Unknown sources" on the phone: Menu -> Settings -> Applications -> check "Unknown sources". Open the browser ("Internet"), then enter the URL to the APK file like this:
file:///mnt/sdcard/external_sd/theApp.apkSelect "Package installer" in the popup. The drawback of this method is that you have to know the exact path to the APK file, which may or may not be a problem. Other methods require third party utilities: Use AppsInstaller or ApkInstaller Use ASTRO File Manager or Dropbox Update: On my Samsung Galaxy S, there's...
Created by jinx on May 03, 2011 12:11:35 Last update: May 03, 2011 12:12:27
The PHP function is_resource returns TRUE if a variable is a resource. This may come in handy when a function you are calling returns mixed type. For example mysql_query returns TRUE or FALSE for INSERT , UPDATE , DELETE etc., but returns resource or FALSE for SELECT , SHOW , or DESCRIBE .
<?php $rows = array(); if ($res = mysql_quer...
Created by voodoo on November 25, 2010 00:15:37 Last update: November 25, 2010 00:15:37
PostgreSQL JDBC doc says: Specifically deleting a row that contains a Large Object reference does not delete the Large Object. Deleting the Large Object is a separate operation that needs to be performed. . In JDBC this can be done in two steps: Delete the large object (call PostgreSQL function lo_unlink )
long oid = jdbcTemplate.queryForObject("select...Delete the row in the referring table:
jdbcTemplate.update("delete from InventoryItem whe...
Created by voodoo on November 25, 2010 00:03:53 Last update: November 25, 2010 00:03:53
It seems that the JDBC standard way to create a BLOB is to call Connection.createBlob . However, this does not work for PostgreSQL (as of version 9.0-801 jdbc4):
Exception in thread "main" org.postgresql.util.PSQ...The workaround is to call a PostgreSQL function to create the Blob, then use JDBC to update it:
Connection conn = jdbcTemplate.getDataSource().get...Oracle Note: the Oracle way function to create an empty BLOB is EMPTY_BLOB() .
stmt.execute ("INSERT INTO my_blob_table VALUES ('...
Created by voodoo on September 21, 2010 03:51:14 Last update: September 21, 2010 03:51:14
Update: I followed the advice from CamStudio Support Forum and selected Stereo Mix . That fixed the no-audio problem! Double click Speaker icon in System Tray > Options > Properties > Adjust Volume For Recording > Select Stereo Mix, Mono Mix, What-U-Hear, etc.
Created by voodoo on September 21, 2010 03:12:52 Last update: September 21, 2010 03:13:58
Select "Capture AVI..." from File menu Set capture file Change size of captured frame Update screen capture settings Start capture Note: I wasn't able to capture sound from speaker!