
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
2K+ Views
You can use WAIT to hold the program for few seconds. Here is the syntaxSyntaxWAIT UP TO 36 SECONDSHowever, you need to be careful about using it. WAIT does an implicit commit. So you need to be sure that the commit does not corrupt the database. It also releases the ... Read More

Monica Mona
397 Views
In SAP HANA, you don’t have a concept of creating multiple databases in one container. To create a separate container for your database objects, you can create the schema in HANA db.To create a schema, you can use below SQL query −CREATE SCHEMA schema nameYou can also define as ... Read More

Monica Mona
379 Views
In order to extract data from tables, you need to follow steps:Create a View of the required table from where the data needs to be extracted or view over multiple joined tablesNavigate to Transaction SE11 and Select option 'View'. It will ask for a name, name it something like 'View_TableName'.Select ... Read More

Monica Mona
3K+ Views
If you need to identify the fields and number of fields in a structure, then you should use runtime type services. Using runtime type services makes more sense in this case as if we have some data in our environment, then it’s not ideal to call database for fetching the ... Read More

Monica Mona
885 Views
I think for your implementation, you can declare an internal table in a dynamic manner.DATA: tbl_TEST TYPE REF TO DATA. FIELD-SYMBOLS: < tbl_TEST > TYPE STANDARD TABLE CREATE DATA tbl_TEST TYPE (Received_Type) ASSIGN tbl_TEST TYPE ->* to < tbl_TEST TYPE >

Monica Mona
611 Views
We can run “SELECT @@AUTOCOMMIT” command to check the current transaction mode.mysql> Select @@AUTOCOMMIT; +--------------------+ | @@AUTOCOMMIT | +--------------------+ | 1 | +--------------------+ 1 row in set (0.05 sec) mysql> SET AUTOCOMMIT = 0; Query OK, 0 rows affected (0.00 sec) mysql> Select @@AUTOCOMMIT; +--------------------+ | @@AUTOCOMMIT | +--------------------+ | 0 | +--------------------+ 1 row in set (0.00 sec)

Monica Mona
600 Views
In C++, declaration and definition are often confused. A declaration means (in C) that you are telling the compiler about type, size and in case of function declaration, type and size of its parameters of any variable, or user-defined type or function in your program. No space is reserved in ... Read More

Monica Mona
3K+ Views
It is quite possible to use MySQL IF() function within SELECT statement by providing the name of the column along with a condition as the first argument of IF() function. To understand it, consider the following data from table ‘Students’.mysql> Select * from Students; +----+-----------+-----------+----------+----------------+ | id | Name ... Read More