how to i write the query 'NISHI' TO
N
I
S
H
I

Answer Posted / karthik

SELECT 'NISHI' NAME FROM DUAL;

COLUMN NAME FORMAT A1
/

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to run create database statement?

745


What happens to indexes if you drop a table?

895


What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

732


What is oracle and what are its different editions?

767


Can we create database in oracle using command line ?

780






What are the logical operations?

863


How to define an oracle cursor variable?

747


How can I get column names from a table in oracle?

744


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1684


Give the various exception types.

733


Can we convert a date to char in oracle and if so, what would be the syntax?

746


How to run queries on external tables?

756


How to view existing locks on the database?

753


I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2170


Explain cascading triggers.

794