A2Z on Tech
Knowledge is that area of ignorance that we arrange and classify. --Ambrose Bierce
Friday, August 4, 2017
Monday, June 9, 2014
Microsoft Word : Assigning a KEYBOARD shortcut for deleting one line of text
Macro-based shortcut
- 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
- 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
Thursday, May 16, 2013
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:
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
- 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
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
Subscribe to:
Posts (Atom)