How to pass parameters in an Oracle SQL Script?

- Newsfeed
- Find People
- More
- - Products By Bayt.com
    
    Bayt.com
    
    Shagheel
    
    Specialities
    
    Learning
    
    Companies
    
    Salaries
    
    People
    
    Blog
- - العربية
- Use Our Mobile App
  
  Get contacted by recruiters directly with our newest chat feature!
  
  Download Now

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Next Question:
How can you define Oracle Developer shortly?
Posted by:
Muhammad Jamil Shaheen Jamil
11-December-2013

Programming Databases Oracle

Question added by Deleted user
Date Posted: 2014/08/06

Upvote (1) Views (2) Followers (2) Answers (1) Report Question

Write an Answer
Register now or log in to answer.

1 Answers

by Fahad Akhtar , System Analyst , Al Musbah Group

You can pass parameter using & variable.Example

SELECT *

FROM SCOTT.EMP

WHERE DEPT_CODE = &DEPT

Upvote (1)

Downvote Reply () Report

Popular Searches

Engineers Jobs Sales Executive Jobs Software Engineer Jobs Accountant Jobs Sales Manager Jobs

Write Your Answer

More Questions Like This

What does Oracle SQL differ than SQL Server?
Top Answer: The biggest differences between oracle and SQL server are1- Oracle is Transaction based DBMS and SQL serv ... See More

Answers (5)
What is difference between Oracle API and Oracle SQL Loader?
Top Answer: "Oracle SQL Loader" is a direct upload utility available in Oracle DB , using it you can get data from a ... See More

Answers (1)
How to create a succesful connection on Oracle SQL server 3.2?
Top Answer: dear ali there is nothing like sql server3.2 if u meant sql developer, pls let me know. See More

Answers (1)
How would I learn to write Oracle SQL queries?
Top Answer: First clear your concept in D.B.M.S and R.D.B.M.S. If you already doing some programming and wants to mov ... See More

Answers (5)