All_Solutions: 2018

Sunday 9 December 2018

what is facebook

Facebook is a popular free social networking website that allows registered users to create profiles, upload photos and video, send messages and keep in touch with friends, family and colleagues. The site, which is available in 37 different languages, includes public features such as:

Marketplace - allows members to post, read and respond to classified ads.

Groups - allows members who have common interests to find each other and interact.

Events - allows members to publicize an event, invite guests and track who plans to attend.

Pages - allows members to create and promote a public page built around a specific topic.

Presence technology - allows members to see which contacts are online and chat.

Within each member's personal profile, there are several key networking components. The most popular is arguably the Wall, which is essentially a virtual bulletin board. Messages left on a member's Wall can be text, video or photos. Another popular component is the virtual Photo Album. Photos can be uploaded from the desktop or directly from a smartphone camera. There is no limitation on quantity, but Facebook staff will remove inappropriate or copyrighted images. An interactive album feature allows the member's contacts (who are called generically called "friends") to comment on each other's photos and identify (tag) people in the photos. Another popular profile component is status updates, a microblogging feature that allows members to broadcast short Twitter-like announcements to their friends. All interactions are published in a news feed, which is distributed in real-time to the member's friends.

Facebook offers a range of privacy options to its members. A member can make all his communications visible to everyone, he can block specific connections or he can keep all his communications private. Members can choose whether or not to be searchable, decide which parts of their profile are public, decide what not to put in their news feed and determine exactly who can see their posts. For those members who wish to use Facebook to communicate privately, there is a message feature, which closely resembles email.

In May 2007, Facebook opened up its developers' platform to allow third-party developers to build applications and widgets that, once approved, could be distributed through the Facebook community. In May 2008, Facebook engineers announced Facebook Connect, a cross-site initiative that allows users to publish interactions on third-party partner sites in their Facebook news feed.

Thursday 22 March 2018

use Paytm

What is Paytm?

Paytm, owned by One97 Communications, is a digital payments platform that allows you to transfer cash into the integrated wallet via online banking, debit cards, and credit cards, or even by depositing cash via select banks and partners. Using the money in the Paytm wallet, you can pay for a number of goods without using cash.
Among the transactions you can make on Paytm are recharges for mobile phones, metro cards, DTH cable, data cards, etc, as well as postpaid payments for mobile phones, landline/ broadband, electricity, water and gas bills, etc. You can also book tickets for buses, trains, flights, movies, hotel rooms, etc. and pay for Uber cab rides using the platform. Additionally, you can buy goods on the company’s e-commerce platform using the wallet, and even make offline payments at over 8 lakh merchants, Paytm claims.

PL SQL Procedure

PL/SQL Procedure

The PL/SQL stored procedure or simply a procedure is a PL/SQL block which performs one or more specific tasks. It is just like procedures in other programming languages.
The procedure contains a header and a body.
◦Header: The header contains the name of the procedure and the parameters or variables passed to the procedure.
◦Body: The body contains a declaration section, execution section and exception section similar to a general PL/SQL block.
How to pass parameters in procedure:
When you want to create a procedure or function, you have to define parameters .There is three ways to pass parameters in procedure:
1.IN parameters: The IN parameter can be referenced by the procedure or function. The value of the parameter cannot be overwritten by the procedure or the function.
2.OUT parameters: The OUT parameter cannot be referenced by the procedure or function, but the value of the parameter can be overwritten by the procedure or function.
3.INOUT parameters: The INOUT parameter can be referenced by the procedure or function and the value of the parameter can be overwritten by the procedure or function.
A procedure may or may not return any value.
PL/SQL Create Procedure
Syntax for creating procedure:

1.CREATE [OR REPLACE] PROCEDURE procedure_name
2.    [ (parameter [,parameter]) ]
3.IS
4.    [declaration_section]
5.BEGIN
6.    executable_section
7.[EXCEPTION
8.    exception_section]
9.END [procedure_name];
Create procedure example
In this example, we are going to insert record in user table. So you need to create user table first.
Table creation:

1.create table user(id number(10) primary key,name varchar2(100));
Now write the procedure code to insert record in user table.
Procedure Code:

1.create or replace procedure "INSERTUSER"
2.(id IN NUMBER,
3.name IN VARCHAR2)
4.is
5.begin
6.insert into user values(id,name);
7.end;
8./
Output:
Procedure created.

PL/SQL program to call procedure
Let's see the code to call above created procedure.

1.BEGIN
2.   insertuser(101,'Rahul');
3.   dbms_output.put_line('record inserted successfully');
4.END;
5./
Now, see the "USER" table, you will see one record is inserted.

ID
Name
101 Rahul
PL/SQL Drop Procedure
Syntax for drop procedure

1.DROP PROCEDURE procedure_name;
Example of drop procedure

1.DROP PROCEDURE pro1;
Next TopicPL/SQL Function

PL SQL Function

PL/SQL Function

The PL/SQL Function is very similar to PL/SQL Procedure. The main difference between procedure and a function is, a function must always return a value, and on the other hand a procedure may or may not return a value. Except this, all the other things of PL/SQL procedure are true for PL/SQL function too.

Syntax to create a function:

1.CREATE [OR REPLACE] FUNCTION function_name [parameters]
2.[(parameter_name [IN | OUT | IN OUT] type [, ...])]
3.RETURN return_datatype
4.{IS | AS}
5.BEGIN
6. < function_body >
7.END [function_name];

Here:
◦Function_name: specifies the name of the function.
◦[OR REPLACE] option allows modifying an existing function.
◦The optional parameter list contains name, mode and types of the parameters.
◦IN represents that value will be passed from outside and OUT represents that this parameter will be used to return a value outside of the procedure.

The function must contain a return statement.
◦RETURN clause specifies that data type you are going to return from the function.
◦Function_body contains the executable part.
◦The AS keyword is used instead of the IS keyword for creating a standalone function.

PL/SQL Function Example

Let's see a simple example to create a function.

1.create or replace function adder(n1 in number, n2 in number)
2.return number
3.is
4.n3 number(8);
5.begin
6.n3 :=n1+n2;
7.return n3;
8.end;
9./

Now write another program to call the function.

1.DECLARE
2.   n3 number(2);
3.BEGIN
4.   n3 := adder(11,22);
5.   dbms_output.put_line('Addition is: ' || n3);
6.END;
7./

Output:

Addition is: 33
Statement processed.
0.05 seconds

Another PL/SQL Function Example

Let's take an example to demonstrate Declaring, Defining and Invoking a simple PL/SQL function which will compute and return the maximum of two values.

1.DECLARE
2.   a number;
3.   b number;
4.   c number;
5.FUNCTION findMax(x IN number, y IN number)
6.RETURN number
7.IS
8.    z number;
9.BEGIN
10.   IF x > y THEN
11.      z:= x;
12.   ELSE
13.      Z:= y;
14.   END IF;
15.
16.   RETURN z;
17.END;
18.BEGIN
19.   a:= 23;
20.   b:= 45;
21.
22.   c := findMax(a, b);
23.   dbms_output.put_line(' Maximum of (23,45): ' || c);
24.END;
25./

Output:

Maximum of (23,45): 45
Statement processed.
0.02 seconds

PL/SQL function example using table

Let's take a customer table. This example illustrates creating and calling a standalone function. This function will return the total number of CUSTOMERS in the customers table.

Create customers table and have records in it.

Customers

Name

Department

Salary

1 alex web developer 35000
2 ricky program developer 45000
3 mohan web designer 35000
4 dilshad database manager 44000

Create Function:

1.CREATE OR REPLACE FUNCTION totalCustomers
2.RETURN number IS
3.   total number(2) := 0;
4.BEGIN
5.   SELECT count(*) into total
6.   FROM customers;
7.    RETURN total;
8.END;
9./

After the execution of above code, you will get the following result.

Function created.

Calling PL/SQL Function:

While creating a function, you have to give a definition of what the function has to do. To use a function, you will have to call that function to perform the defined task. Once the function is called, the program control is transferred to the called function.

After the successful completion of the defined task, the call function returns program control back to the main program.

To call a function you have to pass the required parameters along with function name and if function returns a value then you can store returned value. Following program calls the function totalCustomers from an anonymous block:

1.DECLARE
2.   c number(2);
3.BEGIN
4.   c := totalCustomers();
5.   dbms_output.put_line('Total no. of Customers: ' || c);
6.END;
7./

After the execution of above code in SQL prompt, you will get the following result.

Total no. of Customers: 4
PL/SQL procedure successfully completed.

PL/SQL Recursive Function

You already know that a program or a subprogram can call another subprogram. When a subprogram calls itself, it is called recursive call and the process is known as recursion.

Example to calculate the factorial of a number

Let's take an example to calculate the factorial of a number. This example calculates the factorial of a given number by calling itself recursively.

1.DECLARE
2.   num number;
3.   factorial number;
4.
5.FUNCTION fact(x number)
6.RETURN number
7.IS
8.   f number;
9.BEGIN
10.   IF x=0 THEN
11.      f := 1;
12.   ELSE
13.      f := x * fact(x-1);
14.   END IF;
15.RETURN f;
16.END;
17.
18.BEGIN
19.   num:= 6;
20.   factorial := fact(num);
21.   dbms_output.put_line(' Factorial '|| num || ' is ' || factorial);
22.END;
23./

After the execution of above code at SQL prompt, it produces the following result.

Factorial 6 is 720
PL/SQL procedure successfully completed.

PL/SQL Drop Function

Syntax for removing your created function:

If you want to remove your created function from the database, you should use the following syntax.

1.DROP FUNCTION function_name;

Next TopicPL/SQL Cursor

hindi new channel live

hindi new channel live -------

https://hindi.news18.com/livetv/news18-uttar-pradesh-uttarakhand -- news up

https://www.newsx.com/live-tv/india-news-uttar-pradesh ----up

http://zeenews.india.com/live-tv ---zee newshttps://www.indiatvnews.com/livetv ---india tv

https://www.youtube.com/watch?v=lIiU09BVwpo --taj

https://www.youtube.com/watch?v=ARBBYcp-C4g---up

newshttps://www.ndtv.com/video/live/channel/ndtv24x7 ---ndtv

newshttps://www.youtube.com/watch?v=sEta5JOM5uU ---ndtv

newshttps://www.youtube.com/watch?v=hEjswdt1DKM ---news18

https://www.youtube.com/watch?v=X7Ktabhd8a4 ---ajtak

Thursday 8 March 2018

SQL query to find second highest salary

SQL query to find second highest salary
Name     Salary
---------------
mohan   -- 100000
ram   --- 1000000
gita ---- 40000
sita   --- 500000
SELECT name, MAX(salary) AS salary
FROM employee
WHERE salary < (SELECT MAX(salary)
                 FROM employee)

Monday 5 March 2018

Traffic --Leads--Sales

Traffic, Leads, Sales
More traffic, more signups, more sales now!

http://trck.me/133266/

Viral Social Traffic from

Social Media & Networking

http://www.BlastYourInternetBusiness.com/?rd=gq6EwKwg

increase the traffice -----

increase the traffic ------

https://trafficadbar.com/website_traffic/home

Your referral link

http://trafficadbar.com/praveenxyz

Ultimate recruiting guide

•

I share all of my secrets to recruiting new team members daily

•

https://forms.aweber.com/form/88/1948243788.htm

india national news papers

india national news papers------------------

The Hindu
Hindustan Times
The Indian Express
The Morung Express
The Navhind Times
The New Indian Express
The News Today
The North East Times
The Sentinel
The Shillong Times
The Statesman
The Telegraph
The Times of India
The Tribune
Bangalore Mirror
Afternoon
Amar Asom
Asomiya Khobor
Asomiya Pratidin
Dainik Janambhumi
Dainik Agradoot
Gana Adhikar
Janasadharan
Niyomiya Barta
Aajkaal
Anandabazar Patrika
Bartaman Patrika
Dainik Bhaskar
Divya Bhaskar
Jagat Darpan
Dainik Sambad

Japan List of newspapers in Japan

Japan List of newspapers in Japan

Asahi Shimbun
Mainichi Shimbun
Nihon Keizai Shimbun
Sankei Shimbun
Yomiuri Shimbun

Afrin ---What is going on in Syria's other battle

Afrin---What is going on in Syria's other battle

click link ---

http://www.bbc.com/news/av/world-middle-east-43293232/afrin-what-is-going-on-in-syria-s-other-battle

Install Skype

Install Skype----

https://www.skype.com/en/get-skype/

how to increase traffic on my website

how to increase traffic on my website--------------

Use Landing Pages
Target Long-Tail Keywords
Start Email Marketing
Advertise Online
Perform On-Page SEO
Get Listed
Post to Social Media with Hashtags
share your websites on facebook social media, linkden, twitter, and so many online software
Facebook. This is the biggest social networking site with the largest number of users. ...
Twitter. Twitter is loved for spreading the word via tweets. ...
LinkedIn. ...
Google + ...
YouTube. ...
Pinterest. ...
Instagram. ...
Tumblr.

Conrad Sagma, Backed By BJP, Faces First Challenge Before Meghalaya Oath

Conrad Sagma, Backed By BJP, Faces First Challenge Before Meghalaya Oath

click link -----

https://www.msn.com/en-in/news/newsindia/conrad-sagma-backed-by-bjp-faces-first-challenge-before-meghalaya-oath/ar-BBJUVMo?ocid=spartanntp

Sunday 4 March 2018

Monday 26 February 2018

10KHits Alternatives

10KHits Alternatives---------

https://hitleap.com/

http://www.pandabot.net/

Getting 10k Traffic In 1day

Getting 10k Traffic In 1day ------------

https://www.10khits.com/

Get Free Unlimited Traffic For Website

Get Free Unlimited Traffic For Website -------------

https://hitleap.com

This website can get you lot of free traffic and can make you earn some money providing other the same service on fiverr and seoclerks .
And the traffic from hitleap can help you to increase your website alexa rank as well so use it and enjoy the traffic .

Get Free Unlimited Traffic For Website And Earn Money Using Traffic

Get Free Unlimited Traffic For Website And Earn Money Using Traffic ---------

http://www.trafficadbar.com

narendra modi biography

narendra modi biography -----------

Real Name	Narendra Damodardas Modi
Nickname	NaMo
Profession	Indian Politician
Age	67 Years
Date of Birth	17 September 1950
Birthplace	Vadnagar, Bombay State (presently Gujarat), India
Nationality	Indian
Star Sign/ Zodiac Sign	Virgo
Caste	OBC (Modh Ghanchi)
Party	Bharatiya Janata Party (BJP)
Political Journey	• In November 1995, he was elected National Secretary of BJP. • In 1988, BJP elected him Organizing Secretary of Party's Gujarat Unit. • In May 1998, he became the General Secretary of BJP. • On 26 May 2014, he was appointed the 14th Prime Minister of India.
Height, Weight & Body Measurements
Height in Centimeters	170 cm
Height in meters	1.70 m
Height in Inches	5’ 7”
Weight in Kilograms	78 kg
Weight in Pounds	172 lbs
Body Measurements	40-34-14 Inches
Chest Size	40 Inches
Waist Size	34 Inches
Biceps Size	14 Inches
Shoe Size	10 Inches
Eye Color	Dark Brown
Hair Color	Black
Family and Relatives
Father	Late Damodardas Mulchand Modi
Mother	Heeraben
Brothers	Soma (75 Years) - Retired officer of health department, Prahlad (62) - runs a shop in Ahmedabad, Pankaj (57) - clerk in the information department headquarters, Gandhinagar
Sisters	Vasantiben Hasmukhlal Modi, Amrut
Religion	Hinduism

Sunny Leone biography

Sunny Leone biography----------

----------------
Karenjit Kaur Vohra
May 13, 1981 (age 36)
Sarnia, Ontario, Canada
Nationality
Canadian American
Occupation
Actress, former pornographic actress
Height
5 ft 4 in (1.63 m)
Weight
110 lb (50 kg; 7.9 st)
Spouse(s)
Daniel Weber (2011–present)
Children
1
--------------------------------------