i need the name of datafiles

[steeve123]

Is there a table or view that contain only the name of the datafile(without the path)?

select file_name from dba_data_files;
D:\ORA8I\ORANT\ORADATA\ORCL\SYSTEM01.DBF



I now that i could play with character function to get the name, but i prefer a nice select if there's a column that contains only the name.

[pipo]

nope, it is unuseful for Oracle ...
find the complete path in v$datafile, and you'll have to use instr & substr