Pages

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?

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,Intranet,Extranet

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”
resources.

SQL Syntax


Select
SELECT "column_name" FROM "table_name"

Distinct
SELECT DISTINCT "column_name"
FROM "table_name"

Where
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;
  • 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
PL/SQL
SQL stands for Structured Query
Language, which does not have
procedural programming
capability.

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.
Privilege
Description
Select
Ability to query the table with a select statement.
Insert
Ability to add new rows to the table with the insert statement.
Update
Ability to update rows in the table with the update statement.
Delete
Ability to delete rows from the table with the delete statement.
References
Ability to create a constraint that refers to the table.
Alter
Ability to change the table definition with the alter table statement.
Index
Ability to create an index on the table with the create index statement.