How to run pl/sql statements in sql*plus?
What is data definition language?
What is a temporal data type?
Explain cursor types?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What is the use of cursor ? how cursor allocate context area for executing the sql statement?
What is Difference Between delete and Truncate?
Can we insert data in view?
What is #table in sql?
Differentiate pl/sql and sql?
How do you know if a relationship is 2nf?
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
How do I quit sql?