
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Monica Mona has Published 83 Articles

Monica Mona
104 Views
MySQL has function name REVERSE() with the help of which we can reverse the string. But suppose if we want to reverse the string connected by dash then by using REVERSE() function will not give appropriate result as shown in the following example:mysql> Select REVERSE('AB-CD-EF'); +---------------------+ | REVERSE('AB-CD-EF') | +---------------------+ ... Read More

Monica Mona
374 Views
MySQL ORD() function returns the code for the leftmost character if that character is a multi-byte i.e. sequence of one or more bytes, with the help of the following formula(1st bytecode) + (2nd bytecode * 256) + (3rd bytecode * 256^2)On the other hand, ASCII() function returns the ASCII value ... Read More

Monica Mona
2K+ Views
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; +------+----------------+------------+----------------------+ | ... Read More

Monica Mona
597 Views
As we know, both the functions are used to search a string from the arguments provided in them but there are some significant differences between them as followsFIND_IN_SET() function uses the string list that is itself a string containing the substring separated by commas. Whereas, LOCATE() function contains a string ... Read More

Monica Mona
228 Views
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 ... Read More

Monica Mona
346 Views
As we have checked the size of the MySQL database, similarly we can also check the size of tables in a particular database. It can be done as follows −mysql> SELECT -> table_name AS "Table", -> round(((data_length + index_length) / 1024 / 1024), 2) as SIZE ... Read More

Monica Mona
1K+ Views
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 ... Read More

Monica Mona
219 Views
You can troubleshoot by trying a telnet to SAP system.Open a command prompt on the system you are running your .net application and try to telnet server having SAP system installed.Telnet 127.0.0.1 3300If you using a local system, try using a hostname instead of loopback IP address and make an ... Read More

Monica Mona
375 Views
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 ... Read More

Monica Mona
184 Views
I think the question is very basic and if you would have explored a little bit, you would have found out the way.Just go and open transaction SE38, specify the include name and press create.Otherwise, you can open transaction SE80, select a packet and then the object name. That’s it.Read More