In this article I will show you how to view stored procedure/function definition using DataGrip tool.
WakaTime for DataGrip The open source plugin for productivity metrics, goals, leaderboards, and automatic time tracking. DataGrip is a multi-engine database environment. It supports MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2. It includes an editor that provides intelligent coding assistance for editing SQL code such as auto-completion, analysis and navigation. I started to use Datagrip for my PL/SQL (school) projects that need the use of DBMSOUTPUT.PUTLINE. Before this I was using Oracle SQL developer and I was able to use DBMSOUTPUT by adding the fol. Lookup Results for Phone Numbers in 519-436-xxx. Owner: Click to see owner. Carrier: Bell canada Type: Landline. Page: Basics: DataGrip Web Help Page: DataGrip previous releases Page: FAQ Page: Third party tutorials. 22 Comments Anonymous. Will the features of dbe merged into IDEA. Permalink; Jun 19, 2014; Alexander Chernikov. All features of DBE are available in IDEA. Permalink; Jul 10, 2014.
In toolbar navigate to View -> Tool Windows -> Database or press Alt + 1 key combination.
Fig.1. Database in View menu
In opened explorer expand [your database], [your schema] and routines branch. Find interesting procedure/function, than right click on it and select SQL Scripts.
Fig. 2. SQL Scripts options
In SQL Scripts select one of the following:
Source Editor - to open trigger code with all properties statements in editor
SQL Generator… - to open SQL Generator window, which allows generate different types of SQL (e.g. routine definition)
Fig. 3. SQL Generator window and options
Request and Copy Original DDL - to copy only routine DDL statement without additional statements (only CREATE PROCEDURE / CREATE FUNCTION)
Generate DDL to Clipboard - to copy routine DDL statement with additional statements (like exec sp_addextendedproperty in SQL Server)
Generate DDL to Console - to open routine DDL statement with additional statements in database console
JetBrains released a new version of DataGrip that includes support for MongoDB and ships with the MongoDB Shell out of the box.
A few months ago, JetBrains released the first version of DataGrip that supports MongoDB. DataGrip is a professional DataBase IDE and is a great tool for advanced data exploration and analytical queries for your data in MongoDB and Atlas.
If you use any of the other JetBrains commercial products for development (e.g. IntelliJ, PhpStorm, PyCharm), you can install the Database Tools plugin and work with MongoDB right inside your IDE.
As we announced last week at MongoDB.live, the MongoDB plugin in DataGrip and in the other JetBrains IDE now includes a database console built on top ofthe MongoDB Shell. This is the result of a close collaboration between engineering teams at MongoDB and JetBrains and we are excited to finally release it to all our users.
With this integration, when you connect to MongoDB and Atlas with DataGrip, you get a console/shell experience that is 100% consistent with what you get in the terminal or in the other MongoDB’s developer tools.
DataGrip and Atlas
When your data is stored in Atlas, navigating through it with DataGrip is extremely easy.
For example, to connect to my free Atlas cluster, I can just grab a connection string from the Atlas UI, use it to add a new data source in DataGrip and I am connected and ready to explore my data.
Using Consoles
If you need to run queries, aggregations, or other database commands, consoles are a great way to do that.
The engineering teams at JetBrains and at MongoDB worked together to bring the new, embeddable MongoDB Shellto DataGrip and use it as the engine behind database consoles. This means the same commands that you can run in the MongoDB Shell are available in DataGrip and the other JetBrains IDEs and you can expect them to work exactly in the same way with the addition of the beautiful UI you are already used to on top.
A great fit for Atlas Data Lake
DataGrip works well MongoDB deployments, whether self-managed or in Atlas. You can also use it with Atlas Data Lake. If you have data is stored in Amazon S3 and you want to query and analyze it with MQL, you can create a Data Lake and start working with it right away.
Jetbrains Sql
DataGrip’s search capabilities give you a quick way to find the data you are interested in, and its powerful export tool makes it easy to extract it in the format you need to use it with other tools like Excel, for example.
Get started with MongoDB Atlas and DataGrip
We are really happy with the result of our collaboration with the team at JetBrains and we are looking forward to working more together to bring all the future capabilities of the MongoDB Shell to DataGrip and the other JetBrains IDEs.
Datagrip Download
You can experience for yourself how DataGrip is a perfect companion for MongoDB Atlas:
Datagrip Community Edition
Get a free MongoDB Atlas cluster;
Deploy some sample datasets;
Download DataGrip and start working with your data immediately.