Answer Posted / basanti
select * from emp where emp_id between '200' and '300'
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to start an oracle instance?
How to start a specific oracle instance?
can u plz provide me oca sql dumps please i need them
How many categories of data types in oracle?
What is the relation of a user account and a schema in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is the difference between pre-select and pre-query?
How to specify default values in insert statement using oracle?
What is system global area (sga) in oracle?
Where are the settings stored for each instance in oracle?
How to add a new column to an existing table in oracle?
How to connect to a remote server?
Explain what are the different type of segments?
What is ADDM Advisor in Oracle?