Home
Search results “With data as oracle update”
SQL Update Statement using Example in Oracle 11g Database
 
05:27
SQL tutorial for beginners in hindi and english SQL Update Statement using Example in Oracle 11g Database
Oracle - SQL - Update Statement
 
03:45
Oracle - SQL - Update Statement Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Oracle update command - beginner
 
06:07
Oracle update command - beginner
Views: 1592 Chris Ostrowski
SQL Tutorial - 21: The UPDATE Query
 
06:12
In this tutorial we'll check out the UPDATE Query which is used to update/change records in a table.
Views: 73579 The Bad Tutorials
C# - WPF - Insert Update Delete and View Data from Oracle Database Part 1/2 [with Source Code]
 
11:00
Download link: https://goo.gl/Axoeja part 2/2 : https://youtu.be/NiGsgctfiYM C# - Oracle - How To Connect C# with Oracle Using ODAC - ODP.NET: https://youtu.be/cP6UatAZ76s
Views: 13889 Safaa Al-Hayali
Oracle SELECT FOR UPDATE /عربي
 
07:24
you can visit my website maxvlearn.com
Views: 807 khaled alkhudari
1- CreateForm1 in Oracle Forms - Add - Update - Delete - Select
 
41:13
Connect To Database Oracle In Oracle Forms Create Form Wizard In Oracle Forms Create Form Manually in Oracle Forms Add Data Update Data Delete Data Select Data Add Image In Oracle Forms
Views: 4975 Abdullah mohamed
SQL with Oracle 10g XE - Using UPDATE to Change Data in a Table
 
03:16
In this video I use the UPDATE command to change existing data within a table. When using the UPDATE command you also need to use the keyword SET to choose the field column you wish to change and also a WHERE statement to choose the individual record that needs changed. The command I used is: UPDATE BOOKS SET BINDING = 'P' WHERE BOOK_ID = '11'; This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.
Views: 8965 Lecture Snippets
How to update Supplier information using API in Oracle EBS R12?
 
07:02
Is any way to run a supplier mass update from backend? I bet this question was raised many time to E-Business Suite support team few months after go live. More over when data was migrated from a legacy system and cleaning activity was completed under time pressure. Answer is yes, it's possible to run a mass update as Oracle EBS provides APIs for supplier master data and also for supplier site level. API sample may be downloaded from http://oracle-ebs-hands-on.blogspot.com/2014/06/how-to-update-supplier-information.html For other interesting tips http://oracle-ebs-hands-on.blogspot.com
Views: 6283 Oracle EBS Hands-On
Updating and manipulating data with ojTable
 
10:54
A quick demo showing one way to work with data and a JET based Table.
Views: 4449 Oracle JET
Upgrade oracle database from 11g to 12c
 
22:55
Steps to upgrade an Oracle database from 11gR2 to 12c
Views: 33799 Tamal Chatterjee
Merge Statement in Oracle SQL with Example (UPDATE/DELETE or INSERT)
 
15:04
This video demonstrates how to write a Merge Statement in oracle sql, how it is useful in doing a conditional update or delete or both of them when the condition between the target table and source table is evaluated to true, and how we can insert the record into the target table when condition is evaluated to false. The video also shows the use of UPDATE, DELETE and INSERT with Merge, and also the various possible ways to use a Merge statement!!!
Views: 6267 Kishan Mashru
OracleSQL#14 How to Update rows using Update Statement in Oracle SQL database
 
05:42
In this Video, I am explaining How to update the table Rows using SQL developer In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/lrnwthr/ Twitter: https://twitter.com/LrnWthR
Views: 23 EqualConnect Coach
UPDATE STATEMENT WITH JOIN IN ORACLE SQL
 
07:18
This video demonstrates how user can update data of a particular table(t1), based on the join condition with other table(t2). So it would be a easy way to ditch the for-loop, and check for the condition every time. What was to be achieved from the for-loop can be achieved with a single simple update statement. A simple trick to update data in table based on some conditional data in some another table, would help you to increase the performance of your code massively. For ex : UPDATE TABLE1 t1 SET COL1 = (SELECT COL FROM TABLE2 t2 where t1.col = t2.col);
Views: 2117 Kishan Mashru
Oracle SQL PLSQL 12C Tutorial 14 - UPDATE Statement
 
05:49
This Video Tutorial Will Describe how to update a row or update column or update particular value which is already inserted into the table in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on. This command is used to update or modify the inserted data into the table. You can update single column, single row, multiple columns or multiple rows with this command. Full Syntax will be given in this video tutorial about how to update data in oracle database table. Along with the live example to update rows or columns from the table. All the keywords, format, mandatory clauses etc are described in this video.
SQL Tutorial 16 Update clause
 
08:38
multiple column update, update using correlated subquery in set clause Check out our website: http://www.telusko.com Follow Telusko on Twitter: https://twitter.com/navinreddy20 Follow on Facebook: Telusko : https://www.facebook.com/teluskolearnings Navin Reddy : https://www.facebook.com/navintelusko Follow Navin Reddy on Instagram: https://www.instagram.com/navinreddy20 Subscribe to our other channel: Navin Reddy : https://www.youtube.com/channel/UCxmkk8bMSOF-UBF43z-pdGQ?sub_confirmation=1 Telusko Hindi : https://www.youtube.com/channel/UCitzw4ROeTVGRRLnCPws-cw?sub_confirmation=1
Views: 4130 Telusko Learnings
ORACLE SQL TUTORIAL 4: SQL UPDATE STATEMENT
 
10:58
คำอธิบาย
Views: 52 Manachai CHANNEL
PL/SQL tutorial 15: DML Trigger With Before Insert, Update and Delete DML Examples
 
09:17
PL/SQL Tutorial 15 explaining DML Trigger with examples such as Before Insert, Update and Delete in Detail. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/dml-triggers Previous Tutorial ► Trigger Intro : https://youtu.be/R3fvX_xf5P4 ► SELECT-INTO : https://youtu.be/F5eMJhwmCQs ►IF-THEN-ELSIF: https://youtu.be/aW9XgUHSr0I ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 86711 Manish Sharma
Add, Update, Delete Oracle data with AngularJS and JSP
 
19:44
In a previous video I have shown how to retrieve data from Oracle and render page with AngularJS, in this tutorial we discussed about adding, updating and deleting oracle data from web page using AngularJS. It's dynamic, it's fast. Providing the source code consisting of 3 files. 1. test.html, 2. insertUpdateDelete.jsp and 3. get_oracle_data.jsp https://drive.google.com/file/d/0BznrW3lgX0ozMi1XMHY3NHIyUk0/view?usp=sharing
Views: 10429 Subhroneel Ganguly
Update and Transactions: Databases for Developers #8
 
07:11
In this episode Chris discusses the ins and outs of using updates to change data in existing rows. Watch this to learn how to write update statements and avoid the dangers of deadlock and lost updates. Oracle Database SQL Language reference for update: http://docs.oracle.com/database/122/SQLRF/UPDATE.htm#SQLRF01708 Take the Databases for Developers FREE SQL course at https://devgym.oracle.com/devgym/database-for-developers.html Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ The Magic of SQL with Chris Saxon Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 2926 The Magic of SQL
How TO DELETE ROW, MODIFY, UPDATE COLUMN, DROP TABLE in Oracle SQL Using Cmd [Hindi/Urdu].
 
08:03
Hi Friends !!!!! In this Video we show the How to delete table, row, update etc. Oracle Databse- a) Open The Sqlplus. b) Connect The Workspace. c) Show Your Tables. Query : Select * from tab; d) Select the table where you want to delete row. Query : Delete From [Table Name] Where id=?; e) Show Your Tables. Query : Select * from tab; 1 row delete sucessfully. f) If You Modify Your Table to follow this Query : Alter table [Table Name] modify [Column Name] varchar2(10); Your table column is modified. g) If You Update row data follow this Query Update [Table Name] set [Column Name]='row data of column' where id=?; If you delete the table follow the Query : Drop Table [Table Name]; Your table is deleted sucessfully. Related video Links : How to Install Java Netbeans IDE in Windows 7, 8.1, 10 [Hindi/Urdu]: https://youtu.be/jOYMNognZXM How To Install Java On Window 10, 8.1, 7 64 bit Operating System [Hindi/Urdu] : https://youtu.be/y2-g09nY33A How to install Windows 7, 8.1,10 from a flash drive or Pandrive . [Hindi/Urdu] : https://youtu.be/s4kNcirxWrc How to Make Bootable Your Pandrive [Hindi/Urdu] : https://youtu.be/BPx_Ua_aCfY How to install Oracle 11G XE On Windows 10, 8.1, 7 Operating System in [Hindi/Urdu] : https://youtu.be/-2k4QCIpIOs How to Create Table Oracle Datbase Using Sqlplus [Hindi/Urdu] : https://youtu.be/EHnAebRP6Yw How To Insert Table Oracle Database Using Sqlplus [Hindi/Urdu]: https://youtu.be/Fu0tlCml8F8 How TO DELETE ROW, MODIFY, UPDATE COLUMN, DROP TABLE in Oracle SQL Using Cmd [Hindi/Urdu]: https://youtu.be/prz9Pr0PFEg How to recover format or delete Pandrive, Sdcard, Memory Card Or Harddisk Data [Hindi/Urdu] : https://youtu.be/0GGDHVTxDh0 How to install Oracle SQl Developer And How to Connect Your Database Sql Developer[Hindi/Urdu] : https://youtu.be/608nx3mT10c How to use SQL Distinct Keyword in Cmd Or Oracle SQL Developer [Hindi/Urdu] : https://youtu.be/ofLLZ9-EG_E How to use SQL AND Or OR operator [Hindi/Urdu] : https://youtu.be/zzqDp7U3rC8 How To Use SQL Where Operation using CMD [Hindi/Urdu] : https://youtu.be/EHmL0Wa14UY How To Use SQL ASC and DESC Operation using cmd [Hindi/Urdu] : https://youtu.be/UI0hat_RMX0 For Any Query Email Add : [email protected] Facebook Page link : https://www.facebook.com/Technical-Education-4-You-144220269545756/?ref=nf&hc_ref=ART3p2EX_iIdZHm96Uz36P99q7xfycGfo54RJafY-f0O4n1bdvWU_5xGHpPrOpLepi4
ORACLE DATA INTEGRATOR ODI Incremental update
 
50:10
ORACLE DATA INTEGRATOR ODI Incremental update
Views: 222 srinu bondada
Realtime Web Reports update with Oracle +Node.js + Socket.io
 
08:33
Showcase for setup Realtime Web Reports with automatic data update on Oracle databases.
apex Manual create update delete Entry form
 
18:08
How to learn Oracle Apex 5.0
Views: 4564 Mahbubul Alam
Bulk Update Data with Excel | Excel SQL Database Update and Insert Utility
 
09:02
In this video I demonstrate how Microsoft Excel can be used with SQL, VBA and Data Validation techniques that make for a simple yet powerful solution that anyone can use to review and update sql database data. My particular example is the KuduTek Equipment Maintenance Utility which was designed to specifically read and edit SQL Server data for e-automate. However this works equally well for other databases than SQL Server, including Oracle, DB2, MySQL etc.
Views: 5580 Jon Muller
Oracle SQL: How To Modify Data With The Update Statement by AskTheOracle.net
 
06:00
How to modify data in your Oracle database by using the SQL UPDATE statement. For more Oracle tutorials go to http://www.asktheoracle.net
Views: 2579 asktheoracle1
3.11 delete update data in ORACLE
 
12:37
use of update delete on udate on delete constraints
Views: 50 Sotiris zz
Update Data Oracle Database and Alert Notification Message - Java Tutorial(3)
 
14:25
How update customer's data and alert update successfully notification message Using jtrs_npic1.0.1.jar (continue)
Views: 759 Rasmey Ty
How to insert or update a view using instead of trigger in PL SQL
 
13:20
How to insert or update a view using instead of trigger in Oracle. Starting from creating view, creating instead of trigger on that view and updating base table inside the view a complete Sql Tutorial / PL Sql Tutorial to understand the functionality of instead of.
Views: 5321 Subhroneel Ganguly
20 - Oracle forms 11g |ON-DELETE |ON-UPDATE |اوراكل فورمز
 
11:32
Oracle forms on-delete trigger Oracle forms on-update trigger اهلا بكم فى درس جديد من دروس أوراكل فورمز فى درس اليوم مثال عملى على تريجر on-delete وتريقر On-update وذلك من خلال عملية مراقبة –auditing – لعمليات الحذف و التعديل التى يقوم بها المستخدم بانشاء جدول – auditing table - history table وعمل تريجر on-delete ,on-update ونستخدم ايضا delete_record; ,update_record; ......................................­.................... لو عندك اى سؤال خش على الجروب : https://www.facebook.com/groups/oracle.askgad ......................................­.................... لمتابعة كل ماهو جديد من خلال صفحتنا https://www.facebook.com/askgad
Views: 1156 Ask Gad
C# - WPF - Insert Update Delete and View Data from Oracle Database Part 2/2 [with Source Code]
 
09:30
Download link: https://goo.gl/fAUCRh part 1/2 : https://youtu.be/LUKp76CNmJY
Views: 6287 Safaa Al-Hayali
TUTORIAL-2 Select, Create, Alter, Insert, Update, Delete operations sql developer oracle 12c
 
07:25
This is SQL tutorial video for beginners. I have used Oracle 12c for its implementation. If you don't have oracle 12c downlad it from Oracle official website. It is open source, you don't need to pay for it. and Watch how to install Oracle 12c here:-https://www.youtube.com/watch?v=DXh-hmDb0xE&t=5s 1. create table tablename 2.insert into tablename values(); 3.Alter table add field datatype 4.Delete from tablename where conditions 5.UPDATE tablename SET values where condition If you have any doubt, Please comment below and share it because sharing is caring!! Have a great programming!!
Views: 3289 Let's Learn Pro
Oracle SQL The Update Statement تعليم أوراكل
 
10:54
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج How to update and modify existing data in a table. كيف تحدث بيانات موجودة فى الجدول Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W oracle create table statement oracle drop table statement oracle constraints database constraints primary key constraint foreign key constraint check constraint null not null constraint unique constraint insert into statement update statement delete statement
Batch update Oracle CLOB field data from files
 
00:26
Batch update Oracle CLOB field data, by OraLobEditor, http://www.withdata.com/oralobeditor/ . Download link: http://www.withdata.com/down/OraLobEditor.exe .
Views: 230 Shiji Pan
Update and Delete Data using Apex
 
18:13
This tutorial will show how you can update and delete data in oracle apex 5. It is manual process. For next tutorial please subscribe, like and comments. I am Daloar Hossan and my email [email protected] If you face any problem you can text me. Others apex tutorial: Get primary key process in oracle apex https://youtu.be/AoOu9Ywn_io Create a Form Manually in Oracle Apex https://youtu.be/8rg8nN2lRcw Create classic report on table https://www.youtube.com/watch?v=oaApu... Create a new form on a table https://youtu.be/LgSrIPt9490 How to add application title and display connected user name with logout option https://www.youtube.com/watch?v=TSwVQ... Disable Set Screen Reader Mode https://www.youtube.com/watch?v=-aU5u... Install oracle apex 5 https://www.youtube.com/watch?v=O3819... Other tutorials: https://youtu.be/8rg8nN2lRcw https://youtu.be/oaApuVoOHaE https://youtu.be/LgSrIPt9490 https://youtu.be/TSwVQJttZYU https://youtu.be/-aU5u9qzNf4 https://youtu.be/Y9qpuKPkYPE https://youtu.be/4mVRA7Bl_00 https://youtu.be/Gn8y6zsCoLQ https://youtu.be/UENDBv8PLbk https://youtu.be/gpVjyubjE0I https://youtu.be/T5B0g8HSjZo https://youtu.be/Lmp3QA2-KPs https://youtu.be/ZIIe6RfjgJc https://youtu.be/mC9VL_PZ8Bo https://youtu.be/3Df7LCx5wKQ https://youtu.be/O3819K3IYJk https://youtu.be/cBdfQnc6caI https://youtu.be/541mxAVG7hQ https://youtu.be/ELESdlvhN_4 ttps://youtu.be/Z9AAMsGGVvM
Views: 347 IT WORLD
79. UPDATE and DELETE using Cursor in PL/SQL Oracle
 
08:18
In this video you will learn about UPDATE and DELETE using Cursor in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 2997 ITORIAN
Data Import Templates [Oracle PBCS Update - July 2017]
 
01:15
Sign up for monthly Oracle PBCS Updates at: http://bit.ly/2goOoGg This video update is part of the monthly Oracle Planning and Budgeting Cloud Service (PBCS) Update Series from eCapital Advisors. On a monthly basis, experts at eCapital review Oracle release notes to provide a look at the latest features and changes users & administrators must know about. The July 2017 Oracle PBCS Update included: Follow Up To June 2017 Update What is PBCS? Don't Forget About EPBCS! New in July Monthly Update Schedule New EPM Automate Utility Version EPM Automate Utility Install Review New REST API: CLEAR_CUBE Clear Cube Enhancements Updated Provisioning Work Navigation Flow Enhancements New Predictive Planning Chart Predictive Planning Enhancements Member Name May Contain Comma Export a Grid Design In Financial Reporting Web Studio to Excel Enterprise Features Weekly Planning - Financial Model New Workforce Dashboard Data Import Templates Metadata Import Bug Standard Interface Reporting Studio - Desktop Client File Integration - Oracle Fusion Financials Cloud Custom Members in Property Dimension Q & A
Views: 95 eCapital Advisors
ODI12c Incremental Update SQL 2016 11 22 07 27 odi111
 
46:53
Oracle Data Integrator 12c Incremental Update
Views: 1597 FrizbeeTek ODI
Adding and Updating Metadata Using Smart View in Oracle Financial Consolidation and Close Cloud
 
03:30
This tutorial demonstrates how to add and update metadata in Smart View in Oracle Financial Consolidation and Close Cloud. You learn how to edit member properties, add new members, and update the database with your changes.
Views: 1550 Oracle EPM Tutorials
Oracle APEX Techniques Tutorial: Updating the Database without Submitting a Page | packtpub.com
 
02:58
Part of 'Oracle APEX Techniques' video series. For the full Course visit: http://www.packtpub.com/content/oracle-apex-techniques/video?utm_source=youtube&utm_medium=video-description&utm_campaign=yt-oracleapextechniques To provide a more interactive experience, sometimes you need to update the data without submitting a page. Use a dynamic action that saves the input on the click of a button. Update the database without submitting the page. • Modify the existing form and add a button on screen • Create a dynamic action that runs PL/SQL, submitting the relevant item • Demonstrate the functionality at runtime and show the updated record ------------------------------------------------------------------------------------------------ For the latest in Enterprise Products and Platforms video tutorials, please visit: http://www.packtpub.com/books/video?utm_source=youtube&utm_medium=video-description&utm_campaign=yt-oracleapextechniques Find us on Facebook -- http://www.facebook.com/Packtvideo Follow us on Twitter - http://www.twitter.com/packtvideo
Views: 6484 Packt Video
How to Update Data from java to Oracle Database Working 100%​ - krumony
 
03:49
How to Update Data from java to Oracle Database Working 100%​ - krumony
Views: 128 Mony HO
Full Session [Oracle PBCS Update - December 2017]
 
23:54
Sign up for monthly Oracle PBCS Updates at: http://bit.ly/2goOoGg This video update is part of the monthly Oracle Planning and Budgeting Cloud Service (PBCS) Update Series from eCapital Advisors. On a monthly basis, experts at eCapital review Oracle release notes to provide a look at the latest features and changes users & administrators must know about. TOP 10 Oracle PBCS Enhancements in 2017: 10. Simplified Interface 9. New Simplified Dimension Editor 8. Activity Reports Upgrades 7. Dashboarding Customizations 6. Smart Push Updates 5. Valid Intersections Updates 4. Loading Metadata with Data Management 3. Custom Navigation Flows 2. Integrated Business Process 1. Strategic Modeling Module The December 2017 Oracle PBCS Update included: What is PBCS? Why Choose Oracle PBCS? Don't Forget About EPBCS! Smart View Excel Add-in New in December Monthly Update Schedule Delay Standard Interface - Support Removed Tree View - Reports and Task Lists Loading Metadata - Data Management New Custom Functions - Calc Manager Time Prompt Function - Calc Manager New Smart View for Office Version New EPM Getting Started Guides Enterprise Features Create & Edit Account Groups - Strategic Modeling Refresh Project Dates - Projects Classic Dimension Editor Reporting Studio - Desktop Client
Views: 1409 eCapital Advisors
How To Insert,update,delete,join Data into a Table Using SQL Developer tool
 
02:53
How To Insert,update,delete,join Data into a Table Using SQL Developer tool In this topic, you learn to add objects to the Query Builder interface and then create a query based on those objects. In this section, you create a query based on the EMPLOYEES and DEPARTMENTS tables. You will generate output that shows per department name, the employees who work in that department. Perform the following steps to add the EMPLOYEES table to the Query Builder. 1 . Select the Query Builder tab to open Query Builder window. 2 . Drag and drop the EMPLOYEES table from the Connections navigator to the Query Builder window. 3 . Drag and drop the DEPARTMENTS table object over to the Query Builder window, so that the two table objects are displayed in the Query Builder window. Because there are two relationships defined between the EMPLOYEES and DEPARTMENTS tables, you see two lines between the tables identifying the columns that are linked together through foreign key constraints. The two relationships are defined as: The MANAGER_ID in the DEPARTMENTS table must be a value of the EMPLOYEE_ID in the EMPLOYEES table (managers must exist as employees). The DEPARTMENT_ID in the EMPLOYEES table must be a value of the DEPARTMENT_ID in the DEPARTMENTS table (an employee's department must exist in the DEPARTMENTS table, or be null). 4 . Next, you select the columns that you want to see in the report. In the EMPLOYEES table, check the FIRST_NAME, LAST_NAME, JOB_ID, SALARY, and DEPARTMENT_ID columns. As you select these columns, note that they are added in the order that you select them into the window below the table objects. In the DEPARTMENTS table, check the DEPARTMENT_NAME column. 5 . Click Run .
Views: 1328 Narayan Mehta