What are pl/sql packages?

1098

What are tables and fields in the database?

1102

When to use inner join and left join?

952

Is subquery faster than join?

1009

What are the advantages of stored procedure?

1000

What are % type and % rowtype?

1028

what is oracle database ? : Sql dba

1018

Does group by remove duplicates?

1035

What is sql not null constraint?

1023

What does select top 1 do in sql?

1084

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1018

What is rownum and rowid?

1027

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

1578

What is the use of function in sql?

1085

how to fetch alternate records from a table? : Sql dba

1103