How to display & in Oracle SQL output

sailajabetha

 Profile Answers by sailajabetha Questions by sailajabetha

• Aug 18th, 2008

Use concatenate operator ...SQL> select 'a'||'&'||'b' from dual;'A'---a&b

Answer Question  Select Best Answer

How to date track 2 tables to a previous month, using SQL code

suman

• Mar 18th, 2016

Date Track allows you to maintain a continuous history of the record or information over a period of time. You can use date track history to view a report of every update ever made to a record. Whene...

Answer Question  Select Best Answer

How to retrieve names from table starting with a particular character as a first letter, using with substring, instring without using LIKE function.

askmahantesh

 Profile Answers by askmahantesh Questions by askmahantesh

• Nov 26th, 2008

Consider the table EMPLOYEES with the column ENAME. Try with the following queries.Select ename from employeeswhere Instr(ename,'&A') = 1group by ename;'A' --> your starting cha...

Answer Question  Select Best Answer

How to convert any kind of date that comes in any format from the user to 'yyyymmdd' in Oracle?

todeepakmalhotra

 Profile Answers by todeepakmalhotra Questions by todeepakmalhotra

• Nov 24th, 2008

To convert a date in a specified format you need to?convert it into character..select to_char(hire_date, 'yyyymmdd') date from employees;

Answer Question  Select Best Answer

How to open an excel sheet directly from the SQL prompt?

smonroy

 Profile Answers by smonroy Questions by smonroy

• Sep 26th, 2011

You need to use a DTS (Data Tranformation System) to SQL Server 2000 or a SSIS to SQL Server 2008 (SQL Server Integration Services), both provide programmable objects to help you

Answer Question  Select Best Answer

What are Pair Wise & Non-Pair Wise Columns?

Vinod Tuteja

• Jun 6th, 2013

NON PAIRWISE COMPARISON SUBQUERY: "sql SELECT employee_id, manager_id, department_id FROM employees WHERE manager_id IN (SELECT manager_id FROM employ...

Answer Question  Select Best Answer

What could be the maximum size of a database name in MSQL?

vinodsahani

 Profile Answers by vinodsahani Questions by vinodsahani

• May 18th, 2010

Max Length in MySql Database 64 Table 64 Column 64 Index 64 Stored Function or Procedure 64 Trigger 64 View 64 Event 64 Tablespace 64 Log File Group 64 Alias 255

Answer Question  Select Best Answer

Write a query to display the average, monthly salary bill for each job type within a department.

abhinav.abinav

 Profile Answers by abhinav.abinav Questions by abhinav.abinav

• Jan 13th, 2010

Select job,deptno,avg(sal) from emp group by job,deptno;

Answer Question  Select Best Answer

How to query the average salary for all the departments employing more than 3 people?

abhinav.abinav

 Profile Answers by abhinav.abinav Questions by abhinav.abinav

• Jan 13th, 2010

Select deptno,avg(sal),count(*) from emp group by deptno having count(*)>3;

Answer Question  Select Best Answer

What are the disadvantages of co-related sub query?

sure_prince

 Profile Answers by sure_prince Questions by sure_prince

• Dec 10th, 2009

-> It is another way of performing queries upon the data with a simulation of Joins.-> In This the information from the outer Select Statement Pratcipates As a Condition in the Inner Select Statement.-> Depending on the Supplied value the condition is qualified for the specific Record.

Answer Question  Select Best Answer

What is the maximum limit for IN operator on SQL?

cutemax

 Profile Answers by cutemax Questions by cutemax

• Mar 18th, 2010

IN operator can't accept more than 1000 values at one time.

Answer Question  Select Best Answer

What is the purpose of NOCOPY mode in procedures?

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Mar 16th, 2010

When a parameter is passed as an IN variable, it is passed by reference. Since it will not change, PL/SQL uses the passed variable in the procedure/function. When variables are passed in OUT or INOUT ...

Answer Question  Select Best Answer

How will you add additional conditions in SQL?

vikas patil

• Sep 25th, 2015

By using AND & OR

Answer Question  Select Best Answer

How to enlarge the size of work area in iSQL*plus?

viji_info

 Profile Answers by viji_info Questions by viji_info

• Oct 22nd, 2010

If you are working isql plus..Go to the preference which lay on the right hand corner, then Edit the column width and height as much you want... Try it.

Answer Question  Select Best Answer

Which command displays the SQL command in the SQL buffer, and then executes it?

ajitsankpal

 Profile Answers by ajitsankpal Questions by ajitsankpal

• Jun 29th, 2010

RUN is the command which displays the query in SQL buffer and executes it.

Answer Question  Select Best Answer

sanjay mehra

• Aug 3rd, 2011

Code
span style="color: #F00;">'  '

Answer Question  Select Best Answer

Hi Friends, One table having some many records but I want to retrieve under little-bit records randomly. If it is possible in SQL then send the reply ? So, I will wait for ur valuable answer...

Balapradeep Reddy

 Profile Answers by Balapradeep Reddy Questions by Balapradeep Reddy

• Feb 14th, 2012

Code
 

Answer Question  Select Best Answer

Ehsan Rehmani

• Aug 7th, 2013

The set transaction statement used to establish the current transaction as read only or read write, establish its isolation level or assign it to a specified rollback segment or when someone use DDL statement.

Answer Question  Select Best Answer

What is mean by Performance Tuning? Explain with example.

Akash S. Patil

• Nov 16th, 2016

Database tuning is a group of activities used to optimize the performance of the database. Goal of database tuning: 1. To maximize use of system resources. 2. To perform task as efficiently. 3. To wo...

Answer Question  Select Best Answer

Is there any datatype in oracle to check whether a inserting value is at least a numeric and a character?

Rajiv

• Jul 17th, 2019

We can use regular expression such as REGEXP [A-Za-z0-9] in order to validate a column,which takes only number and charcater value.

Answer Question  Select Best Answer