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 George John
Page 29 of 79
How can I to know if my database MongoDB is 64 bits?
You can use buildInfo along with runCommand to check whether your MongoDB database is running on 32-bit or 64-bit architecture. The key field to look for in the output is "bits". Syntax use admin db.runCommand("buildInfo") Example First, switch to the admin database and then run the buildInfo command ? use admin db.runCommand("buildInfo"); switched to db admin The output will display detailed build information about your MongoDB instance ? { "version" : "4.0.5", "gitVersion" : "3739429dd92b92d1b0ab120911a23d50bf03c412", ...
Read MoreHow to create an index with MongoDB?
To create an index in MongoDB, use the createIndex() method (replaces the deprecated ensureIndex()). Indexes improve query performance by creating efficient data lookup structures. Syntax db.collection.createIndex( { field: 1 }, // 1 for ascending, -1 for descending { unique: true } // optional: index options ); Create Sample Collection db.createCollection("creatingUniqueIndexDemo"); { "ok" : 1 } Example: Creating ...
Read MoreClearing items in a nested MongoDB array?
To clear items in a nested MongoDB array, use the $set operator to replace the entire array field with an empty array []. This removes all elements from the specified array field. Syntax db.collection.update( { "matchField": "value" }, { $set: { "arrayField": [] } } ); Sample Data Let us create a collection with nested arrays ? db.clearingItemsInNestedArrayDemo.insertOne({ "StudentName": "John", "StudentDetails": [ { ...
Read MoreMongoDB query to return only embedded document?
While MongoDB doesn't return only embedded documents directly, you can use projection to return specific fields and the $elemMatch operator to filter array elements that match certain conditions. Syntax db.collection.find( { "arrayField.nestedField": { $gte: value } }, { "arrayField": { $elemMatch: { "nestedField": { $gte: value } } } } ); Sample Data db.queryToEmbeddedDocument.insertOne({ "UserName": "Larry", "PostDetails": [ { "UserMessage": "Hello", "UserLikes": 8 }, ...
Read MoreIncrement a value in a MongoDB nested object?
To increment a value in a MongoDB nested object, use the $inc operator combined with the $ positional operator to target the specific nested element and increment its numeric value. Syntax db.collection.update( {"nestedArray.field": "matchValue"}, { $inc: { "nestedArray.$.fieldToIncrement": incrementValue } } ); Create Sample Data Let us create a collection with a document containing nested array objects ? db.incrementValueDemo.insertOne({ "StudentName": "Larry", "StudentCountryName": "US", "StudentDetails": [ ...
Read MoreHow to create double nested array in MongoDB?
To create a double nested array in MongoDB, use insertOne() or insertMany() with documents containing arrays of objects that themselves contain arrays. A double nested array means an array within an array structure. Syntax db.collection.insertOne({ "field1": "value1", "outerArray": [ { "innerField": "value", "innerArray": [ ...
Read MoreDifference between strncmp() and strcmp() in C/C++
Both strncmp() and strcmp() are used in C/C++ programs for lexicographical string comparison. The strcmp() compares two strings till the null character is found, whereas strncmp() only compares a specified number of characters. What is strncmp() ? The function strncmp() is used to compare left string to right string up to a number. It works same as strcmp(). It returns a value greater than zero when the matching character of left string has greater ASCII value than the character of the right string. Returns a value less than zero when the matching character of left string has lesser ASCII value ...
Read MoreUsing "SPELL AMOUNT" function to convert amounts in ABAP
You can use the standard function module SPELL_AMOUNT in ABAP to convert numeric amounts into their corresponding word representations. This is particularly useful for financial documents, checks, and reports where amounts need to be displayed in written form. To access and explore this function module, use Transaction code SE37 (Function Builder) − Click on the Search icon and select Function module SPELL_AMOUNT − Key Parameters The SPELL_AMOUNT function module accepts several important parameters − ...
Read MoreChecking active process in SAP system and which code is running
There are a couple of transactions − SM66 and SM50 that can be used to check active processes in the SAP system and monitor which code is currently running. Transaction SM66 - Global Process Overview The transaction SM66 is used to see all the active processes across the entire SAP system landscape. This provides a comprehensive view of all work processes running on all application servers in your SAP environment. To monitor a specific process using SM66 − Select the particular process you want to monitor by clicking on the process entry ...
Read MoreEdit an ABAP Program using Transaction SE93, SE80
You need to go to SE93 and input your transaction code. It will display the program name behind your transaction code. You can edit the programs using SE80 and SE38 transaction codes. Using SE93 to Find Program Name Transaction code SE93 is used to maintain transaction codes and find the associated program names. This is the first step to identify which program you want to edit. Below shows Transaction code SE93 − Editing ABAP Programs Using SE80 − ABAP Development Workbench Transaction Code SE80 opens the ABAP ...
Read More