can u call user defined functions in select statements
- 2 Answers
- 5501 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prasanna
we can call user defined functions in select statements
| Is This Answer Correct ? | 6 Yes | 0 No |
yes, we can call user defined function in SELECT statement.
ex:
select function_name from dual;
| Is This Answer Correct ? | 3 Yes | 1 No |
What happens if variable names collide with table/column names?
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
What are the differences between char and varchar2 in oracle?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
What is the relation of a user account and a schema?
What is backup in Oracle?
What is the difference between postgresql and oracle?
How to remove a row in a database table?
What is Hash Cluster ?
How to create a new view in oracle?
How to convert raw data type into text in oracle? Explain
How do I escape a reserved word in oracle?
Oracle General 
