How to run sql statements with oracle sql developer?
Can a table contain multiple primary key’s?
Can we connect to postgresql using sql developer?
what are the properties and different types of sub-queries? : Sql dba
how to enter binary numbers in sql statements? : Sql dba
Can we rollback truncate?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Mention what is the use of function "module procedure" in pl/sql?
Explain exception handling in pl/sql?
List out the acid properties and explain?
List and explain the different types of join clauses supported in ansi-standard sql?
i need department wise top 2 employees salary.which logic i will use
Is truncate ddl or dml?