ThatJeffSmith

Tag: Data

Showing TYPE’d Column Values in SQL Developer

Someone on the innerwebs asked how to show the data inside their user defined TYPE’d column in a table when querying it with SQL Developer. Here’s their code: CREATE OR REPLACE TYPE ANSCHRIFT_T AS OBJECT (STRASSE CHAR(12), HAUSNR CHAR(3));   CREATE TABLE VERTRETER(V_NR NUMBER(4) PRIMARY KEY, ANSCHRIFT ANSCHRIFT_T);   INSERT INTO VERTRETER VALUES (1, ANSCHRIFT_T(’TESTWEG’,’14’)); […]

Similar Posts by Subject Areas: , , ,

Introducing the SQL Developer ‘Shopping’ Cart

Just in time for the upcoming holiday shopping season, SQL Developer v3.1 (now available as an Early Adopter release), allows the developer or DBA to build ad-hoc deployment scripts. Need to ‘order’ that list of objects and underlying data for your test environment? Just add them to your cart and you’re ready for check-out! Once […]

Similar Posts by Subject Areas: , , , ,

Toad Video: Compare & Sync Table Data Across Servers

Sit back and relax as I take you through one of my favorite Toad features: Data Compare. In less than five minutes see how to: Set your data comparison target and source Configure which columns to compare Use WHERE clause filters to limit data compared View the results Synchronize the data (optional)

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,