CAMERA AND VIRTUAL DATACABLE FROM THE GOOGLE PLAY STORE

Description

This app lets you see in the dark!

Take photos and record video even in low light environments.

Ever wanted to take photos or record video but couldn't because there was not enough light? Now you can with this free Night Vision Spy Camera app.

You will find this app very useful. It's free!

This app also has other cool features like the ability to share your images to Whatsapp, Instagram, Facebook, Twitter, Viber, Tango and other popular social networks! Click on the Share button to do this!

Description

Virtual Data Cable is a tool to transfer and manager files (copy/cut/paste/delete etc.) between computer and phone without the USB data cable.

With this fantastic app installed:
* No need to carry the USB data cable for file transfer
(Drag and drop the files/folders between PC and phone)
* No need to mount and unmount the SD card frequently
* Protect your USB interface on the phone

This app is simple to use, three steps make it all:
1:Let your computer and phone are connected to the same WIFI network.
2:Open this tool then you can see a ftp address.
3:Open "Windows Browser" (or Internet Browser") on your computer and input the ftp address

Now the computer will be connected with the phone. You can transfer the files/folders (copy/cut/paste/delete etc.) freely and fastly.

FAQ:
1. I don't know how to use this app, how it works?
This app works when your computer and phone are connected to the same WIFI network.
2. Why can't I just drag and drop the files/folders?
Open your "Internet Browser" on computer, Click and choose "Tools" -> "Internet Options" -> "Advanced", Check the option "Enable folder view for FTP sites".
3. Can I use a FTP client to connecte with it?
Yes,You can use free FTP client such as "FilleZilla" to connect.
4. Can my MAC be connected with my phone?
yes. You'll need a FTP client software(such as the free FileZilla) on your MAC to connect to the phone.
5. Why it's slow to transfer hundreds of small files?
The windows FTP (with drag/drop) only allows one session. It's better to use a FTP client (such as the free FileZilla below which can support 10 sessions) to get a 10x faster speed.

tag：swiftp ftp Software Data Cable File manager File Expert ES File Explorer

A class room explanations about integrity constraints in oracle from

   Mr ramu dayinaboyina dept of computing                                                    page 1/2

      Create table emp1(empno number(5) not null , ename varchar2(15) );

      Alter table emp1 modify(ename varchar2(15) not null);

      Alter table emp1 modify(ename varchar2(15) null);

      Create table emp1(empno number(5) not null , ename varchar2(15), doj date default sysdate );

      Create table dept1(deptno number constraint check_deptno  check(deptno between 10 and 99),dname varchar2(9) constraint check_dname  check(dname=upper(dname)), location varchar2(10) constraint check_loc check(loc in(‘dallas’,’bostan’,’newyork’,’chicago’)));

      Create table dept1(deptno number(2) constraint unique_dname unique , dname varchar2(20));

      Alter table dept1 add constraint unq1 unique(dname);

      Alter table dept1 drop constraint unq1 ;

      Create table dept1(deptno number(2), dname varchar2(20), loc varchar2(10),   constraint unique_dname unique(deptno , dname ));

      Create table dept1(deptno number(2) constraint pk_dept primary key , dname varchar2(20));

SQL CHECK Constraint

The CHECK constraint is used to limit the value range that can be placed in a column.

If you define a CHECK constraint on a single column it allows only certain values for this column.

If you define a CHECK constraint on a table it can limit the values in certain columns based on values in other columns in the row.

SQL CHECK Constraint on CREATE TABLE

The following SQL creates a CHECK constraint on the "P_Id" column when the "Persons" table is created. The CHECK constraint specifies that the column "P_Id" must only include integers greater than 0.

SQL Server / Oracle / MS Access:    CREATE TABLE Persons
(   P_Id int NOT NULL CHECK (P_Id>0),
LastName varchar(255) NOT NULL,
FirstName varchar(255),Address varchar(255),  City varchar(255)
)

To allow naming of a CHECK constraint, and for defining a CHECK constraint on multiple columns, use the following SQL syntax:                                                                    page 2/2

MySQL / SQL Server / Oracle / MS Access:

CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
CONSTRAINT chk_Person CHECK (P_Id>0 AND City='Sandnes')
)

SQL CHECK Constraint on ALTER TABLE

To create a CHECK constraint on the "P_Id" column when the table is already created, use the following SQL:

MySQL / SQL Server / Oracle / MS Access:

ALTER TABLE Persons ADD CHECK (P_Id>0)

To allow naming of a CHECK constraint, and for defining a CHECK constraint on multiple columns, use the following SQL syntax:

MySQL / SQL Server / Oracle / MS Access:

ALTER TABLE Persons  ADD CONSTRAINT chk_Person CHECK (P_Id>0 AND City='Sandnes')

To DROP a CHECK Constraint  To drop a CHECK constraint, use the following SQL:

SQL Server / Oracle / MS Access:

ALTER TABLE Persons  DROP CONSTRAINT chk_Person

MySQL:

ALTER TABLE Persons  DROP CHECK chk_Person

reserved post

REMOTE KEYBOARD FOR THE ANDROID PHONES

Description

Tired of onscreen keyboards? Rather want to type your Whatsapp and/or SMS messages on your desktop keyboard than on your phone? Then Remote Keyboard is the app for you!

Remote Keyboard allows you to connect your desktop computer's keyboard via wlan (can be forwarded over USB via ADB) to your android device and control it comfortably through any telnet client.

FEATURES:
* Copy&Paste text from Droid to PC and vice versa.
* Share text with the app to automatically send it to the client.
* Emoji support through word substitution (requires a Jelly Bean device with the according fonts; Definition lists available on the website).
* Build in ROT13 scrambler.
* Put favorite apps on Speeddial (launch them with the function keys).
* Password protection

USAGE:
After installing the Remote Keyboard on your device, you must enable it as an input method. The app will guide you through the process.

On the PC side, you will need a telnet client to make the connection. Telnet comes pre installed on all major operation systems. Windows users (Vista and later), however, need to explicitly enable it via the control panel or (preferably) install a 3rd party telnet client like PuTTY.

Remote Keyboard is free and open source software. For more information, sideloading options or to spend me a coffee, please visit my website.

Description

This app lets you see in the dark!

Take photos and record video even in low light environments.

Ever wanted to take photos or record video but couldn't because there was not enough light? Now you can with this free Night Vision Spy Camera app.

You will find this app very useful. It's free!

This app also has other cool features like the ability to share your images to Whatsapp, Instagram, Facebook, Twitter, Viber, Tango and other popular social networks! Click on the Share button to do this!

Description

Virtual Data Cable is a tool to transfer and manager files (copy/cut/paste/delete etc.) between computer and phone without the USB data cable.

With this fantastic app installed:
* No need to carry the USB data cable for file transfer
(Drag and drop the files/folders between PC and phone)
* No need to mount and unmount the SD card frequently
* Protect your USB interface on the phone

This app is simple to use, three steps make it all:
1:Let your computer and phone are connected to the same WIFI network.
2:Open this tool then you can see a ftp address.
3:Open "Windows Browser" (or Internet Browser") on your computer and input the ftp address

Now the computer will be connected with the phone. You can transfer the files/folders (copy/cut/paste/delete etc.) freely and fastly.

FAQ:
1. I don't know how to use this app, how it works?
This app works when your computer and phone are connected to the same WIFI network.
2. Why can't I just drag and drop the files/folders?
Open your "Internet Browser" on computer, Click and choose "Tools" -> "Internet Options" -> "Advanced", Check the option "Enable folder view for FTP sites".
3. Can I use a FTP client to connecte with it?
Yes,You can use free FTP client such as "FilleZilla" to connect.
4. Can my MAC be connected with my phone?
yes. You'll need a FTP client software(such as the free FileZilla) on your MAC to connect to the phone.
5. Why it's slow to transfer hundreds of small files?
The windows FTP (with drag/drop) only allows one session. It's better to use a FTP client (such as the free FileZilla below which can support 10 sessions) to get a 10x faster speed.

tag：swiftp ftp Software Data Cable File manager File Expert ES File Explorer