Corruption Essays

Corruption Essays Corruption Essay Corruption Essay INTRODUCTION SQL is divided into the following ? Data Definition Language (DDL) ? Data Manipulation Language (DML) ? Data Retrieval Language (DRL) ? Transaction Control Language (TCL) ? Data Control Language (DCL) DDL create, alter, drop, truncate, rename DML insert, update, delete DRL select TCL commit, rollback, savepoint DCL grant, revoke CREATE TABLE SYNTAX Create table (col1 datatype1, col2 datatype2 †¦coln datatypen); Ex: SQL create table student (no number (2), name varchar (10), marks number (3)); INSERT This will be used to insert the records into table. We have two methods to insert. ? By value method By address method a) USING VALUE METHOD Syntax: insert into insert into student values (1, ’sudha’, 100); SQL insert into student values (2, ’saketh’, 200); To insert a new record again you have to type entire insert command, if there are lot of records this will be difficult. This will be avoided by using address m ethod. b) USING ADDRESS METHOD Syntax: insert into insert into student values (no, , marks); Enter value for no: 1 Enter value for name: Jagan Enter value for marks: 300 old 1: insert into student values(no, , marks) new 1: insert into student values(1, Jagan, 300) SQL / Enter value for no: 2 Enter value for name: Naren Enter value for marks: 400 old 1: insert into student values(no, , marks) new 1: insert into student values(2, Naren, 400) c) INSERTING DATA INTO SPECIFIED COLUMNS USING VALUE METHOD Syntax: insert into insert into student (no, name) values (3, ’Ramesh’); SQL insert into student (no, name) values (4, ’Madhu’); d) INSERTING DATA INTO SPECIFIED COLUMNS USING ADDRESS METHOD Syntax: insert into insert into student (no, name) values (no, ); Enter value for no: 5 Enter value for name: Visu ld 1: insert into student (no, name) values(no, ) new 1: insert into student (no, name) values(5, Visu) SQL / Enter value for no: 6 Enter value for name: Rattu old 1: insert into student (no, name) values(no, ) new 1: insert into student (no, name) values(6, Rattu) SELECTING DATA Syntax: Select * from ; here * indicates all columns or Select col1, col2, †¦ coln from ; Ex: SQL select * from student; NO NAME MARKS 1 Sudha 100 2 Saketh 200 1 Jagan 300 2 Naren 400 3 Ramesh Madhu 5 Visu 6 Rattu SQL select no, name, marks from student; NO NAME MARKS 1 Sudha 100 2 Saketh 200 1 Jagan 300 2 Naren 400 3 Ramesh 4 Madhu 5 Visu 6 Rattu SQL select no, name from student; NO NAME - 1 Sudha 2 Saketh 1 Jagan 2 Naren 3 Ramesh 4 Madhu 5 Visu 6 Rattu CONDITIONAL SELECTIONS AND OPERATORS We have two clauses used in this ? Where ? Order by USING WHERE Syntax: select * from where ; the following are the different types of operators used in where clause. Arithmetic operators ? Comparison operators ? Logical operators ? Arithmetic operators highest precedence +, -, *, / ? Comparison operators ? =, ! =, , =, , =, select * from student where no = 2; NO NAME MARKS - 2 Saketh 200 2 Naren 400 SQL select * from student where no 2; NO NAME MARKS - - 1 Sudha 100 1 Jagan 300 SQL select * from student where no 2; NO NAME MARKS - - 3 Ramesh 4 Madhu 5 Visu 6 Rattu The initial seeds of corruption are sown into our brains right from the moment we are made to leave he safe and sound boundaries of our houses to go into a different world that is waiting to grope upon us in every possible manner. Our parents tell us to be sharp, to think crisply, not to open-up in front of stranger for the fear of being harmed at our behest; but during that process they forget that they are injecting not only a few remedial measures into an innocent brain but also fears that have strings attached. We are exposed to a lot from a very tender age. Voyeurism, misogamy, patriarchy are all so deeply rooted in our societies that we tend to sway from the natural path. Juveniles, adolescents, teenagers are not taken as seriously, neither at their homes nor in schools, ergo the rise in case of Juveniles indulging into illicit affairs. Majority of the mass fails to provide the basics to their children and family and hence, they take to different mall-practices that induce young minds, hence rendering them corrupt. The government today is not the only body responsible for the wide spread epidemic of corruption in our country. Lets roll the reel back to the time when the British ruled I. . Woo hundred years back, who were their servants while they ran the East India Company here? They were amongst us. Also who were their secret informers who gave them information about the plotting being made by Begat Sings and Raja Guru? Why did these people go out of their way to impart crucial information to the rulers? The answers are implicit. Corr uption has ever since been a way of thinking, a thought process that cannot, for apparent reasons, be done away with wholly but by means of introduction of radical improvisations of the current Achaeans in most of the fields, it can be done to cut down by a reasonable margin. Sat loopholes that are taken advantage of, by a great number of people sitting at the top of the hierarchy of the various organizations. And it is absolutely frivolous to believe that it is only the biggies who are corrupt, the common man is Just as corrupt, not lagging far behind. From not taking a ticket in a crowded bus to taking extra polygamy from the grocery shop, all form the long and short of the spate that corruption is. A more stringent work mechanism, closely monitored sets of reoccurred and a speedy and effective punitive system for remedies to those affected would surely be helpful in curbing the rate at which these mall-practices are sporadically prevalent. And what more than a little more sense of individual responsibility in each one of us to keep the environment clean, to save water etc. These would all together contribute to the bigger cause of dilution of corruption. As they say charity begins from home, so let all pledge for a better society by doing our part honestly and vehemently.