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
Articles by Monica Mona
Page 6 of 7
In MySQL, how to remove the specific prefix from entire column’s value and update them?
It can be done by applying TRIM() function on the column along with MySQL UPDATE statement. The example below will make it more clear.ExampleSuppose, we have a table ‘Employee’ which have the prefix ‘Dept.’ with all the values of Column ‘Department’ as follows −mysql> Select * from Employee; +------+----------------+------------+----------------------+ | Id | Name | Address | Department | +------+----------------+------------+----------------------+ | 100 | Raman | Delhi | IT Dept. | | 101 | Mohan ...
Read MoreHow can we use WHERE condition when creating a table with CTAS (Create Table as Selected) script?
As we know that we can copy the data and structure from an existing table by CTAS script. Use of WHERE clause is demonstrated in the example belowmysql> Create table EMP_BACKUP2 AS SELECT * from EMPLOYEE WHERE id = 300 AND Name = 'Mohan'; Query OK, 1 row affected (0.14 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> Select * from EMP_BACKUP2; +------+-------+ | Id | Name | +------+-------+ | 300 | Mohan | +------+-------+ 1 row in set (0.00 sec)In the example above, we have created a table named EMP_BACKUP1 from table ‘Employee’ with some conditions. MySQL creates the table with only one row based on those conditions.
Read MoreDifference between SAP Crystal Reports and CR for Visual Studio
Crystal Reports for Visual Studio 2010 comes free and you can develop as many reports and can host runtime engine without any cost. Now Crystal Reports has been excluded from Visual Studio by default and you need to download it free from SAP site.You can use the following link for downloading CRforVS: http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_13_0.exeSystem RequirementsDetailsProduct PrerequisitesMicrosoft Visual Studio 2010Processor1.6 GHz or fasterMemory1GB (32-bit) or 1.1GB (64-bit) availableOperating systemsWindows 2003, Windows Vista PlatformSupportWindowsOnce you install this, you can still create a new Crystal Report Design in Visual Studio by navigating to the below path:Solution Explorer -> Right click on the Project name ...
Read MoreHow to Fetch source code of the transaction note in SAP R/3?
If you ever need to fetch the mapped program with a transaction, you need to call the transaction SE93. It will fetch you the program and variant of the selection screen.Now, if you need source code then you can use the transaction SE38 or SE80. If you also require Dynpro which is mapped against the program then use SE80.
Read MoreAre MySQL database and table names case-sensitive?
Actually, the case sensitivity of database and table name depends a lot on the case sensitivity of the underlying operating system. Hence, we can say that such names are not case sensitive in Windows but are case sensitive in most varieties of Unix.
Read MoreWhat does the bitwise left shift operator do in Java?
The left operand value is moved left by the number of bits specified by the right operand.Example: A
Read MoreCan constructors be inherited in Java?
No, constructors cannot be inherited in Java. In inheritance sub class inherits the members of a super class except constructors. In other words, constructors cannot be inherited in Java therefore, there is no need to write final before constructors. Example public interface InterfaceTest { public InterfaceTest(){ } public abstract void display(); public abstract void show(); } Still, if you try to write constructors in an interface it will generate a compile time error. Error C:\Sample>javac InterfaceTest.java InterfaceTest.java:2: error: expected InterfaceTest(){ ^ 1 error C:\Sample>
Read MoreHow can I check the list of existing authority objects in SAP system?
To maintain authorization objects, you can use T-code: SU21 in SAP ECC system.You can all authorization objects including S_CARRID is located inside the different class like - BC_C object class.
Read MoreWhat is Agentry Toolkit in SAP Mobile Platform SMP 3.0 SDK? How do you use it in an application?
Agentry toolkit provides various SDK’s to integrate with the various mobile component. With Agentry toolkit, you have a plugin to Eclipse that allows you to create modify Agentry applications.To know more about Agentry toolkit, you can refer the below SAP link:https://help.sap.com/doc/f1944845cb7b4cb886ebfbd5fa720c64/3.0.14/en-US/7c03a69470061014a336f33ca4dd4413.html
Read MoreHow to use EXPORT / IMPORT to Memory ABAP – SAP?
As per your requirement, you are utilizing ABAP memory to transfer data to background session from session of the user. It will not work as per the standard documentation. RFC or updates module will run in different user sessions with different ABAP memory and hence it will not be possible.
Read More