Which data dictionary views have the information on the triggers that are available in the database?
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
How to execute OS(operating system) command from pl/sql?
Explain the steps needed to create the scheduled job?
What are the different sql languages?
How do you get all records from 2 tables. Which join do you use?
Does sql profiler affect performance?
How do I truncate a sql log file?
Mention what is the plv (pl/vision) package offers?
will function return more than one value how
Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...
What does trigger mean in slang?
How do I partition in sql?