display your age in months?
Answers were Sorted based on User's Feedback
Answer / sowmya makkena
select floor(months_between(sysdate,'22-mar-1995')) "age in months" from dual;
| Is This Answer Correct ? | 1 Yes | 0 No |
select trunc(months_between(sysdate,'22-mar-1995')/12) as age from dual;
| Is This Answer Correct ? | 0 Yes | 2 No |
Write a query to find the names of users that begin with "um" in sql?
What is sharding in sql?
What is cte?
Define SQL and state the differences between SQL and other conventional programming Languages?
Show code of a cursor for loop.
How can we make an if statement within a select statement?
what is the difference between $message and $$message? : Sql dba
How to trace the errors in pl/sql block code?
Can a view be updated/inserted/deleted?If Yes under what conditions?
What does cursor do in sql?
What are crud methods?
Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)