Usharani has Published 76 Articles

How many packages and classes are there in Java Standard Edition 8?

usharani

usharani

Updated on 18-Feb-2020 10:48:17

1K+ Views

Java Standard Edition provides 14 packages namely –applet − This package provides classes and methods to create and communicate with the applets.awt− This package provides classes and methods to create user interfaces.beans− This package contains classes and methods to develop components based on java beans. io− This package contains classes and ... Read More

Getting age of tracefiles in SAP HANA database

usharani

usharani

Updated on 13-Feb-2020 12:40:44

312 Views

In SAP HANA database, you have diagnosis files include log and trace files, a mixture of other diagnosis, error, and information files.These files can be checked for diagnosis to find errors in SAP Hana database.In HANA db, you have trace files stored separated per host, so to get access to ... Read More

Use of String.compare for a varchar field in SAP

usharani

usharani

Updated on 13-Feb-2020 12:36:25

107 Views

Try to use SqlFunctions.DateDiff method overload which requires 3 inputs as follows −var res = from a in db.Set() where SqlFunctions.DateDiff("dd", a.Date, "20161922") >= 0 && SqlFunctions.DateDiff("dd", a.Date, "20161122") < 0 select a

Usage of direction property in CSS

usharani

usharani

Updated on 31-Jan-2020 06:03:46

81 Views

The direction property is used to set the text direction. Possible values are ltr or rtl.ExampleYou can try to run the following code to set the text direction with CSS:                            This text will be renedered from right to left          

Usage of font-size property in CSS

usharani

usharani

Updated on 30-Jan-2020 10:22:35

165 Views

The font-size property is used to increase or decrease the size of a font. The font-size property is used to control the size of fonts. Possible values could be xx-small, x-small, small, medium, large, x-large, xx-large, smaller, larger, size in pixels or in %.             ... Read More

CSS Measurement Units

usharani

usharani

Updated on 30-Jan-2020 08:25:48

288 Views

CSS supports a number of measurements including absolute units such as inches, centimeters, points, and so on, as well as relative measures such as percentages and em units. You need these values while specifying various measurements in your Style rules.The following are the CSS Measurement Units along:UnitDescriptionExample%Defines a measurement as ... Read More

How does MySQL handle out of range numeric values?

usharani

usharani

Updated on 30-Jan-2020 06:59:14

716 Views

Handling of MySQL numeric value that is out of allowed range of column data type depends upon the SQL mode in following ways −(A) Enabled SQL strict mode - When strict SQL mode is enabled, MySQL returns the error on entering the put-of-range value. In this case, the insertion of some ... Read More

How can we fetch month and day from a given date in MySQL?

usharani

usharani

Updated on 30-Jan-2020 05:37:11

170 Views

It can be done inflowing two ways −(A) With the help of EXRACT() function - EXTRACT() function can fetch any part from MySQL TIMESTAMP value. Following is the example of fetching month and day from a given date.mysql> Select EXTRACT(Month from '2017-10-22') AS 'MONTH'; +-------+ | MONTH | +-------+ | ... Read More

What MySQL returns on using any other character than ‘T’ or ‘Space’ between date and time parts?

usharani

usharani

Updated on 29-Jan-2020 06:48:45

80 Views

In that case, MySQL will return all zeros at the place of time along with correct date part. An example is as follows in which we used character ‘W’ at the place of ‘T’ or ‘Space’ between date and time part −mysql> Select TIMESTAMP('2017-10-20W06:10:36'); +----------------------------------+ | TIMESTAMP('2017-10-20W06:10:36') | +----------------------------------+ | ... Read More

How can we provide a date with only year (zero months & zero days) value in MySQL?

usharani

usharani

Updated on 28-Jan-2020 12:25:52

237 Views

We can store a date with only year value and have zero months as well as zero-days in MySQL table by disabling NO_ZERO_IN_DATE mode. If this mode is enabled then MySQL will count such kind of date as invalid date and stores all zeros.mysql> Insert into year_testing (OrderDate) values('2017:00:00'); Query ... Read More

Advertisements