Physical Storage Structure Physical storage structure include data file, control files, Redo files. PSS are viewable at the operating system. Data File Store the data This is main file…
What is oracle database? Oracle database is a relational database Management system (RDBMS) that mange storage, organization and retrieval of data. An Oracle Database consists of a database and at least one instance. Single Instance…
I have a demo table as EMPLOYEEID INDIPAY OTHERPAY ISACTIVE 1 200 300 true 1 100 150 false I want the output as follows EMPLOYEEID INDPAY_ISACTIVE INDPAY_ISNOTACTIVE OTHERPAY_ISACTIVE OTHERPAY_ISNOTACTIVE 1…
SUBSTR This will be used to extract substrings.To show the specific character of a string.It will return character values Syntax: substr (string, start_chr_count [, no_of_chars]) Example select substr('computer',2), substr('computer',2,5), substr('computer',3,7)…
There are two tables tabA1 tabA2 NUM CODE CODE ITEMS 1001 A A paper 1002 B C milk 1003 C E paper 1004 A 1005 B 1006 B output should…
INPUT OUTPUT Should be output should like this o is group1,1 is group2,2 is group 3... Final Query select min(c) min_range,max(c) max_range from t_seq group by c-rownum order by 1
Input string output should be The query what is ? Substring Function connect by clause Reverse function
The query Output Another method select utl_i18n.raw_to_char( utl_raw.reverse( utl_i18n.string_to_raw(' nice blog '))) as reverse_string from dual; output Using reverse() select reverse ('welcome') from dual; output
First and last records of table1 into table2 has to be single rowSecond and last but second row of table1 into table2 input OUTPUT should be Employee1 data insert into…
I retrieve data from this demo table (e62) The Query Output