What is db journal file?
Can we perform dml in function?
How do I tune a sql query?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance
Do you understand the meaning of exception handling?
what is user defined functions? : Sql dba
PL/SQL allocates memory for the variable's at runtime or at compile time
What is native sql query?
what is foreign key? : Sql dba
What are the new features in Oracle 10g. Compared to Oracle 9i?
What is ttitle and btitle?
Is pl sql useful?
What is cartesian join in sql?