I think we have over 50Tb of data if it matters. Yes, I work with very very large and complex EHR database, thousands of tables and it is on remote server but on very fast network. In fact our other team was going to purchase TOAD and I begged them to try SQLDev explaining that it is very different from version 1 which everyone hated and that it works great now and became a really mature tool. sorry if my message did not come across well – i am a big fan of your blog and we all really appreciate your team’s work improving SqlDev. SELECT object_type type, owner, object_name, null column_name, null column_id, null data_type WHERE object_type ='VIEW' and object_name not like 'BIN$%' and rownum <=50 WHERE object_type ='TABLE' and object_name not like 'BIN$%' and rownum <=50 SELECT object_type type, null, object_name, null column_name, null column_id, null data_type SELECT ‘SCHEMA’ type, username owner, username object_name, null column_name, null column_id, null data_type If it did more like this, then it would work: Select ‘TABLE’ type, ”||o.owner# owner, name object_name, null column_name, null column_id, null data_typeĪnd owner# in (SYS_CONTEXT('USERENV','SESSION_USERID'))Īt the top of the select that SQL Developer is running? Most schemas I have ever worked with have well over 500 tables. However they are ordered correctly when there are not that many tables that have to be returned. When I run that select in SQL Developer, then the results come in owner# order, which is definitely not the order that I want them to be in. There must be some ordering done after the select (the one from sys.obj$), because the select itself has no order by. So, the problem has to do with too many hits I think. Now look what happens when I add an ‘F’ to that select: Please have a look at this screenshot from schema grl201504: You don’t see this behaviour becauseġ) You only have 2 tables that start with ‘pers’ andĢ) You don’t have many schemas with tables that start with ‘pers’ If you can’t get the popup to ‘pop up’ when you want it to, you can always ask for it manually with the keyboard shortcut.Ĭtrl + Space to get your insight to popup 'on demand' If I type the same thing and add a SPACE after the WHERE, I’ll get the regular parsing and guessing what you want next items. If I type ‘SELECT…WHERE’ and stop, I’ll see history items. What you see will depend on when you rest the keyboard and where. This is very subtle, and it took me a while to figure it out. The developer wins! It’s all in the wrist Instead of having to type out your joins manually, it’s nice that SQLDev can complete those for you now. Let’s pretend that you have a database that is ‘missing’ foreign keys – crazy, I know. This is a REALLY nice touch and isn’t something I’ve seen in other database IDEs before. Turn it off, turn it off! SQLDev can ‘think’ for you… Love how it offers JOINS for me too! …or SQLDev can ‘remember’ for you But also, rest assured that you can disable this feature in SQL Developer. If you fall in the NOTEPAD – ‘do not put anything into the editor which I do not type myself’ camp, then I feel sorry for you. I don’t want to get into a debate over whether this makes us lazier AND dumber, but I DO want to give you a quick overview of what SQL Developer can do in this area. Regular internet folks are already used to having search terms and URLs auto-completed in their browsers. Most third generation language ( 3GL) IDEs have trained hackers like me to expect the tool to write some of the code for them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |