Using Oracle SQL Developer as MySQL IDE

Need to follow below steps:

- Download desired MySQL connector, unzip and place to desired directory.

- From SQLDeveloper -> Tools -> Preferences -> Databases -> Third party JDBC driver.

  "Add Entry" for desired MySQL connector.

That's It!!!

Now you can observe MySQL tab in the DB Connections SQLDeveloper window.

References:

http://www.techrepublic.com/blog/programming-and-development/configuring-sql-developer-for-mysql/564

Cheers!

Eclipse Performance Enhancement!

Hi,

Most of the time we suffer from Eclipse responsiveness or performance.

Below is the link for changing Eclipse Memory settings in "eclipse.ini" file:

https://gist.github.com/justingarrick/2588828

Notepad++ : Another good tool discovered for developers

This is very handy tool having rich file types support and syntax highlighting.

I found it quite handy if you are dealing with any Character Encoding related issues or 

Need to verify or view various characters like TAB, Carriage Return(CR), Line Feed(LF) or New Line Characters.

It also supports very reach support for Character Encoding.

Listed below the features from its official website:

• Syntax Highlighting and Syntax Folding
• User Defined Syntax Highlighting and Folding: screenshot 1, screenshot 2, screenshot 3 and screenshot 4
• PCRE (Perl Compatible Regular Expression) Search/Replace
• GUI entirely customizable: minimalist, tab with close button, multi-line tab, vertical tab and vertical document list
• Document Map
• Auto-completion: Word completion, Function completion and  Function parameters hint
• Multi-Document (Tab interface)
• Multi-View
• WYSIWYG (Printing)
• Zoom in and zoom out
• Multi-Language environment supported
• Bookmark
• Macro recording and playback
• Launch with different arguments

You can DOWNLOAD this from below link:

http://notepad-plus-plus.org/download/v6.3.1.html

Using style.display instead of style.visibility

Hello,

HTML-CSS-JavaScript combination is little bit tricky to non-web developers.

There are few UIs which seems to be inconsistent as we are using JavaScript to enable/disable the HTML Components.

And it takes time to find out and align all the forms.

If you are using any JavaScript and CSS combination to hide/show any components, below information may save your time. 

To maintain proper alignment of whole HTML and its elements, please use following:

Element Property	Value
style.display	'none' (To hide element)
style.display	'' (Empty string to show element)

Please try to avoid using style.display='block' and style.visibility='hidden'/'visible'/'inline' as it is affecting the CSS applied.

---

Cheers and Enjoy Scripting!

-------------------------------------------------------------------------

Alphabet 'O' stands for Opportunity,

Which is absent in 'Yesterday', Is available once in 'Today'

And thrice in 'Tomorrow' So don't think about 'Yesterday'.

-------------------------------------------------------------------------

Differentiate : ClassNotFoundException & NoClassDefFoundError

It is important to keep two different exceptions strait in our head in this case:

1. java.lang.ClassNotFoundException This exception indicates that the class was not found on the classpath. This indicates that we were trying to load the class definition, and the class did not exist on the classpath.
   
2. java.lang.NoClassDefFoundError This exception indicates that the JVM looked in its internal class definition data structure for the definition of a class and did not find it. This is different than saying that it could not be loaded from the classpath. Usually this indicates that we previously attempted to load a class from the classpath, but it failed for some reason - now we're trying again, but we're not even going to try to load it, because we failed loading it earlier. The earlier failure could be a ClassNotFoundException or an ExceptionInInitializerError (indicating a failure in the static initialization block) or any number of other problems. The point is, a NoClassDefFoundError is not necessarily a classpath problem.

Cheers!

OUTLOOK Shortcuts

Some useful OUTLOOK shortcuts:

• Alt + . (period) Open the Address Book with the To field selected
• Alt + A Open the Action drop-down menu
• Alt + B Open the Address Book with the BCC field selected
• Alt + C Select message recipients for CC field
• Alt + D Switch to Daily calendar view
• Alt + E Open the Edit drop-down menu
• Alt + F Open the File drop-down menu
• Alt + G Open the Go drop-down menu
• Alt + H Open the Help drop-down menu
• Alt + I Open the Find tool bar / Open the Insert drop-down menu
• Alt + J Move to the Subject field
• Alt + K Check names in the To, CC, or BCC field against the Address Book (cursor must be in the corresponding message header field)
• Alt + L Reply All
• Alt + M Switch to Monthly calendar view
• Alt + N Open the Accounts drop-down menu
• Alt + O Open the Format drop-down menu / Switch to Today calendar view
• Alt + P Open the Message Options dialog box
• Alt + R Reply / Switch to Work Week Calendar view
• Alt + S Send
• Alt + T Open the Tools drop-down menu
• Alt + V Open the View drop-down menu
• Alt + W Forward an item / Switch to Weekly calendar view
• Alt + Y Switch to Daily calendar view
• Ctrl + 1 Go to Mail
• Ctrl + 2 Go to Calendar
• Ctrl + 3 Go to Contacts
• Ctrl + 4 Go to Tasks
• Ctrl + 5 Go to Notes
• Ctrl + 6 Go to Folder List
• Ctrl + 7 Go to Shortcuts
• Ctrl + 8 Go to Journal
• Ctrl + A Select all
• Ctrl + B Bold when editing a rich text message
• Ctrl + C Copy
• Ctrl + D Delete an item (message, task, contact, etc.)
• Ctrl + E Activate the Find drop-down menu / Center Align when editing a rich text message
• Ctrl + F Forward
• Ctrl + J Open a new Journal Entry from the selected item (message, task, contact, etc.)
• Ctrl + K Check names in the To, CC, or BCC field against the Address Book (cursor must be in the corresponding message header field)
• Ctrl + M Send/Receive all
• Ctrl + O Open
• Ctrl + P Print
• Ctrl + Q Mark the selected message Read
• Ctrl + R Reply
• Ctrl + S Save a draft message
• Ctrl + T Tab
• Ctrl + U Mark the selected message Unread
• Ctrl + V Paste
• Ctrl + X Cut
• Ctrl + Y Go to Folder
• Ctrl + Z Undo
• Ctrl + Backspace Delete the previous word
• Ctrl + End Move to the end
• Ctrl + Home Move to the beginning
• Ctrl + Shift + A Open a new Appointment
• Ctrl + Shift + B Open the Address Book
• Ctrl + Shift + C Create a new Contact
• Ctrl + Shift + E Open a new folder
• Ctrl + Shift + F Open the Advanced Find window
• Ctrl + Shift + G Flag message for follow up
• Ctrl + Shift + J Open a new Journal Entry
• Ctrl + Shift + K Open a new Task
• Ctrl + Shift + L Open a new Distribution List
• Ctrl + Shift + M Open a new Message
• Ctrl + Shift + N Open a new Note
• Ctrl + Shift + O Switch to the Outbox
• Ctrl + Shift + P Open the New Search Folder window
• Ctrl + Shift + Q Open a new Meeting Request
• Ctrl + Shift + R Reply All
• Ctrl + Shift + S Open a new Discussion
• Ctrl + Shift + U Open a new Task Request
• Ctrl + Shift + Y Copy a Folder
• Shift + Tab Select the previous message header button or field
• F1 Open Outlook Help
• F3 Activate the Find toolbar
• F4 Open the Find window
• F7 Spellcheck
• F9 Send and receive all
• F10 Select File from the Outlook toolbar button
• F11 Activate the "Find a contact" dialog box
• F12 Save As
• Alt + F4 Close the active window

Dropping all DB tables, views, indexes, sequences in one query.

Most of the time one faces the issues like one need to delete all the tables, views, indexes or sequences in the database.
So following the query which generates DROP statements for all the components present in the Oracle database:

SELECT 'DROP TABLE ' || table_name || ';' AS statement FROM user_tables
Union
SELECT 'DROP VIEW ' || view_name || ';' AS statement from user_views
Union
SELECT 'DROP INDEX ' || index_name || ';' AS statement from user_indexes
Union
SELECT 'DROP SEQUENCE ' || sequence_name || ';' AS statement from user_sequences
Union
SELECT 'DROP SYNONYM ' || SYNONYM_name || ';' AS statement from user_SYNONYMs;

Cheers :)