The ACCEPT command in SQL Plus is used to take the input from the user and then store in a variable. Learn how to use Accept command in Oracle's SQL Plus tool.

Accept command in Oracle

In this section we will see how to use the Accept command in SQL Plus.

The ACCEPT command in SQL Plus is used to take the input from the user and then store in a variable. This variable can be used to substitute some value in the sql command. Usage of the ACCEPT command:

 ACCEPT User input

ACC[EPT] variable [NUM[BER]|CHAR|DATE] [FORMAT format]
[DEFAULT default] [PROMPT text|NOPROMPT] [HIDE]

Following example shows how to use the Accept in SQLPlus.

SQL> select * from user where username='&user_name'
SQL> /
Enter value for user_name: Deepak
old 1: select username from user where username='&user_name'
new 1: select username from user where username='Deepak'
USERNAME
------------------------------
Deepak
1 row selected.

This way you can create you sql queries to generate the report, in which your user can input some values and based on that appropriate data is retrieved from database.

You can use SQL Plus to generate many types of reports. The accept command will be useful if you want your report to be generated based on the user input.

More Tutorials on roseindia.net for the topic Accept command in Oracle.
Accept command in Oracle
Accept command in Oracle In this section we will see how to use the Accept command in SQL Plus. The ACCEPT command in SQL Plus is used to take the input from... to substitute some value in the sql command. Usage of the ACCEPT command:  ACCEPT
 
Oracle - SQL
D:\oracle\ora90\BIN\imp type this command if your are using oracle 9i...Oracle  I have one .dmp file. I want to import this file into oracle 9i and oracle 10g. wat is procedure and stepts. thanks u  Open
 
Command Line Arguments in Java Program
, suppose a program named CmndLineArguments that accept command line arguments... Command Line Arguments in Java Program       Java application can accept any number of arguments
 
COMMAND LINE ARGUMENTS
COMMAND LINE ARGUMENTS  JAVA PROGRAM TO ACCEPT 5 COMMAND LINE ARGUMENTS AND FIND THE SUM OF THAT FIVE.ALSO FIND OUT LARGEST AMONG THAT 5   Hi Friend, Try the following code: import java.util.*; class
 
Command line arguments
Java application can accept any number of arguments directly from the command line. The user can enter command-line arguments when invoking the application. When running the java program from java command, the arguments are provided
 
What is command line argument in Java
What is command line argument in Java  What is command line argument... example of command line argument program in Java?? It will be really helpful for the beginners like me.   Command line arguments allow the user
 
Oracle 9i database problem
Oracle 9i database problem  Hi Somebody has given the solution but i... Oracle 9i in my laptop.and i got sql+ page ok.i have gone to control panel->odbc->in that i correctley configured DNS and TNS and tested the Oracle
 
Command line argument in java
to the command line. It accept into the string argument of main method. Command...Command line argument in java. In this section we are going to discuss about command line argument in java. Command line argument allow a user to pass
 
oracle
oracle   sir now am doing one project , my frond end is vb and backend is oracle. so 1> how can i store the image in my field 2> how can i back up the table into .txt file
 
Can ArrayList accept an ImageIcon >>????
Can ArrayList accept an ImageIcon >>????  haw can create ArrayList witch can accept Image ..mean when i use add() method, instead item let me add image to the ArrayList in run time .{should be the program using GUI
 
can Stack accept imageIcon ..??
can Stack accept imageIcon ..??  how can write program like album ..by using Stack as an ideas datastracture and using imageIconb ?? please help me ..thanks alot
 
Accept Language and Accept Char set in Servlets
.style1 { font-weight: bold; } Accept Language and Accept Char set in Servlets       This section illustrates you the use of Accept
 
accept integer from user
accept integer from user  Write an Java application that accepts 100 integer numbers from a user. The input should be in the range of 1-200. Error message needs to be displayed if user entered input which is not in this range
 
button to accept user input
button to accept user input  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt){ public string name,lastname,radiobutton,spinner; name=JTextfield.getTextfield(); lastname=JTextfield.getTextfield(); show(new
 
array accept all data type
array accept all data type  how can create array that accept all data type??? if we can solution it? how..   Hi Friend, Try the following code: import java.lang.reflect.*; class CreateArrayOfAllTypes{ public
 
array accept all data type
array accept all data type  how can create array that accept all data type??? if we can solution it? how..   Hi Friend, Try the following code: import java.lang.reflect.*; class CreateArrayOfAllTypes{ public
 
Compute command
Compute command  hello, What is compute command?   hii, samar Compute command control computations on subsets created by the BREAK command
 
Print command
Print command  Can I use System.out.println command in Struts form bean or Struts action class. I am using Struts 1.3.8 but when I write this command...;You can use System.out.println command in Strut Action Class. The message written
 
bitwise operators accept type char as operands
bitwise operators accept type char as operands   Why bitwise operators accept type char as operands
 
JSP view detail page on accept button click
JSP view detail page on accept button click  i Have 1 jsp page in that there r 2 button accept and view details when we click on aceept button it will submit to next page and when click on view details page it will shown the data
 
the App Store does not accept or distribute web apps
the App Store does not accept or distribute web apps  the App Store does not accept or distribute web apps We found the user interface of your app is not of sufficient quality to be appropriate for the App Store What could
 
Oracle - JDBC
Oracle fetch variables  i wanted to fetch variables from database using Oracle
 
Oracle - SQL
Oracle  Oracle Begginers , if Downloadable Notes are there Please mention the site
 
oracle 18/04/2013
oracle 18/04/2013   Why it is called as structured query language
 
Oracle BLOB
Oracle BLOB  Can anyone send me the code for inserting an image or audio into the oracle database using BLOB datatype. Plz...it's useful for my project
 
oracle conditions
oracle conditions  can you briefly explain about the "EXISTS" condition in SQL with examples
 
iperf command in java
iperf command in java  How to write a code for iperf command in java
 
i got an exception while accept to a jsp
i got an exception while accept to a jsp  type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception
 
c++ system command
c++ system command   c++ system command variables and an example in real time of using the system command
 
oracle - JDBC
oracle  sir iam hari iam doing the project using oracle with jdbc in xp when iam inserting the data it is giving error like ora-01034:oracle not available sir plz.......give me the solution it is urgent sir thanku
 
oracle problem
oracle problem  Hi I have installed oracleXE on my system and for reasons i've uninstalled them and am not able to stop oracle xe services and i could'nt reinstall it. I couldnt reinstall my os for this as it is in my office
 
oracle - JDBC
to store these two fields into oracle database for that i have given one jsp page... it is giving error like java.sql.SQLException:[MICROSOFT][ODBC Driver for oracle][oracle
 
oracle connectivity
oracle connectivity  con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr"); i have error on above line when i tried...=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr
 
oracle - JDBC
oracle  How to collect the backup of tables in oracle? plz,, i want some tables in oracle of one system to be shifted to the another system...;There are two .exe files in ORACLE, with the FOLLOWING names,generally
 
oracle - SQL
oracle  can you suggest me a book regarding oracle and java even..  Hi friend, For more information on Oracle and Java Books visit to : http://www.roseindia.net/programming/books/Freejavabooks.shtml http
 
Command line arguments
Command line arguments  Please explain me what is the use of "command line arguments" and why we need to use
 
oracle - SQL
oracle  what is meant by redo log file?  Hi Friend, In Oracle, a redo log file is used with each database. It records all changes made in datafiles.Each transactions has been recorded in it.It makes it possible
 
java-oracle
java-oracle  hi friends, I wanted to upload a image from jsp page to oracle database.i am not getting how to do it... Please help me if you can....... please give me detail code
 
oracle - JDBC
oracle  HI i am using ORACLE 10g. How to i find "TNSNAMES.ORA" file in my system after installation of ORACLE 10g succussfully. please send... that depends on the actual network implementation used. Oracle recommends that SDU
 
oracle - SQL
) from employee)); In Oracle, you can use the following query: select max
 
Oracle - JDBC
Oracle  How to Use Blob and Clob Data types in Oracle...  Hi friend BLOB : Binary Large Object CLOB : Character Large Object Default storage each time a BLOB or CLOB exceeds 4000 bytes you could cause
 
ping command in servlet
ping command in servlet  hi can we execute ping command in servlet like as we do in normal java. if we can please give an example how. thanks & regards
 
Compiling package in command line
Compiling package in command line  Hi friends, i am totally new... package using command line. For Eg: When i compile following command, c:>set... as an internal or external command, operable program or batch file. please help me
 
Command Prompt in UI
Command Prompt in UI  Hi, Is there any API or JAR file for running all the windows command prompt commands like dir,echo,ping commands? If any please tell me what is it? Thanks & Regards---Vanchinathan.R
 
command prompt is compilation is not working
command prompt is compilation is not working   Dear java users can anyone help me to run the program in command line prompt i tried by selecting... is compiling and generation the class file using javac c:\helloworld.java command
 
Java Command Line Input
Java Command Line Input  How to get input from command line in java ?   Hi please Find the code for inputting data from the command line System.out.println("Please Input A Number"); BufferedReader br
 
character as command line arguments
character as command line arguments  public class testing { public static void main(String args[]) { char a; a=args[0]; System.out.println("character is:"+a); } } what will be the above program output
 
oracle vs sql
oracle vs sql  what is the difference between oracle and sql
 
how to download oracle 9i
how to download oracle 9i  how to download oracle 9i
 
Command Prompt in UI
Command Prompt in UI  Hi One Help... Please go through. I want to develop like that using jsp/javascript but nothing is striking in mind... Please give some suggestions to design first Thanks in advance---- Vanchinathan.R
 

Related Tags for Accept command in Oracle: