Tuesday, 20 March 2012

Map api key for android

Step:1 Go to Run and Type cmd

Step:2 Go to Path at (.android) folder.

Step:3 Now type command
             kaytool -list -alias androiddebugkey -keystore debug.keystore -storepass android -keypass  android

Thursday, 15 March 2012

what is WEB HOSTING?

A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own or lease for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers theydo not own to be located in their data center.


Internet - The Internet is a huge public forum which is ideally suited for
marketing, real-time commerce, delivery of technical support
information, contact information and the posting of other “public”

SQL Syntax

SELECT "column_name" FROM "table_name"

SELECT DISTINCT "column_name"
FROM "table_name"

SELECT "column_name"
FROM "table_name"
WHERE "condition"

Thursday, 8 March 2012

Stored procedures or Local Procedures in sql

Stored procedures or Local Procedures:
CREATE [OR REPLACE] PROCEDURE procedure_name [(argument [{IN | OUT | IN OUT}]
argument_type, ...)] {IS | AS}
  • Procedure_body is a PL/SQL block, must have at least one statement (can be NULL).
  • Creating a procedure is a DDL operation -- so implicit COMMIT is done
  • Either IS or AS can be used
  • Parameter mode (Ada style of call-by-value or reference): IN (read-only), OUT (write-only value is ignored and NOT allowed at RHS value), IN OUT (read-write), default is IN mode. The argument_type must be unconstrained, e.g. CHAR(20) is not allowed.

sql vs plsql

SQL stands for Structured Query
Language, which does not have
procedural programming

PL/SQL stands for Procedural
Structured Query Language.
Which have advantage over SQL.

SQL is the language that enables
relational database users to
communicate with the database in
a straightforward manner.

PL/SQL is Oracle's procedural
language; it comprises the
standard language of SQL and a
wide array of commands that
enable you to control the
execution of SQL statements
according to different conditions.

Grant/Revoke Privileges in plsql

Grant Privileges on Tables

You can grant users various privileges to tables. These privileges can be any combination of select, insert, update, delete, references, alter, and index. Below is an explanation of what each privilege means.
Ability to query the table with a select statement.
Ability to add new rows to the table with the insert statement.
Ability to update rows in the table with the update statement.
Ability to delete rows from the table with the delete statement.
Ability to create a constraint that refers to the table.
Ability to change the table definition with the alter table statement.
Ability to create an index on the table with the create index statement.