can u call user defined functions in select statements
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 |
material view and view disadvantages?
What is the difference between RBBMS & DBMS?
How to restrict the duplicate records in table valuesets
How to write an inner join with the where clause in oracle?
How remove data files before opening a database?
Explain temporal data types in oracle
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,
How to define a data source name (dsn) in odbc manager?
What are the advantages of oracle?
Can u make a synonym for deptno=10 only from emp table.
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records