What is rollback?
Explain the difference between rename and alias?
What is the purpose of design view?
What is implicit cursor in pl sql?
What is use of trigger?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Can we use the cursor's to create the collection in PL/SQL?
What is the default isolation level in sql server? : Transact sql
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 is use pl and sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
what is the use of double ampersand (&&) in sql queries?
What is the meaning of disabling a trigger?
Why we use joins in sql?
Do ddl statements need commit?