- cl scr: It is a SQL*PLUS command which is used to clear the screen.
- desc/describe: This command is used to show the structure of the table.
NOTE: The difference between SQL & SQL*PLUS is "Every command in SQL ends with semicolon where as in SQL*PLUS command no need to end with semicolon.
NOTE: We can change SQL prompt name as following
1.Initially it is SQL>
2.Now I want to change SQL> as PRAVEEN>
3.Then write command as
4.SQL> set SQLPROMPT PRAVEEN> & then press enter
5.here we go with
6.PRAVEEN>
No comments:
Post a Comment
If you Like my blog Spread it and help friends for whom this blog is useful for their career.