Java

Java Autoboxing and Unboxing with examples

Posted on

Java 1.5 introduced a special feature of auto conversion of primitive types to the corresponding Wrapper class and vice versa. Autoboxing: Automatic conversion of primitive types to the object of their corresponding wrapper classes is known as autoboxing. For example – conversion of int to Integer, long to Long, double to Double etc. Unboxing: It […]

Data Base

SQL Insert Command Different Types

Posted on

SQL Insert Command Different Types Different type of SQL command are used to perform same operation  need to use at different time as per our requirement.We can use them in the next example  we are going to create a table name as TEST and heaving the following command. Create Table command CREATE TABLE TEST(ID NUMBER(10),NAME […]

Data Base

Alter Command For Add Renaming Column

Posted on

Alter table command is used to modify the table structure we can add a column or modify column. Syntax ALTER TABLE table_name ADD column_name datatype eg-alter table test add mobile number(10); Modifying a column Syntax ALTER TABLE “table_name” RENAME COLUMN “column 1” TO “column 2”;

Data Base

Alter table Modify

Posted on

This command is used to alter table existing data type.By giving this command we can change the parameter of  an  table. ALTER TABLE table_name  MODIFY column_name column_type; alter table emp modify id number(20);

Data Base

Alter Table Drop A Column

Posted on

Syntax To DROP A COLUMN in an existing table, the Oracle ALTER TABLE syntax is: ALTER TABLE table_name  DROP COLUMN column_name; Example Let’s look at an example that shows how to drop a column in an Oracle table using the ALTER TABLE statement. For example: ALTER TABLE customers  DROP COLUMN customer_name; This Oracle ALTER TABLE […]

Selenium

Wait Statement in Selenium Different Types of Wait

Posted on

Wait Statement is used in selenium to make some delay and during that period of time we need to do something and or to wait for presence of element.We can make wait a website three types Implicit wait Explicit wait and Fluent Wait.All the waits statement are different function and different uses. Normal Wait-Thread .sleep(millisecond) […]

Selenium

How to Read From xlsx file In Maven Project By Apache Plugin and Dependency

Posted on

For reading files from the .xlsx file we need the following .jar files to be imported to the Build Path.Downloads the followings and import the version. poi-ooxml-3.11-beta2.jar poi-ooxml-schemas-3.11-beta2.jar xmlbeans-2.6.0.jar stax-api-1.0.1.jar If you are not using Maven then add following JAR files in your poi-3.11-beta2.jar commons-codec-1.9.jar poi-ooxml-3.11-beta2.jar poi-ooxml-schemas-3.11-beta2.jar xmlbeans-2.6.0.jar stax-api-1.0.1.jar Along with the l2wish.xlsx file. Set […]

Linux

Linux Command

Posted on

  Command Description cat [filename] Display file’s contents to the standard output device (usually your monitor). cd /directorypath Change to directory. chmod [options] mode filename Change a file’s permissions. chown [options] filename Change who owns a file. clear Clear a command line screen/window for a fresh start. cp [options] source destination Copy files and directories. […]

Linux

Root Login in Ubuntu Desktop 16.04

Posted on

The root Account in Ubuntu is disabled by default because his password is not set. But if you’d like to use root Account by some reason, it’s possible to use like follows. [1] The user account added during installation is set an administrative account with Sudo, so it’s easy to get root account’s shell like […]

Selenium

JDBC MySql Connection in Ubuntu

Posted on

Setting Up MySQL: Run the following command in the terminal: 123sudo apt-get install mysql-serversudo apt-get install mysql-clientsudo apt-get install libmysql-java This will install both in the most up to date version within your repositories. You will be prompted for a root password. You then need to login and setup the server. To do that, run […]