What is the difference between truncate & delete command?
No Answer is Posted For this Question
Be the First to Post Answer
Explain oracle’s server parameter file.
What is a Redo Log ?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What happens if variable names collide with table/column names?
How to use like conditions in oracle?
Explain the features of oracle?
Explain the function of optimizer in oracle?
Can we create trigger on materialized view in oracle?
What is a system tablespace and when it is created?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Is oracle an open source?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?