Tech Articles PL SQL
yet detailed enough for the database design to use to create the physical structure. A data model is a conceptual representation of the data structures that are required by a database. The data structures include the data objects, the associations between data objects, and the rules which govern operations on the objects. As the name implies, the data model focuses on what data is required and how it should be organized rather than what operations will be performed on the data. To use a common analogy, the data model is equivalent to an architect's building plans.
A data model is independent of hardware or software constraints. Rather than try to represent the data as a database would see it, the data model focuses on representing the data as the user sees it in the "real world". It serves as a bridge between the concepts that make up real-world events and processes and the physical representation of those concepts in a database.
|
please clarify: ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [4194],[51],[61],[ ],[ ],[ ],[ ],[ ] I AM facing this problem in my server. Joydeep |
|
Hi All, This internal error code is nothing but the files related to the db had been corrupted.So,the best solution for this,trace the controlfile at mount stage in sql prompt.And check the process id by giving the command !ps -x in sql prompt.Goto udump directory and copy that trace file to $HOME.shut down ur db and take the bkup of control file and remove the controlfile.Go to trace file and set the set-1 with noresetlogs option.And run that script. in sql prompt.And open the db normally.Simply we can say that tuning the db. |
|
plz any one can mail me the complete tutorial of sql/sql* in my mail address which is chaudharyshamraiz@gmail.com thanks |
|
plz any one can mail me the complete tutorial of sql/sql* in my mail address which is chaudharyshamraiz@gmail.comThis email address is being protected from spam bots, you need Javascript enabled to view it thanks. |
|
Can any one mail the complete tutorial of sql/,sql as I wanted to take certification . Thank you very much |
| can anyone please help me the procedure for taking oracle certification?please email me at ramya298@rediffmail.com |
|
I would like to know about the oracle application in the area of clinical data management. Can any body send me the total tutorial of introduction to oracle ? IF any wishes it them mail me on nikki11842@gmail.com |
| I would like to know about the Oracle Application in the area of Clinical Data Management. Can any body post the total tutorial of Oracle Clinical? |
|
i am making a programming that show an error pl.any body help me my code is DECLARE GRADE CHAR:='A'; BEGIN CASE GRADE WHEN 'A' THEN dbms_output.put_line('Excellent'); WHEN 'B' THEN dbms_output.put_line('Very Good'); WHEN 'C' THEN dbms_output.put_line('Good'); WHEN 'D' THEN dbms_output.put_line('Fair'); WHEN 'F' THEN dbms_output.put_line('Poor'); ELSE dbms_output.put_line('No such grade'); END CASE; END; / ERROR at line 4: ORA-06550: line 4, column 1: PLS-00103: Encountered the symbol "CASE" when expecting one of the following: begin declare exit for goto if loop mod null pragma raise return select update while <an identifier> <a double-quoted delimited-identifier> <a bind variable> << close current delete fetch lock insert open rollback savepoint set sql execute commit forall <a single-quoted SQL string> |
