How to call DDL statements from pl/sql?5 27549
How to maintain the history of code changes of pl/sql?2 10370
what are Dynamic SQL statements?9 17031
What is pl/sql and what is it used for?4 11182
what is constraining table?2 9946
How pl/sql source code can be protected?2 7595
What can be a size of a pl/sql block? Is there any limit?2 9376
HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?2 4991
What are the advantages of VIEW?5 28244
Can one improve the performance of sql*loader? : aql loader
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is the usage of distinct keyword?
Compare sql & pl/sql
How does sql*loader handles newline characters in a record? : aql loader
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
List and explain the different types of join clauses supported in ansi-standard sql?
In what condition is it good to disable a trigger?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi firstname.lastname@example.org
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
What is a null value?
What is a trigger in sql?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What are the different datatypes available in PL/SQL?
How can the performance of a trigger be improved?