Can we join two tables without common column?
No Answer is Posted For this Question
Be the First to Post Answer
declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?
Is it possible to read/write files to-and-from PL/SQL?
What are the different types of joins in sql?
Can a table contain multiple primary key’s?
What is a schema sql?
have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
How to display the records between two range in Oracle SQL Plus?
What is the use of cursor ? how cursor allocate context area for executing the sql statement?
How can I see all tables in sql?
What is the order of sql select?
List different type of expressions with the example.