how to extract a unit value from a date and time? : Sql dba
- 0 Answers
- 546 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what is mean by forward declaration and where we'll use it.
A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.
Why indexing is needed?
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?
What is snowflake sql?
What does the base_object_type column shows in the user.triggers data dictionary view?
What are the different types of joins in sql?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is left join example?
define data blocks ? : Sql dba
What is string join?
What are sql triggers used for?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
