Sunday 2 June 2013
Sunday 21 April 2013
Meanings of these words
News = North East West South.
Chess = Chariot,Horse, Elephant, Soldiers.
Cold = chronic Obstructive Lung Disease.
Joke = Joy of Kids Entertainment.
Aim = Ambition in Mind.
Date = Day and Time Evolution.
Eat = Energy And Taste.
Tea = Taste And Energy Admitted.
Pen = Power Enriched in Nib.
Smile = Sweet Memories In Lips Expression.
Bye = Be with You Everytime.
SYMBOLS WITH KEYBOARD
Alt + 0153..... ™... trademark symbol
Alt + 0169.... ©.... copyright symbol
Alt + 0174..... ®....registered trademark symbol
Alt + 0176 ...°......degre e symbol
Alt + 0177 ...±....plus-or -minus sign
Alt + 0182 ...¶.....paragr aph mark
Alt + 0190 ...¾....fractio n, three-fourths
Alt + 0215 ....×.....multi plication sign
Alt + 0162...¢....the cent sign
Alt + 0161.....¡..... .upside down exclamation point
Alt + 0191.....¿..... upside down question mark
Alt + 1.......☺....sm iley face
Alt + 2 ......☻.....bla ck smiley face
Alt + 15.....☼.....su n
Alt + 12......♀.....f emale sign
Alt + 11.....♂......m ale sign
Alt + 6.......♠.....s pade
Alt + 5.......♣...... Club
Alt + 3.......♥...... Heart
Alt + 4.......♦...... Diamond
Alt + 13......♪.....e ighth note
Alt + 14......♫...... beamed eighth note
Alt + 8721.... ∑.... N-ary summation (auto sum)
Alt + 251.....√.....s quare root check mark
Alt + 8236.....∞..... infinity
Alt + 24.......↑..... up arrow
Alt + 25......↓...... down arrow
Alt + 26.....→.....ri ght arrow
Alt + 27......←.....l eft arrow
Alt + 18.....↕......u p/down arrow
Alt + 29......↔...lef t right arrow
Keyboard Shorcuts (Microsoft Windows)
Keyboard Shorcuts (Microsoft Windows)
1. CTRL+C (Copy)
2. CTRL+X (Cut)
3. CTRL+V (Paste)
4. CTRL+Z (Undo)
5. DELETE (Delete)
6. SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)
7. CTRL while dragging an item (Copy the selected item)
8. CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
9. F2 key (Rename the selected item)
10. CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)
11. CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
12. CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
13. CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
14. CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)
15. CTRL+A (Select all)
16. F3 key (Search for a file or a folder)
17. ALT+ENTER (View the properties for the selected item)
18. ALT+F4 (Close the active item, or quit the active program)
19. ALT+ENTER (Display the properties of the selected object)
20. ALT+SPACEBAR (Open the shortcut menu for the active window)
21. CTRL+F4 (Close the active document in programs that enable you to have multiple documents opensimultaneou sly)
22. ALT+TAB (Switch between the open items)
23. ALT+ESC (Cycle through items in the order that they had been opened)
24. F6 key (Cycle through the screen elements in a window or on the desktop)
25. F4 key (Display the Address bar list in My Computer or Windows Explorer)
26. SHIFT+F10 (Display the shortcut menu for the selected item)
27. ALT+SPACEBAR (Display the System menu for the active window)
28. CTRL+ESC (Display the Start menu)
29. ALT+Underlined letter in a menu name (Display the corresponding menu) Underlined letter in a command name on an open menu (Perform the corresponding command)
30. F10 key (Activate the menu bar in the active program)
31. RIGHT ARROW (Open the next menu to the right, or open a submenu)
32. LEFT ARROW (Open the next menu to the left, or close a submenu)
33. F5 key (Update the active window)
34. BACKSPACE (View the folder onelevel up in My Computer or Windows Explorer)
35. ESC (Cancel the current task)
36. SHIFT when you insert a CD-ROMinto the CD-ROM drive (Prevent the CD-ROM from automatically playing)
Dialog Box - Keyboard Shortcuts
1. CTRL+TAB (Move forward through the tabs)
2. CTRL+SHIFT+TAB (Move backward through the tabs)
3. TAB (Move forward through the options)
4. SHIFT+TAB (Move backward through the options)
5. ALT+Underlined letter (Perform the corresponding command or select the corresponding option)
6. ENTER (Perform the command for the active option or button)
7. SPACEBAR (Select or clear the check box if the active option is a check box)
8. Arrow keys (Select a button if the active option is a group of option buttons)
9. F1 key (Display Help)
10. F4 key (Display the items in the active list)
11. BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open dialog box)
Microsoft Natural Keyboard Shortcuts
1. Windows Logo (Display or hide the Start menu)
2. Windows Logo+BREAK (Display the System Properties dialog box)
3. Windows Logo+D (Display the desktop)
4. Windows Logo+M (Minimize all of the windows)
5. Windows Logo+SHIFT+M (Restorethe minimized windows)
6. Windows Logo+E (Open My Computer)
7. Windows Logo+F (Search for a file or a folder)
8. CTRL+Windows Logo+F (Search for computers)
9. Windows Logo+F1 (Display Windows Help)
10. Windows Logo+ L (Lock the keyboard)
11. Windows Logo+R (Open the Run dialog box)
12. Windows Logo+U (Open Utility Manager)
13. Accessibility Keyboard Shortcuts
14. Right SHIFT for eight seconds (Switch FilterKeys either on or off)
15. Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)
16. Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)
17. SHIFT five times (Switch the StickyKeys either on or off)
18. NUM LOCK for five seconds (Switch the ToggleKeys either on or off)
19. Windows Logo +U (Open Utility Manager)
20. Windows Explorer Keyboard Shortcuts
21. END (Display the bottom of the active window)
22. HOME (Display the top of the active window)
23. NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder)
24. NUM LOCK+Plus sign (+) (Display the contents of the selected folder)
25. NUM LOCK+Minus sign (-) (Collapse the selected folder)
26. LEFT ARROW (Collapse the current selection if it is expanded, or select the parent folder)
27. RIGHT ARROW (Display the current selection if it is collapsed, or select the first subfolder)
Shortcut Keys for Character Map
After you double-click a character on the grid of characters, you can move through the grid by using the keyboard shortcuts:
1. RIGHT ARROW (Move to the rightor to the beginning of the next line)
2. LEFT ARROW (Move to the left orto the end of the previous line)
3. UP ARROW (Move up one row)
4. DOWN ARROW (Move down one row)
5. PAGE UP (Move up one screen at a time)
6. PAGE DOWN (Move down one screen at a time)
7. HOME (Move to the beginning of the line)
8. END (Move to the end of the line)
9. CTRL+HOME (Move to the first character)
10. CTRL+END (Move to the last character)
11. SPACEBAR (Switch between Enlarged and Normal mode when a character is selected)
Microsoft Management Console (MMC)
Main Window Keyboard Shortcuts
1. CTRL+O (Open a saved console)
2. CTRL+N (Open a new console)
3. CTRL+S (Save the open console)
4. CTRL+M (Add or remove a console item)
5. CTRL+W (Open a new window)
6. F5 key (Update the content of all console windows)
7. ALT+SPACEBAR (Display the MMC window menu)
8. ALT+F4 (Close the console)
9. ALT+A (Display the Action menu)
10. ALT+V (Display the View menu)
11. ALT+F (Display the File menu)
12. ALT+O (Display the Favorites menu)
MMC Console Window Keyboard Shortcuts
1. CTRL+P (Print the current page or active pane)
2. ALT+Minus sign (-) (Display the window menu for the active console window)
3. SHIFT+F10 (Display the Action shortcut menu for the selected item)
4. F1 key (Open the Help topic, if any, for the selected item)
5. F5 key (Update the content of all console windows)
6. CTRL+F10 (Maximize the active console window)
7. CTRL+F5 (Restore the active console window)
8. ALT+ENTER (Display the Properties dialog box, if any, for theselected item)
9. F2 key (Rename the selected item)
10. CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console)
Remote Desktop Connection Navigation
1. CTRL+ALT+END (Open the Microsoft Windows NT Security dialog box)
2. ALT+PAGE UP (Switch between programs from left to right)
3. ALT+PAGE DOWN (Switch between programs from right to left)
4. ALT+INSERT (Cycle through the programs in most recently used order)
5. ALT+HOME (Display the Start menu)
6. CTRL+ALT+BREAK (Switch the client computer between a window and a full screen)
7. ALT+DELETE (Display the Windows menu)
8. CTRL+ALT+Minus sign (-) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.)
9. CTRL+ALT+Plus sign (+) (Place asnapshot of the entire client window area on the Terminal server clipboardand provide the same functionality aspressing ALT+PRINT SCREEN on a local computer.)
Microsoft Internet Explorer Keyboard Shortcuts
1. CTRL+B (Open the Organize Favorites dialog box)
2. CTRL+E (Open the Search bar)
3. CTRL+F (Start the Find utility)
4. CTRL+H (Open the History bar)
5. CTRL+I (Open the Favorites bar)
6. CTRL+L (Open the Open dialog box)
7. CTRL+N (Start another instance of the browser with the same Web address)
8. CTRL+O (Open the Open dialog box,the same as CTRL+L)
9. CTRL+P (Open the Print dialog box)
10. CTRL+R (Update the current Web )
Tuesday 9 April 2013
Monday 8 April 2013
VIDEO LIBRARY MANAGEMENT IN SQL
SQL>create
table customer (cno int,fname varchar(10),sname varchar(10),area
varchar(10),phone int);
Table created
SQL>insert
table customer
values(‘&cno’,’&fname’,’&sname’,’&area’,’&phone’);
Enter value for cno: 1
Enter value for fname: john
Enter value for sname: peter
Enter value for area: cbe
Enter value for phone: 8548547895
1 row created
SQL>select
* from customer;
CNO
FNAME SNAME AREA PHONE
------
----------- ----------- -------- -----------
1 john peter cbe 8548547895
2 dean
winsister cbe2 1245789987
3 emma Watson cbe4
3455568765
SQL>create
table compact (cdno int,title varchar(10),price varchar(10),cname varchar(10));
Table created
SQL>insert
table compact values(‘&cdno’,’& title,’& price’,’& cname’);
Enter value for cdno: c1
Enter value for title: algorithm
Enter value for price: 200
Enter value for cname: john
1
row created
SQL>select
* from compact;
CDNO
TITLE PRICE CNAME
------
----------- ----------- --------
C1 algorithm 200 john
C2 program 400
sam
C3 hardware 1000 Watson
SQL>create
table invoice (invno int,cidno int,issuedate date,returndate date);
Table created
SQL>insert
table invoice values(‘&invno’,’&cidno’,’&issuedate’,’&returndate’);
Enter value for invno: 1
Enter value for cidno: 1
Enter value for issuedate: 28/1/10
Enter value for returndate: 28/2/10
1
row created
SQL>select
* from invoice;
INVNO CIDNO
ISSUEDATE RETURNDATE
-----------
----------- ----------------- --------------------
1 1 28/1/10 28/2/10
2 2 14/3/1/10 14/4/10
3 3 16/4/10 26/5/10
SQL>select
area from customer;
AREA
--------
cbe
cbe2
cbe4
SQL>select
max(price) as”maximum” from compact;
MAXIMUM
----------------
1000
SQL>select
min(price) as”minimum” from compact;
MINIMUM
----------------
200
SQL>select
avg(price) as”avg” from compact;
AVG
---------
533.3
SQL>select
* from compact where title like ’%algorithm%’;
CDNO
TITLE PRICE CNAME
------
----------- ----------- --------
C1 algorithm 200 john
SQL>select
datediff(day,’2010-01-28’,’2010-02-28’) as diffdatebetween from invoice;
DIFFDATEBETWEEN
------------------------------
30
SQL>delete from invoice where returndate
=’28/2/10’;
1 row deleted
SQL>select cname from compact;
CNAME
------------
john
sam
Watson
SQL>select * from customer where phone=’ 8548547895’;
CNO
FNAME SNAME AREA PHONE
------
----------- ----------- -------- -----------
1 john peter cbe
8548547895
DATE FUNCTION IN SQL
SQL>create table t (datecol1
date,datecol2 date,datecol3 date);
Table created
SQL>insert into t
values(sysdate+23,sysdate-10,sysdate-24);
SQL>select * from t ;
DATECOL1 DATECOL2
DATECOL3
---------------- ---------------- -----------------
09-mar-13 04-feb-13 21-jan-13
01-jan-12 04-mar-12 23-dec-13
14-feb-11 31-jan-11 16-aug-11
SQL>select max(date col1) from t;
MAX(date col1)
-------------------
14-feb-11
SQL>select min(date col3) from t;
MIN(date col13)
-------------------
21-jan-13
SQL>create table order (oid
int,pname varchar(10),odate date datetime NOTNULL DEFAULT GETDATE( ));
Table created
SQL>select GETDATE() from order;
2008-11-11 12:45:34.243
SQL>select DATE
PART(yyyy,odate)as order year,DATEPART(mm,odate)as order month from order where
oid=1;
ORDER YEAR ORDER MONTH
-------------------- ----------------------
2008 11
SQL>select oid,DATEADD(day,45,orderdate)as
order pay date from orders;
OID ORDER PAY DATE
------ --------------------------
1
2008-12-26 13:23:44.647
SQL>DATEDIFF(day,’2008-06-05’,’2008-0806’)
as diff date from orders;
DIFFDATE
---------------
61
SQL>convert(varchar(19),GETDATE())convert(varchar(10)
GETDATE(),110) convert(varchar(11) GETDATE(),6));
Nov 04 2011 11:45 pm
11-04-2011
04
Nov 11
SUB QUERIES IN SQL
SQL> create table customer(cid
int,cname varchar2(20),age int,sex varchar2(10),dob varchar2(20),address
varchar2(20),phno int,email varchar2(20),anualincome varchar2(10),primary
key(cid));
Table created.
SQL>
insert into customer values('&cid','&cname','&age','&sex','&dob','&address','&phno','&email','
&annualincome');
Enter value for cid: 1
Enter value for cname: john
Enter value for age: 58
Enter value for sex: male
Enter value for dob: 5/7/55
Enter value for address: german
Enter value for phno: 8548547895
Enter value for email: john2@gmail.com
Enter value for annualincome: 15000
1 row created.
SQL> select * from customer;
CID
CNAME AGE SEX
DOB ADDRESS PHNO EMAIL ANUALINCOME
---------- --------------------
---------- ----------
-------------------- -------------------- ---------- -----------------
1
john 58 male
5/7/55 german 8548547895 john2@gmail.com 15000
2 mac 47
male 1/9/65 japan
8547694858 mac33@gmail.com 14000
3 sam 21 male
1/7/91 greek 7894562158 sam2@yahoo.com 10000
SQL>select * from customer cid in
(select cid from customer where annualincome>10000);
CID
CNAME AGE SEX
DOB ADDRESS PHNO EMAIL ANUALINCOME
---------- --------------------
---------- ----------
-------------------- -------------------- ---------- -----------------
1 john 58 male
5/7/55 german 8548547895 john2@gmail.com 15000
2 mac 47 male
1/9/65 japan 8547694858 mac33@gmail.com 14000
SQL>select * from customer cid not in
(select cid from customer where anualincome>10000);
CID
CNAME AGE SEX
DOB ADDRESS PHNO EMAIL ANNUALINCOME
---------- --------------------
---------- ----------
-------------------- -------------------- ---------- -----------------
3 sam 21 male
1/7/91 greek 789456215 sam2@yahoo.com 10000
KEY CONSTRAINS IN SQL
SQL> create table customer(cid
int,cname varchar2(20),age int,sex varchar2(10),dob varchar2(20),address
varchar2(20),phno int,email varchar2(20),anualincome varchar2(10),primary
key(cid));
Table created.
SQL>
insert into customer
values('&cid','&cname','&age','&sex','&dob','&address','&phno','&email','
&annualincome');
Enter value for cid: 1
Enter value for cname: john
Enter value for age: 58
Enter value for sex: male
Enter value for dob: 5/7/55
Enter value for address: german
Enter value for phno: 8548547895
Enter value for email: john2@gmail.com
Enter value for annualincome: 15000
1 row created.
SQL> select * from customer;
CID
CNAME AGE SEX
DOB ADDRESS
PHNO EMAIL ANUALINCOME
---------- --------------------
---------- ----------
-------------------- -------------------- ---------- -----------------
1
john 58 male
5/7/55 german 8548547895 john2@gmail.com 15000
2 mac 47 male
1/9/65 japan 854769485 mac33@gmail.com 14000
3 sam 21 male
1/7/91 greek 789456215 sam2@yahoo.com 10000
SQL> create table product(cid int,pid
int,pname varchar2(20),brandname varchar2(20),price int,quantity int,primary
key(cid,pid),foreign key(cid) references
customer);
Table created.
SQL> insert into product
values('&cid','&pid','&pname','&brandname','&price','&quantity');
Enter value for cid: 1
Enter value for pid: 1
Enter value for pname: x220
Enter value for brandname: sony
Enter value for price: 2500
Enter value for quantity: 5
1 row created.
SQL> select * from product;
CID
PID PNAME BRANDNAME PRICE
QUANTITY
------
------ ------------ --------------------- ----------
------------------
1 1 x220 sony 2500 5
2 2 xpro sony 10000 3
3 3 star 3 samsung 7000 1
SQL> create table person(pid
int,pname varchar2(20),address varchar(20),city varchar2(20), unique(pid));
Table created.
SQL> insert into person
values('&pid','&pname','&address','&city');
Enter value for pid: 1
Enter value for pname:john
Enter value for address:7th
north street
Enter value for city:coimbatore
1 row created.
SQL> select * from person;
PID
PNAME ADDRESS CITY
-----
-----------
-------------- -------
1 john 7th north street coimbatore
2 sam 2nd korea street cbe
3 winsester 4th cross street kovai
EXCEPT , EXISTS IN SQL
SQL>create table sailors(sid
int,sname varchar2(20),rating int,age int,primary key(sid));
Table created.
SOL> insert into sailors
values(‘&sid’,’&sname’,’&rating’,’&age’);
Enter value for sid:1
Enter value for sname:john
Enter value for rating:7
Enter value for age:22
1 row created.
SQL>select * from sailors;
SID SNAME
RATING AGE
---- ---------- --------- -----
1 john 7 22
2 dean 8 33
3 sam 5 32
SQL>create table boats(bid
int,bname varchar2(20),color
varchar2(20),primary key(bid));
Table created.
SOL> insert into boats
values(‘&bid’,’&bname’,’&color’,’&age’);
Enter value for bid:102
Enter value for sname:casino
Enter value for color::red
1 row created.
SQL>select * from boats;
BID BNAME
COLOR
---- ---------- ---------
102 casino red
102 titanic blue
103 santro green
SQL>create table reserves(sid
int,bid int,date varchar2(20),primary
key(sid,bid,date) foreign key (sid) references sailors,fpreign key (bid)
references boats);
Table created.
SOL> insert into boats
reserves(‘&sid’,‘&bid’,’&date’);
Enter value for sid:1
Enter value for bid:102
Enter value for date:9/9/91
1 row created.
SQL>select * from reserves;
SID BID DATE
---- ---------- ---------
1 102 9/9/91
2 102 8/8/81
3 103 6/6/91
SQL>select sname from sailors
where exsists(select * from reserves where bid=103 and sid=sid);
SNAME
-----------
Sam
SQL>select sname from sailors
where except(select * from reserves where bid=103 and sid=sid);
SNAME
-----------
John
dean
SQL>select sid from sailors left
join boats on sailors.bid=boat.bid except select sid from sailors right join
boats on sailors.bid=boat.bid;
SID
------
1
3
SQL>select sid from sailors
except select sid from reserves;
SID
-----
1
2
3
INTERSECT IN SQL
SQL>create table sailors(sid
int,sname varchar2(20),rating int,age int,primary key(sid));
Table created.
SOL> insert into sailors
values(‘&sid’,’&sname’,’&rating’,’&age’);
Enter value for sid:1
Enter value for sname:john
Enter value for rating:7
Enter value for age:22
1 row created.
SQL>select * from sailors;
SID SNAME
RATING AGE
---- ---------- --------- -----
1 john 7
22
2 dean 8 33
3 sam 5 32
SQL>create table boats(bid
int,bname varchar2(20),color
varchar2(20),primary key(bid));
Table created.
SOL> insert into boats
values(‘&bid’,’&bname’,’&color’,’&age’);
Enter value for bid:102
Enter value for sname:casino
Enter value for color::red
1 row created.
SQL>select * from boats;
BID BNAME
COLOR
---- ---------- ---------
102 casino red
102 titanic blue
103 santro green
SQL>create table reserves(sid
int,bid int,date varchar2(20),primary
key(sid,bid,date) foreign key (sid) references sailors,foreign key (bid)
references boats);
Table created.
SOL> insert into boats
reserves(‘&sid’,‘&bid’,’&date’);
Enter value for sid:1
Enter value for bid:102
Enter value for date:9/9/91
1 row created.
SQL>select * from reserves;
SID BID DATE
---- ---------- ---------
1 102 9/9/91
2 102 8/8/81
3 103 6/6/91
SQL>select s.sid from sailors
s,boats b,reserves r where s.ssid=r.sid and b.color=’red’ INTERSECT select
s.sid from sailors s,boats b,reserves r where r.bid=b.bid and b.color=’blue’
SID
----
1
2
UNION AND UNION ALL IN SQL
SQL> create table customer(cid
int,cname varchar2(20),age int,sex varchar2(10),dob varchar2(20),address
varchar2(20),phno int,email varchar2(20),annualincome varchar2(10),primary
key(cid));
Table created.
SQL>
insert into customer
values('&cid','&cname','&age','&sex','&dob','&address','&phno','&email','
&annualincome');
Enter value for cid: 1
Enter value for cname: john
Enter value for age: 58
Enter value for sex: male
Enter value for dob: 5/7/55
Enter value for address: german
Enter value for phno: 8548547895
Enter value for email: john2@gmail.com
Enter value for annualincome: 15000
1 row created.
SQL> select * from customer;
CID
CNAME AGE SEX
DOB ADDRESS PHNO EMAIL ANNUALINCOM
---------- --------------------
---------- ----------
-------------------- -------------------- ---------- -----------------
1 john 58 male
5/7/55 german 8548547895 john2@gmail.com 15000
2 mac 47 male
1/9/65 japan 854769485 mac33@gmail.com 14000
3 sam 21 male
1/7/91 greek 789456215 sam2@yahoo.com 10000
SQL> create table product(cid int,pid
int,pname varchar2(20),brandname varchar2(20),price int,quantity int,primary
key(cid,pid),foreign key(cid) references
customer);
Table created.
SQL> insert into product
values('&cid','&pid','&pname','&brandname','&price','&quantity');
Enter value for cid: 1
Enter value for pid: 1
Enter value for pname: x220
Enter value for brandname: sony
Enter value for price: 2500
Enter value for quantity: 5
1 row created.
SQL> select * from product;
CID
PID PNAME
BRANDNAME PRICE QUANTITY
------
------ ------------ --------------------- ----------
------------------
1 1 x220 sony 2500 5
2 2 xpro sony 10000 3
3 3 star 3 samsung 7000 1
SQL>select cid from customer union select cid from product;
CID
------
1
2
3
4
SQL>select cid from customer union all select cid from
product;
CID
------
1
2
3
4
1
2
3
4
Subscribe to:
Posts (Atom)