SQLDeveloper Sorcery – drag-and-drop in-lists.
source link: https://mikesmithers.wordpress.com/2022/05/21/sqldeveloper-sorcery-drag-and-drop-in-lists/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
SQLDeveloper Sorcery – drag-and-drop in-lists.
When I started my IT career, the programmer saw the world in monochrome.
The ability to exit vi was simply an essential survival skill.
Syntax highlighting was science fiction. As for code completion, suffice to say that I was moved to spend several hours learning to touch-type by that nice Mavis Beacon, so I didn’t have to spend so much time hunting down typos.
Whilst things have changed a bit over the years, I think the SQLDeveloper Development team may be cheating a bit by using “sourcery” (sorry !) …
Using this table to demonstrate :
create table code_editors (program_name varchar2(100), year_released number)/insert into code_editors( program_name, year_released)values('vi', 1976);insert into code_editors( program_name, year_released)values('nano', 1999);insert into code_editors( program_name, year_released)values('vscode', 2015);insert into code_editors( program_name, year_released)values('SQLDeveloper', 2006);insert into code_editors( program_name, year_released)values( 'notepad++', 2003);insert into code_editors( program_name, year_released)values( 'notepad', 1983);insert into code_editors( program_name, year_released)values( 'textpad', 1992);insert into code_editors( program_name, year_released)values( 'gedit', 1999);commit; |
SQLDeveloper allows you to drag data from the result grid from your last query to use in the next one
Nothing up my sleeves…
As far as I can tell, no special preparation is required. No incantation. Not even two bits of wood and a fresh egg.
It works just as well on string values…
Nunc Id Vides, Nunc Ne Vides
OK, so it’s not so good with dates (which it seems to treat as numbers), but then I’m far less likely to use them in an in list.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK