How to write a query to show the details of a student from students table whose
No Answer is Posted For this Question
Be the First to Post Answer
What does trigger mean in psychology?
What is delimiter sql?
when normalization is required
How can you load multi line records? : aql loader
How does cross join work?
Why do we need databases?
In testing where do we use sql language and how it helps in testing?
what is Difference between Having and Where clause?
Explain clause in sql?
What does rownum mean in sql?
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.
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)