Friday, August 4, 2017

Enable Git toolbar in eclipse

1. Select "Customize Perspective" from Windows->Perspective

2. Select "Action Set Availability" tab from the window and select the check box for Git, the Git toolbar will be visible.


Monday, June 9, 2014

Microsoft Word : Assigning a KEYBOARD shortcut for deleting one line of text

Macro-based shortcut

  1. Create a new Macro with the following code (Alt+F8, specify the name, click Create):
    Selection.HomeKey Unit:=wdLine 
    Selection.EndKey Unit:=wdLine, Extend:=wdExtend 
    Selection.Delete Unit:=wdCharacter, Count:=1
    
  2. Assign a keyboard shortcut to it:
    • File > Option > Customize Ribbon
    • Click on Keyboard shortcuts: Customize (bottom left)
    • Scroll down the Categories list and select Macros, choose your new macro
    • Press the shortcut key combination (e.g. Ctrl+D)
    • Click Assign
    • Close > OK

Saturday, September 29, 2012

Reset the Oracle SYSTEM password

Scenario: Forgot the SYSTEM password for the ORACLE database installed in your computer.

Solution: You can reset it by logging in to Windows as Administrator and connecting to Oracle as sysdba.


Steps:

  • Log in to the Windows Server that is running Oracle as Administrator.
  • Start SQL*Plus

  • At the login prompt, in the user-name field, type ”/as sysdba”, and press enter

  • You are now connected as system with full DBA rights.

  • Reset the password of the SYSTEM  with below query
alter user system identified by NewPassword;
  • enter
“User altered.”
 
Now you can login with your new password.

Tuesday, June 26, 2012

Find Table by providing the Field or Column Name

You can use below statement to look into those objects to which you have access

select * from user_tab_columns where column_name=''

else to check in those objects to which you dont have access as well, you can use the below queries

select * from all_tab_columns

select * from dba_tab_columns