How to pass parameters in an Oracle SQL Script?

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 (3) 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

Downvote Reply () Report

Popular Searches

Engineering Technicians Jobs Engineers Jobs Sales Executive Jobs Accountant Jobs Software Engineer 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)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.