Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by Ankitha Reddy
Page 4 of 5
How can I check how much time MySQL query, without printing it on the console, is taking?
To check this we need to have the profiling information which indicates resource usage for the statements executed during the course of the current session. Profiling information can get by SHOW PROFILE and SHOW PROFILES statement. Before running these statements, the profiling session variable must be set to 1 as follows − mysql> set profiling = 1; Query OK, 0 rows affected (0.00 sec) Now if we will run SHOW PROFILES statement then it will display the list of most recent statements sent to the server along with the duration and query id. mysql> show profiles; +----------+------------+--------------------------------------+ ...
Read MoreWhat is object slicing in C++ or Java?
Object slicing is used to describe the situation when you assign an object of a derived class to an instance of a base class. This causes a loss of methods and member variables for the derived class object. This is termed as information being sliced away. For example, class Foo { int a; }; class Bar : public Foo { int b; }; Since Bar extends Foo, it now has 2 member variables, a and b. So if you create a variable bar of type Bar and then create ...
Read MoreWhat happens if the output of MySQL TIMEDIFF() function surpass the range value of TIME field?
As we know that the range of TIME field in MySQL is ‘-838:59:59’ to ‘838:59:59’. Now, if TIMEDIFF() function’s output surpasses this range then MySQL will return either ‘-838:59:59’ or ‘838:59:59’ depends upon the values of the argument. Example mysql> Select TIMEDIFF('2017-09-01 03:05:45', '2017-10-22 03:05:45')AS 'Out of Range TIME Difference'; +------------------------------+ | Out of Range TIME Difference | +------------------------------+ | -838:59:59 | +------------------------------+ 1 row in set, 1 warning (0.00 sec) mysql> Select TIMEDIFF('2017-10-22 04:05:45', '2017-09-01 03:05:45')AS 'Out of Range ...
Read MoreHow can we count a number of unique values in a column in MySQL table?
By using DISTINCT keyword along with column name as the argument of COUNT() function we can count the number of unique values in a column. The syntax is as follows − SELECT COUNT(DISTINCT Col_name) FROM table_name; Example Suppose we have the following table mysql> Select * from tender; +----------+--------------+--------------+-------+ | clientid | client_Fname | Client_Lname | value | +----------+--------------+--------------+-------+ | 100 | Mohan | Kumar | 60000 | | 101 | Sohan ...
Read MoreDifference between HashMap and HashTable in Java.
HashMap is non-syncronized and is not thread safe while HashTable is thread safe and is synchronized. HashMap allows one null key and values can be null whereas HashTable doesn't allow null key or value. HashMap is faster than HashTable. HashMap iterator is fail-safe where HashTable iterator is not fail-safe. HashMap extends AbstractMap class where HashTable extends Dictionary class.
Read MoreWhat are the different build tools in Java?
"On a mean, a developer spends a considerable quantity of your time doing mundane tasks compiling the code, packaging the binaries, deploying the binaries to the checkserver, testing the changes," copying the code from one location to another. To automate and simplify these tasks we can use build tools like Ant, Maven, Gradle etc.
Read MoreGenerating SAP ABAP code/ script from XML coming from an external application
Yes, this is feasible. You can create simple transformation for XML in ABAP. You can also use cl_proxy_xml_transform to transform data between XML and ABAP. Let us say that you have created ABAP proxy using T-Code: SPROXY or it is generated via WebService generation utility, you can use utility class “cl_proxy_xml_transform” to convert data of the ABAP to XML format or also from XML → ABAP.
Read MoreGetting an error message Object already exported, no package change is possible while changing a package for 250 SAP development objects
This problem commonly occurs when you move development objects from Transportable enabled package to non-Transportable package. You can resolve this issue by following steps − You need to migrate legacy package using report RS_MIGRATE_PACKAGES. Check SAP Note: https://launchpad.support.sap.com/#/notes/1711900Then legacy package' will be removed, but the package will be still non-transportable. You can recreate package after migration. Next is to delete non Transportable package and create a copy of non TMS package. Next step is to assign all development objects to package created in the previous step using report RSWBO052. You use this program “RSWBO052” (Change Object Directory Entries) to ...
Read MoreMoving SAP client from one system to other
You can also create a copy of the existing clients between local and remote system IDs. Follow the below steps to create a copy of existing clients − Step 1 − To create a copy of a client in local SID, the transaction code is SCCL. Step 2 − Enter the following details − Select your desired profile, enter source client, and enter description. Step 3 − By default, the client copy is executed in a single process and you can distribute the workload on multiple processes to reduce time for copying. Step 4 − Copying a ...
Read MoreDefining a variable reference in SAP ABAP
As per my understanding, it is not feasible. You can access local class dynamically but statically referring to it in another class seems impossible. You might think about calling methods as dynamic in this case.
Read More