WAP to use for-reverse loop in PL/SQL

WAP to use for-reverse loop in PL/SQL
step-1

create table tb1(id number);
  
RUN THIS COMMAND, IF SUCCESSFULLY RUN THEN WRITE PL/SQL COMMAND
step-2

declare
vid number:=0;
begin
for vid in reverse 1..10
loop
insert into tb1(id)
values(vid);

dbms_output.put_line(vid);
end loop;
end;

WAP to use procedure in pl/sql

WAP to use procedure in pl/sql
step-1 create a table

create table student(stdRollNo number, stdName varchar2(25)

, stdClass varchar2(25));
  
RUN these COMMANDs, IF SUCCESSFULLY RUN THEN WRITE PL/SQL COMMAND
step-2
 
create or replace procedure
print(vid number,vname varchar2(25))
is
begin
insert into student(stdRollno,stdName)
values(vid,vname);
end print; 
 
RUN these COMMANDs, IF SUCCESSFULLY RUN THEN WRITE following 

COMMAND
step-3
 
begin
print(01,'xyz');
end print; 

OR command

OR command

select stdName 
from student
where stdRollno=2 or stdRollno=3

Customize your system tray

Customize your system tray.
These tips apply primarily to Windows 7

Windows 7 helpfully decreases the amount of space dedicated to 

the Notification Area by putting all but the most essential 

notifications within a drop-down (or, in this case, drop-up) 

box. It looks nice, but you can burn lots of time with wasted 

clicks as you hunt for what you need. If you want regular, 

click-free access to some of these notifications, change the 

default layout. It’s easy to do. Just open the tray’s spillover 

window and drag the icons you want to the taskbar area. You can 

rearrange icons within the added window, too. 

NOT command

NOT command

select * 
from student
where not stdAddress='gao'

WAP to use loop in PL/SQL

WAP to use loop in PL/SQL
step-1

create table tb1(id number);
 
RUN THIS COMMAND, IF SUCCESSFULLY RUN THEN WRITE PL/SQL COMMAND
step-2
 
declare
vid number:=0;
begin
loop
vid:=vid+1;
insert into tb1(id)
values(vid);
if(vid>=10) then
exit;
end if;
dbms_output.put_line(vid);
end loop;
end;

Snap windows faster

Snap windows faster.
These tips apply primarily to Windows 7
Source: PC World

But what if you like Aero Snap? Here is a faster way to snap 

windows right or left by using keyboard shortcuts instead of 

the mouse.  snaps left, and  snaps right. While we’re at it,  

will maximize your window, while  will minimize it. 

(Note, however, that if you have done the Registry hack 

described in the preceding tip to turn off Aero Snap, that 

hack will have disabled these particular shortcuts, too.)

Get a quick peek at the desktop

Get a quick peek at the desktop.
These tips apply primarily to Windows 7

Simply click  to hide all open windows. Keep the  held down and 

then release that key to return to your former environment with 

all its open windows in place.

WAP to search a character in a string

/*WAP to search a character in a string*/

#include<stdio.h>
#include<conio.h>
#include<string.h>

main()
{
 char *ptr, str[50];
 int ch;
 // Input of String & character
 printf("\n Enter the String \n");
 gets(str);
 printf("\n Enter the character to search ");
 ch = getchar();
 // Searching the character
 ptr = strchr(str,ch);
 if(ptr == NULL)
  printf("\n Not Found");
 else
  printf("\n The character %c is at the position %d\n",ch,ptr-str);
 getch();
 return 0;
}

bc command for calculation in linux

bc command for calculation in linux
cmd---------

$bc

e.g---------
$bc
2+5
7 //output

Make Internet Explorer load faster

Make Internet Explorer load faster.
These tips apply primarily to Windows 7
Source: PC World

When IE loads very slowly for no clear reason, it’s usually 

due to an add-on 

clogging the pipes. Fortunately, one of IE’s best features is that it allows you to
see how long each add-on is taking to load. You can find this under Tools Manage
Add-ons. Check the ‘Load time’ column to see what has been weighing you down.

Zoom faster in Windows 7 and Vista

Zoom faster in Windows 7 and Vista
These tips apply primarily to Windows 7
Source : PC World

In Windows 7 and Vista,  lets you zoom in and out in most 

applications. In Windows Explorer, this combo makes icons 

and thumbnails larger or smaller. In Web browsers and most 

graphics programs, it changes the font size or the zoom 

level up and down. 

Control your post-vacation time

Control your post-vacation time.
These tips apply primarily to Windows 7
Source : PC World

Never schedule anything for the day after you come back from a 

long trip or vacation, since you’ll need this day to catch up 

on everything you’ve missed while you were out. If you use a 

shared calendar system, book the entire day of your return with 

“meetings” before you leave. 

Fix a Computer Clock That Forgets the Time

Fix a Computer Clock That Forgets the Time

A computer can fail to keep good time for a number of reasons.
It could be the result of Windows failing to connect to its timesync
server, or it could be due to a dead CMOS battery.
Readjusting the clock fixes the problem
for his current session, but every time he reboots, the clock
automatically readjusts itself based on the time-zone setting.
Fortunately, this is a super-easy problem to fix:

1. Right-click the clock in the System Tray (bottom-right corner)
and click Adjust date/time. 

2. In the ‘Date and Time’ tab of the resulting dialog box, click
Change time zone. Choose the proper time zone for your location.

3. Click OK, then click OK again.
Done! Done! Done!

Change Your Windows User-Account Picture

Change Your Windows User-Account Picture

When you click the Start menu (or visit the Windows log-on screen),
you see an arbitrary thumbnail image of a fl ower, a soccer ball, a
rubber ducky, or one of a handful of other stock Windows images.
Though you don’t get many choices when you initially set up your
PC (and in some cases you don’t get a choice at all), you can easily
change the image that’s assigned to your user account. Here’s how
(in Windows 7; the procedure may vary slightly in earlier versions):

1. Open the Control Panel and choose User Accounts. (Windows
Vista and 7 users can follow an alternative route to User Accounts
if they like: Click Start, type User Accounts, and press .) 

2. Click Change your picture.
3. If you don’t want any of the available thumbnails, click
Browse for more pictures.
4. Navigate to the desired folder and choose the BMP, GIF, JPEG,
or PNG image you want. 

for windows XP

1. Click Start --> click on Control Panel.

2. click on user Account in control panel window.

3. click on administration from "pick an account to change".

4. choose change my picture.

5. choose picture or browse.

6. click on change picture button.

Save time with VoIP

Save time with VoIP.
These tips apply primarily to Windows 7
Source: PC World

You can save significant time—and possibly money, too—by using a 

VoIP system that allows you to click phone numbers in Web pages 

and in e-mail messages and dial them directly via your PC. 

Skype (skype.com) offers such an option, which works broadly in 

e-mail and on most Websites, and Google recently integrated its 

own VoIP offering, Google Voice, into Gmail (gmail.com). 

In addition, Google Voice saves call histories as they take place, 

integrating them into the Gmail contact management system. 

Pin almost anything to the taskbar

Pin almost anything to the taskbar.
These tips apply primarily to Windows 7
Source: PC World
 

There is practically no limit to the things you can pin to the 

task-bar: 

often-used folders, the Control Panel, even a button to shut 

down your PC. (For the last option, find shutdown.exe in the 

System/Windows32 directory, create a shortcut to it, and then 

append this text to the target in Properties: /s /f /t 00).

Alter Windows Explorer’s ‘Favorites’

Alter Windows Explorer’s ‘Favorites’.
These tips apply primarily to Windows 7
Source: PC World
 

Drag folders to the top left of the screen from within Explorer 

and then organize them however you like. Right-click and select 

remove to get rid of anything you don’t want. 

PL/SQL command

PL/SQL
step-1 create a table

create table student(stdRollNo number, stdName varchar2(25), 

stdClass varchar2(25));
  
RUN THIS COMMAND, IF SUCCESSFULLY RUN THEN WRITE PL/SQL COMMAND

step-2 
 

declare
vid number:=1;
vname varchar2(25):='xyz';
vclass varchar2(25):='X';
begin
insert into student(stdRollNo, stdName , stdClass)
values(vid,vname,vclass);
end;

Liberally use Windows 7’s Jump Lists

Liberally use Windows 7’s Jump Lists.
These tips apply primarily to Windows 7
Source: PC World
 

You can access the Jump Lists by right clicking on any icon 

in the taskbar. You’ll find recently used documents, along 

with certain app-specific functions (such as setting your 

IM client to ‘Away’). One little time-saver: You can pin a 

Web URL to your browser’s Jump List by dragging that URL to 

the browser icon in the taskbar (do this by clicking on the 

mini icon in the URL bar).

Default to the Documents Library

Default to the Documents Library.
These tips apply primarily to Windows 7
Source: PC World
 

In Windows 7, when you launch Windows Explorer, the view automatically 

defaults to the Libraries Folder, which for many users is not very 

useful. Busy types will typically drill straight to the Documents 

Library from there. Save a click by instructing Explorer to default to 

the Documents Library. To do this, right-click on the Windows Explorer 

shortcut (the taskbar shortcut won’t work). In the Target field, type or 

paste: %windir%\explorer.exe ::{450D8FbAAD25-11D0-98A8-0800361b1103} 

Finally, replace the icon in the taskbar with your tweaked shortcut.

Power up the ‘Send To’ feature

Power up the ‘Send To’ feature.
These tips apply primarily to Windows 7
Source: PC World
 

When right-clicking a file in Windows Explorer, hold down  before 

you click and then select the Send To command. Windows will reveal 

a whole host of additional options, such as one to move the file to 

an often-used folder.

Use Outlook’s categorization system.

Use Outlook’s categorization system.
These tips apply primarily to Windows 7
Source: PC World
 

Outlook lets you color-code messages, task-list items, calendar 

entries, and even contacts into as many as six categories. 

Figure out a system and stick to it: red for business, for 

example, and blue for personal items. Or color-code items by 

level of urgency: green for “must do today,” blue for “to do 

this week,” and yellow for “to do this month.” 

Select multiple files easily

Select multiple files easily.
These tips apply primarily to Windows 7
Source: PC World
 

Using the or  keys to select multiple files in Windows Explorer 

can be difficult and an invitation to commit errors. If, however,

you frequently need to open or manipulate multiple files at once,

turn on Windows’ Check-box system—it lets you select files more 

easily. In Windows Explorer, you can find this setting under or 

ganize Folder and search options View. Scroll down and select Use

check boxes to select items; then click OK.

Make important e-mail more findable.

Make important e-mail more findable.
These tips apply primarily to Windows 7
Source: PC World
 

Just change the subject lines. Few things are more annoying than 

receiving an important e-mail message that carries a clueless 

subject like “hey” (or worse, an empty subject line). A more 

meaningful subject line improves your search index 

and makes your e-mail thread more valuable in general. In Outlook, 

open the message(this tactic doesn’t work with just a preview), 

select the subject line, and type over it with the more-useful text

you want.

Don’t constantly check your e-mail

Don’t constantly check your e-mail.
These tips apply primarily to Windows 7
Source: PC World
 

Frequent checking breaks your concentration and interrupts what 

you’re doing, wasting time as you return your focus to the task 

at hand. Reduce how often your e-mail client checks for new 

messages to something less distracting: Every 10 or 15 minutes 

should give you time enough to focus without keeping people 

waiting overly long for a response. In Outlook, click S and tweak 

the digits for ‘Schedule an automatic send/receive every minutes’.

Drag in Outlook

Drag in Outlook.
These tips apply primarily to Windows 7
Source: PC World
 

In Outlook, you can drag any item to any other area of the 

program, and it will create a new item there, with the dragged 

information as part of the new item or event. Drag an e-mail 

to the Contacts button, and it will create a new contact for 

the sender, automatically populating the Name and E-mail fields, 

and putting the body of the message in the Notes field. Drag a 

contact to the Calendar, and you’ll create a Meeting Invitation 

ready to be sent to that person, and so on.

Rename files fast

Rename files fast.
These tips apply primarily to Windows 7
Source: PC World
 

Renaming lots of files in Windows Explorer? Select the first 

file in your list, press , and type the new name. When finished,

press  instead of . Explorer will jump you to the next file in 

the list and automatically select the entire file name so you can 

rename it without having to press the  key. Continue pressing , 

and you’ll zip through the list one file at a time. 

Improve Windows Search.

Improve Windows Search.
These tips apply primarily to Windows 7
Source: PC World
 

If Windows Search isn’t finding everything that you know you’ve 

saved, check the Windows Indexing Options (type indexing options

into the Windows 7 Start Menu search bar), and then check the 

locations that are included in the search index. Click Modify, 

and navigate through the C: drive to add more locations to index. 

Customize your browser’s default search engine.

Customize your browser’s default search engine.
These tips apply primarily to Windows 7
Source: PC World
 

Your PC builder has likely preset Internet Explorer’s default 

search engine to the one that’s paying it the most. Otherwise, 

it’ll be set to Microsoft’s liking: Bing. Change this setting 

by clicking the drop-down arrow in the top right corner of the 

IE window (within the search box), and click Find More Providers. 

You won’t find Google without a hunt, so type Google into the 

‘Find add-ons…’ search box, and select the first result, Google 

Search Suggestions. Click Add to Internet Explorer, and at the 

pop-up, click Make this my default search provider. 

Delete command

Delete command

delete student
where stdAddress='kota'

select command

select command
stdName, stdAddress is field
table student
----------CODE--------------

select stdName 
from student
where stdAddress='kota'

remove a table in SQL

remove a table in SQL
--------CODE---------

drop table student

modify one or more records in specified relation in SQL

modify one or more records in specified relation in SQL
here stdAddress and stdRollno is field name
----------------------CODE----------------------------

update student
set stdAddress='kota'
where stdRollno='1'

insert domain at specified field in SQL

insert domain at specified field in SQL
here stdAddress is field name
and goa is value it.
--------------CODE---------------------

insert into student(stdAddress)
values('goa');

Minimize all windows in windows 7

Please note: These tips apply primarily to Windows 7

Minimize all windows (except the one that you’re working on).  
When your desktop becomes so cluttered that you
can’t find anything, this step is a good way to regain focus. Grab the title bar of the 
window you want, and shake your mouse a little. All other windows will vanish into 
the task-bar. Repeat to undo and restore all of your hidden windows.

change field data type into existing table in sql

change field data type into existing table in sql

alter table student
modify(stdAddress varchar2(50));

insert field into existing table in SQL

insert field into existing table in SQL
here table name is student
---------------------------------------

alter table student
add(stdAddress varchar2(25));

insert values into a table

insert values into a table
here student is table name

insert into student
values(01,'ABC','XII');

WAP function using a pointer to a function

/*WAP Invoking a function using a pointer to a function */

#include<stdio.h>
#include<conio.h>
main( )
{
 int  display( ) ;
 int  ( *func_ptr )( ) ;

 func_ptr = display ;  /* assign address of function */ 
 printf ( "\nAddress of function display is %u", func_ptr ) ;
 ( *func_ptr )( ) ;  /* invokes the function display( ) */
         getch();
}

int  display( )
{
 puts ( "\nLong live viruses!!" ) ;
}

Yahoo! Messenger Hidden Emoticons

Yahoo! Messenger Hidden Emoticons

puppy dog eyes :o3
I don't know - New! :-??
not listening - New! %-(
pig :@)
cow 3:-O
monkey :(|)
chicken ~:>
rose @};-
good luck %%-
flag **==
pumpkin (~~)
coffee ~O)
idea *-:)
skull 8-X
bug =:)
alien >-)
frustrated :-L
praying [-O<
money eyes $-)
whistling :-"
feeling beat up b-(
peace sign :)>-
shame on you [-X
dancing \:D/
bring it on >:/
hee hee ;))
chatterbox :-@
not worthy ^:)^
oh go on :-j
star (*)
hiro o->
billy o=>
april o-+
yin yang (%)