I have recently started using Oracle. In last few Years I had used SQL server and used a tool called 'RedGate SQL Search' and foundto be very useful while maintaining projects with huge database size.
I need an equivalent tool for Oracle , Anyone having any idea?
1 Answer
I suggest you try PL SQL Developer I have used it too much, I have used RedGate tools also too much, the tool I mentioned for Oracle Database has most of features of 'Red Gate SQL Search' for Oracle and in some cases it has some different and better features.
Not the answer you're looking for? Browse other questions tagged sqloraclesql-server-2008redgate or ask your own question.
From CYNNEL Software:What do you need to know about free software?
Born | Ríoghnach Robinson |
---|---|
Occupation | Author |
Nationality | American |
Alma mater | Kenyon College(economics) |
Period | 2016–present |
Genre | Young adult fiction |
Notable works |
|
Website | |
rileyredgate.com |
Riley Redgate is the pen name of Ríoghnach Robinson (/ˈriːənɒk/), an American author of young adult fiction.[1]
Life and career[edit]
Robinson was raised in Winston-Salem, North Carolina. She attended Richard J. Reynolds High School,[1] where she began her first novel, Seven Ways We Lie.[2] She is an alumna of Kenyon College in Gambier, Ohio, where she majored in economics,[1] graduating in 2016.[3] Her debut novel was published before she graduated.[2] While at Kenyon, Robinson won the college's James E. Michael Playwriting Award for her play Mourning Sickness.[2]
Robinson worked from Chicago as writing apprentice for the satirical media outlet The Onion.[4][5] Her three novels are Seven Ways We Lie (2016), Note Worthy (2017), and Final Draft (2018),[6] all published by Amulet, an imprint of Abrams Books.[7][8][9]
Robinson is bisexual, of half-Irish and half-Chinese descent, and the characters in her novels similarly lie 'in the middle of a spectrum rather than out at the ends'.[10]
Pen name[edit]
Robinson choose the pseudonym Riley Redgate when she was 16 years old, brainstorming it with the help of other members of a writers' forum. Her composition criteria consisted of three things: she wanted to keep her real initials; something gender neutral; and something easily pronounceable.[11]
Works[edit]
- Seven Ways We Lie (2016)[2][7]
- Note Worthy (2017)[8]
- Final Draft (2018)[9][12]
References[edit]
- ^ abcSchehl, Pam (May 9, 2016). 'Kenyon student-author visits MVHS'. Mount Vernon News.
- ^ abcdK. Norcross Watts (July 14, 2016). 'Seven Ways We Lie explores 'grimy' adolescence'. JournalNow. Winston-Salem Journal.
- ^'Class of 2016: Plans for After Graduation'. Kenyon College.
- ^'Riley Redgate' on WriteOnCon
- ^'Contact the Onion' (archived on Wayback Machine) on The Onion
- ^Redgate, Riley (June 12, 2018). 'Interview: Riley Redgate, author of 'Final Draft''. Happy Ever After (Interview). Interviewed by Joyce Lamb. USA Today.
- ^ ab'Seven Ways We Lie'. Kirkus Reviews. December 8, 2015. Retrieved December 3, 2018.
- ^ ab'Note Worthy'. Kirkus Reviews. March 6, 2017. Retrieved December 3, 2018.
- ^ ab'Final Draft'. Kirkus Reviews. April 30, 2018. Retrieved December 3, 2018.
- ^Redgate, Riley (2016). 'On rounding'. Diversity in YA.
- ^'Audio Name Pronunciation with Riley Redgate' on TeachingBooks.net
- ^Heppermann, Christine (August 6, 2018). ''Final Draft' by Chicago's Riley Redgate leads this week's Y.A. fiction roundup'. Chicago Tribune.
External links[edit]
- Official website
What are your favorite SSMS addons?
I've recently started delving into SSMS Addons.
I'm really loving RedGate SQL Prompt 5 (refactoring/better intellisense), though it's spendy.. the trial is going swimmingly. http://www.red-gate.com/products/sql-development/sql-prompt/
With that I like RedGate SQL Search (Free) http://www.red-gate.com/products/sql-development/sql-search/
and
RedGate Tab Magic: http://www.red-gate.com/products/sql-development/sql-prompt/entrypage/sqltabmagic also free and a godsend.
That said, other nice tools:
SSMS Tools Pack: http://www.ssmstoolspack.com/
Or as free (but not as nice as RedGate's offerings, IMHO)(They 'seemed' slower and I like RedGate's code formatting better, I never could tune Apex Complete's to be just how I wanted it...even though there were vastly more options...) are the ApexSQL Free tools:
http://www.apexsql.com/products.aspx (Apex Complete, Apex Refactor, Apex Search)
Does anyone else have any 'must have' tools for SSMS they'd like to share?
I know it's possible, but don't know how.
I need to search Microsoft SQL database for all mentions of specific string.For example: I would like to search all tables, views, functions, stored procedures, ... for string 'tblEmployes'. (Not data within the tables)
One of the reasons I need this, I would like to remove some extra data tables that are created, but I am afraid that they are maybe used somewhere in procedures or functions.
Any help is appreciated.
15 Answers
this will search every column of every table in a specific database. create the stored proc on the database that you want to search in.
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1#2:
to run it just do this:
works amazingly well!!!
If you need to find database objects (e.g. tables, columns, triggers) by name - have a look at the FREE Red-Gate tool called SQL Search which does this - it searches your entire database for any kind of string(s).
It's a great must-have tool for any DBA or database developer - did I already mention it's absolutely FREE to use for any kind of use??
You can also try ApexSQL Search – it’s a free SSMS add in similar to SQL Search.
If you really want to use only sql you might want to try this script
For getting a table by name in sql server:
for finding a stored procedure by name:
to get all stored procedures related to a table:
You can export your database (if small) to your hard drive / desktop, then just do a string search via text search program or text editor.
This code searching procedure and function but not search in table :)
you could;
- Script the database to a single file and search the file for tblEmployees using a texteditor. In SQL Server Management Tools (SSMS) right click over the database and choose Generate Scripts.
- Use SSMS 'View Dependancies' by right clicking over tblEmployees to see which other objects are dependant on it
- Use a free 3rd party tool such as RedGate SQLSearch to search all database objects by name and content by keyword.
This will search for a string over every database:
Old question, I know, but here goes my version... I named it 'Needle in the haystack' for obvious reasons.
It searches for specific value in each row and each column, not for column names etc.
Execute search (replace values for first two variables of course):
Then to view results, even while executing, from another window, execute:
Few mentions about it:
- it uses cursors instead of a blocking while loop
- it can print progress (uncomment if needed)
- it can exit after a few attempts (uncomment the IF at the end)
- it displays all records
- you can fine tune it as needed
DISCLAIMERS:
- DO NOT run it in production environments!
- It is SLOW. If the DB is accessed by other services/users, PLEASE add ' WITH (NOLOCK) ' after every table name in all the selects, especially the dynamic select ones.
- It does not validate/protect against all sorts of SQL injection options.
- If your DB is huge, prepare yourself for some sleep, make sure the query will not be killed after a few minutes.
- It casts some values to string, including ints/bigints/smallints/tinyints. If you don't need those, put them at the same exclusion lists with the timestamps at the top of the script.
Hope this helps.
Was given access to a database, but not the table where my query was being stored in.
Inspired by @marc_s answer, I had a look at HeidiSQL which is a Windows program that can deal with MySQL, MSSQL and PostgreSQL.
Found that it can also search a database for a string.
Sql Redgate Search Tool
It will search each table and give you how many times in found the string per table!
The content of all stored procedures, views and functions are stored in field text of table sysComments. The name of all objects are stored in table sysObjects and the columns are in sysColumns.
Having this information you can use this code to search in content of views, stored procedures and functions for the specified word:
This query will give you the objects which contains the word 'tblEmployes' .
To search by the name of Objects you can use this code:
and finally to find the objects having at least one column containing the word 'tblEmployes' you an use this code:
You can combine this 3 queries with union :
With this query you have all objects containing the word 'tblEmployes' in content or name or as a column.
Here is the same script as submitted by user l--'''---------'''''', but corrected to work on a case-sensitive SQL instance, and with some other minor improvements.
Searching SQL Database objects is possible with SQL Server Management Studio with following methods, with SSMS Object Search: object explorer details or T-SQL Scripts as explained in following:
Here How you can search Database in Swift using FMDB Library First go this link and add this to your project FMDB When you Done that then here How you do it for example you have a table called Person and you have firstName and secondName and you want to find data by first name Here is a code for that
Then in your ViewController you will Write this to fond the Person Detail you are looking For
Supposing you won't do a public search in a whole database and you just want to find a keyword by your own, this is the simplest, cleaner and faster solution.
Dump your database to a file.
Do a grep on that file
And you're done.
protected by Community♦Jun 5 '16 at 6:55
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?