Window-7 Commands

1. Start Run
Win+R, then type cmd, then press enter	Start Command Prompt. Starts Traditional Run Window then Command Prompt, or any other run command
Win, then type cmd, then pressCtrl+Shift+Enter	Start Command Prompt as Administrator. Start New Windows Search, then Command Prompt, or any other application

▲ up

2. Control Panel Program Shortcuts
control	Control Panel
control desktop	Display Properties (Personalization)
control color	Personalization - Color and Appearance
control folders	Folders Properties
control keyboard	Keyboard Properties
control mouse	Mouse Properties
control netconnections	Network Properties
control printers	Printers Folders
control userpasswords	Manager current User Account
control userpasswords2	Manager all User Accounts
control update	Windows Update
control admintools	Administrative Tools
control schedtasks	Scheduled Tasks
appwiz.cpl	Application Wizard (Program and Features)
powercfg.cpl	Power Configuration
timedate.cpl	Date and Time Properties
desk.cpl	Display - Screen Resolution
intl.cpl	Regional Settings (International)
mmsys.cpl	Sound Properties (Multimedia System Settings)
inetcpl.cpl	Internet Properties (Internet Control Panel)
wscui.cpl	Security Center (Windows Security Center UI)
sysdm.cpl	System Properties
utilman	Ease of Access Utility Manager
firewall.cpl	Windows Firewall

▲ up

3. Commonly used Windows Tools
explorer	Windows Explorer
c:	Explorer C: Drive
regedit	Registry Editor
services.msc	Windows Services (local)
taskmgr	Task Manager
msconfig	System Configuration Utility
mstsc	Remote Desktop (Microsoft Terminal Services)
logoff	Log Off Windows (without confirmation!)
shutdown	Shuts Down Windows (don't try unless you are ready to shutdown)
calc	Calculator
cmd	Command Prompt
notepad	Notepad

▲ up

4. Microsoft System Configurations
Microsoft System Configurations
devmgmt.msc	Device Management
eventvwr.msc	Event Viewer
compmgmt.msc	Computer Management including System Tools, Storage, Services and Appliations
diskmgmt.msc	Disk Partition Manager
dcomcnfg	Component Services (Detailed Component Configuration)
gpedit.msc	Group Policy Editor
secpol.msc	Local Security Policy Settings
lusrmgr.msc	Local User and Groups
perfmon.msc	Performance Monitor
fsmgmt.msc	Shared Folders (File Sharing Management)

▲ up

5. Other Windows Tools
shrpubw	Create a shared folder Wizard
dxdiag	Direct X Troubleshooter
cleanmgr	Clean Manager - Disk Cleanup Utility
clipbrd	Clipboard Viewer
msiexec	Windows Installer Details
magnify	Windows Magnifier
osk	On Screen Keyboard
msinfo32	System Information
sndvol	Volume Control
winver	Windows Version ( shows your windows version )
comp	Compare Files
ftp	MS-Dos FTP
label	Volume Serial Number for C:
fsquirt	Bluetooth Transfer Wizard
verifier	Driver Verifier Utility
migwiz	Migration Wizard - Files and Settings Transfer Tool
sigverif	File Signature Verification Tool
fonts	Fonts
joy.cpl	Game Controllers
mrt	Malicious Software Removal Tool
eudcedit	Private Characters Editor

▲ up

6. Applications (if installed)
acrobat	Adobe Acrobat ( if installed )
photoshop	Adobe Photoshop ( if installed )
ccleaner	Ccleaner ( if installed )
chrome	Chrome ( if installed )
excel	Microsoft Excel ( if installed )
access	Microsoft Access ( if installed )
powerpnt	Microsoft Powerpoint
winword	Microsoft Word ( if installed )
wmplayer	Windows Media Player
write	Wordpad
mspaint	Paint

▲ up

7. IP Config Commands (leave Dos Windows open)
ipconfig /all	IP Configuration (Display Connection Configuration)
ipconfig /displaydns	IP Configuration (Display DNS Cache Contents)
ipconfig /flushdns	IP Configuration (Delete DNS Cache Contents)
ipconfig /release	IP Configuration (Release All Connections)
ipconfig /renew	IP Configuration (Renew All Connections)
ipconfig /registerdns	IP Configuration (Refreshes DHCP & Re-Registers DNS)
ipconfig /showclassid	IP Configuration (Display DHCP Class ID)
ipconfig /setclassid	IP Configuration (Modifies DHCP Class ID)

▲ up

8. System File Checker Utility
sfc /scannow	System File Checker Utility ( Scan Immediately )
sfc /scanonce	System File Checker Utility ( Scan Once At Next Boot )
sfc /scanboot	System File Checker Utility ( Scan On Every Boot )
sfc /revert	System File Checker Utility ( Return to Default Settings)
sfc /purgecache	System File Checker Utility ( Purge File Cache )
sfc /cachesize=x	System File Checker Utility ( Set Cache Size to Size x )

Practise-- Oracle

CREATE OR REPLACE PROCEDURE raise_emp_salary (column_value NUMBER,
emp_column VARCHAR2, amount NUMBER) IS
v_column VARCHAR2(30);
sql_stmt VARCHAR2(200);
BEGIN
-- determine if a valid column name has been given as input
SELECT COLUMN_NAME INTO v_column FROM USER_TAB_COLS
WHERE TABLE_NAME = 'EMPLOYEES' AND COLUMN_NAME = emp_column;
sql_stmt := 'UPDATE employees SET salary = salary + :1 WHERE '
|| v_column || ' = :2';
EXECUTE IMMEDIATE sql_stmt USING amount, column_value;
IF SQL%ROWCOUNT > 0 THEN
DBMS_OUTPUT.PUT_LINE('Salaries have been updated for: ' || emp_column
|| ' = ' || column_value);
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE ('Invalid Column: ' || emp_column);
END raise_emp_salary;
/

=====================================================================================
DECLARE
plsql_block VARCHAR2(500);
BEGIN
-- note the semi-colons (;) inside the quotes '...'
plsql_block := 'BEGIN raise_emp_salary(:cvalue, :cname, :amt); END;';
EXECUTE IMMEDIATE plsql_block USING 110, 'DEPARTMENT_ID', 10;
EXECUTE IMMEDIATE 'BEGIN raise_emp_salary(:cvalue, :cname, :amt); END;'
USING 112, 'EMPLOYEE_ID', 10;
END;
/

================================================================================

DECLARE
sql_stmt VARCHAR2(200);
v_column VARCHAR2(30) := 'DEPARTMENT_ID';
dept_id NUMBER(4) := 46;
dept_name VARCHAR2(30) := 'Special Projects';
mgr_id NUMBER(6) := 200;
loc_id NUMBER(4) := 1700;
BEGIN
-- note that there is no semi-colon (;) inside the quotes '...'
EXECUTE IMMEDIATE 'CREATE TABLE bonus (id NUMBER, amt NUMBER)';
sql_stmt := 'INSERT INTO departments VALUES (:1, :2, :3, :4)';
EXECUTE IMMEDIATE sql_stmt USING dept_id, dept_name, mgr_id, loc_id;
EXECUTE IMMEDIATE 'DELETE FROM departments WHERE ' || v_column || ' = :num'
USING dept_id;
EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE TRUE';
EXECUTE IMMEDIATE 'DROP TABLE bonus';
END;
/
================================================================
select dbms_metadata.get_ddl('PACKAGE_BODY','PACKAGE_NAME') from dual;

select dbms_metadata.get_ddl('PACKAGE_SPEC','PACKAGE_NAME') from dual;

=================================================================

Database Commands

Database Useful Commands
---------------------------
Listner Commands
-------------------
lsnrctl start
lsnrctl stop
lsnrctl status
lsnrctl service
Tnsping
-------------------
ping localhost
tnsping localhost
tnsping orcl
Tablespaces
---------------
select * from USER_TABLESPACES;
select * from V$TEMPFILE;
SELECT * FROM DBA_DATA_FILES;
SELECT * FROM v$datafile;
SELECT * FROM v$log;--REDO LOGS
SELECT * FROM v$archived_log;--ARCHIVE LOGS

 How to determine the database character set in oracle?
----------------------------------------------------------
select * from NLS_DATABASE_PARAMETERS
    where parameter='NLS_CHARACTERSET'; --AL32UTF8
   
SELECT value$ FROM sys.props$ WHERE name='NLS_CHARACTERSET';  --AL32UTF8 

select distinct(nls_charset_name(charsetid)) CHARACTERSET,
decode(type#, 1, decode(charsetform, 1, 'VARCHAR2', 2, 'NVARCHAR2','UNKNOWN'),
9, decode(charsetform, 1, 'VARCHAR', 2, 'NCHAR VARYING', 'UNKNOWN'),
96, decode(charsetform, 1, 'CHAR', 2, 'NCHAR', 'UNKNOWN'),
8, decode(charsetform, 1, 'LONG', 'UNKNOWN'),
112, decode(charsetform, 1, 'CLOB', 2, 'NCLOB', 'UNKNOWN')) TYPES_USED_IN
from sys.col$ where charsetform in (1,2) and type# in (1, 8, 9, 96, 112)
order by CHARACTERSET, TYPES_USED_IN;
Explian Plan
--------------
explain plan for select Statements;
select PLAN_TABLE_OUTPUT
    from table(dbms_xplan.display('plan_table',null,'basic'));

select * from V$SQL;
select * from V$SQL_PLAN;
select * from V$SQL_PLAN_STATISTICS_ALL;

Govt. Sites

web sites of andhrapradesh government
Andhra Pradesh Government :- www.andhrapradesh.com
AndhraPradesh Portal :- www.aponline.gov.in
A.P.Dept. of Womens Dev.& Child Welfare :- www.apanganwadi.com
A.P.Commercial Tax :- www.apvatvision.com/Andhra
A.P.B.C.Co-op.Finance Corporation :- www.backwardclasscorporation.org
Anti-Corruption Bureau :- www.acbap.org
A.P.Dev.Co-op. Federation :- www.apdairy.com
A.P.Elect. Regulatory Authority :- www.ercap.org
A.P.Forests Dev. Corporation :- http://apfdc.apts.gov.in
A.P.Genco :- www.apgenco.com
A.P.Transco :- www.aptranscorp.com
A.P. Govt. Orders :- www.apts.gov.in
A.P. Housing Board :- http://aphb.apts.gov.in
A.P. Indus. Dev.Corp. :- www.apind.com
A.P. I.T.C.O. :- www.apitco.org
A.P.Mines & Geology :- www.minces.com
A.P.Police :- www.apstatepolice.org
A.P.Pollution Control Board :- www.apspcb.org
A.P.Press Academy :- www.apts.gov.in
A.P.Public Ditribution System :- www.nic.in/appds
A.P.Public Service Commission :- www.appsc.org
A.P.S.C.Of Higher Education :- www.apsche.com
A.P.S.Co-op. Marketing Federation :- www.apscmf.gov.in
A.P.State Financial Corporation :- www.apsic.com
A.P.State Housing Corporation :- www.apshcil.com
A.P. State Minority Financial Corporation :- www.apsmic.com
A.P.State Trading Corporation :- www.apstc.com
A.P.Tranport Corp. :- www.andhrapradesh.com
A.P.Tech. Dev.Promotion Centre :- www.aptdc.com
A.P. Technology Services Ltd. :- www.apts.gov.in
A.P.Telephones :- www.aptelcom.gov.in
A.P.Tourism :- www.aptourism.com
A.P.Infrastucture :- www.aponline.gov.in
A.P.Vidya Vidhana Parishad :- www.aphealth.org
Board Of Intermediate Education :- www.interboardap.nic.in
CARD- Dept. of Registration & Stamp :- www.ap.gov.in/card
Civil Suplies Corporation :- www.apts.gov.in/ramwec
Chief Minister's Empowerment of Youth :- www.cmey.com
Commisionerate of Industries :- www.apind.com
Commisionerate of Family Welfare :- www.apsect.gov.in
Commisionerate of Fisheries :- www.apfishries.com
Directorate of AIDS Control Project :- www.unaids.org
Directorate of Horticulture :- www.aphorticulture.com
Directorate of School Education :- www.schoolsinap.com
Directorate of State Institute of Edu.Tech :- www.siethyd.nic.in
Directorate of Tribal Cultural Research
& Training Institute :- www.apts.gov.in/aptribes
Directorate of Women Dev. &Child Welfare :- www.ap.nic.in
Direct Primary Education Programme :- www.apdped2000.com
Dr.B.R.Ambedkar Open University :- www.rbraou.com
Dr.MCR HRD Institute Of AP :- www.hrdap.gov.in
DWACRA :- www.ap.nic.in
Envir Protection,Training & Research :- www.eptri.com
Forest Department :- www.ap.nic.in
Girijan Co-op Corporation Lts :- www.apts.gov.in/aptribes
Hyderbad Muncipal Coporation :- www.ourmch.com
Guntur Muncipal Coporation :- www.gunturmuncipality.com
Tirupathi Urban Dev.Authority :- www.tuda.org
Tirupathi Zoo :- www.tirupathi.zoo.org
Vijayawada Muncipal Coporation :- www.vijayawada.com
Visakapatnam Muncipal Coporation :- www.visakapatnammuncipalcoporation.com
Hi Tech City :- www.tinlocity.com
Software Tech. Park of India :- www.stph.net
Hyderbad Metro Water Supply &
Sewerage Board :- www.hyderabadwater.gov.in
Hyderbad Traffic Police :- www.hyderbadtrafficpolice.com
Hyderbad Urban Dev.Authority :- www.hudahyd.com
IAS Officers Address :- www.apts.gov.in/address
Information Tech. & Commuin. Dept :- www.ap-it.com
Irrigaton Department :- www.apgov.in/apirrigation
JNTU :- www.jntu.ac.in
University of Hyderabad :- www.uohyd.emet.in
Panchayath Raj Engineering :- www.ap.in.in/nws
Roads & Buildings Department :- www.aproads.com
Transport Department :- www.tats.gov.in/transport
Small Savings :- www.apts.gov.in/apsmallsavings
Social Welfare Department :- http://swd.apts.gov.in
Social Welfare Residential Schools :- www.apts.gov.in/apswrs
State Board of Technical Edu.& Training :- www.sbtet.ap.nic.in
Velugu :- www.velugu.org
Corporation.com :- www.sowkarmyuam.com