What is AUTH_ID and AUTH_USER in pl/sql ?923
----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 64 1366
Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL1 1698
2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B1 2235
3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);1 1291
4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;1 909
Whis is not false in primary key?379
What is Histogram?
I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.1 462
How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's.
You shouldn't use more than one select statement in entire the program.
Like cursor c is select * from
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 this288
When is a declare statement required?
What is a string data type in sql?
What is procedure in pl sql?
What are the types of sql commands?
Differentiate between sga and pga.
What is the purpose of cursors in pl/sql?
What are the operators used in select statements?
Is inner join faster than left join?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What is gpt format?
Can dml statements be used in pl/sql?
What do you understand by pl/sql records?
What are all the common sql functions?
What is cursor explain with example?
Is sql similar to python?