How to insert date values into table

How can I insert into table with different input using / ,with date datatype?

insert into run(id,name,dob)values(&id,'&name',[what should I write here?]);

I’m using oracle 10g.

Related Posts:

  1. ORA-01861: literal does not match format string
  2. Convert timestamp to date in Oracle SQL
  3. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  4. ORA-00904: invalid identifier
  5. how to fix oracle ORA-01722 invalid number error
  6. SQL query to select dates between two dates
  7. ORA-00979 not a group by expression
  8. ORA-00907: missing right parenthesis
  9. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  10. ORA-01843 not a valid month- Comparing Dates
  11. ORA-00918: column ambiguously defined in SELECT *
  12. Oracle error : ORA-00905: Missing keyword
  13. How do I limit the number of rows returned by an Oracle query after ordering?
  14. Oracle SELECT TOP 10 records
  15. Can a foreign key be NULL and/or duplicate?
  16. How to Select Top 100 rows in Oracle?
  17. ORA-12560: TNS:protocol adaptor error
  18. Get day of week in SQL Server 2005/2008
  19. ORA-00972 identifier is too long alias column name
  20. Oracle Apex column link from LOV values
  21. PLS-00103: Encountered the symbol when expecting one of the following:
  22. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  23. ORA-00918: column ambiguously defined in SELECT *
  24. ORA-00918: column ambiguously defined in SELECT *
  25. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  26. DateTime2 vs DateTime in SQL Server
  27. What is it exactly a BLOB in a DBMS context
  28. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  29. How do you create a temporary table in an Oracle database?
  30. Oracle “Partition By” Keyword
  31. How do I query for all dates greater than a certain date in SQL Server?
  32. Oracle SQL: Update a table with data from another table
  33. Sql query to insert datetime in SQL Server
  34. SQL selecting rows by most recent date with two unique columns
  35. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  36. Comparing Dates in Oracle SQL
  37. How do I reset a sequence in Oracle?
  38. Query to convert from datetime to date mysql
  39. Update statement with inner join on Oracle
  40. Subtract one day from datetime
  41. MySQL equivalent of DECODE function in Oracle
  42. Get current year in TSQL
  43. How do I query for all dates greater than a certain date in SQL Server?
  44. Oracle: If Table Exists
  45. DATEDIFF function in Oracle
  46. How to create id with AUTO_INCREMENT on Oracle?
  47. LEFT function in Oracle
  48. What is the difference between Views and Materialized Views in Oracle?
  49. How do I view the Explain Plan in Oracle Sql developer?
  50. ORA-01779: cannot modify a column which maps to a non key-preserved table
  51. ORA-01735: invalid ALTER TABLE option – Toad
  52. Unknown column in ‘field list’ error on MySQL Update query
  53. SQL Inner-join with 3 tables?
  54. MySQL create table if not exists and insert record only if table was created
  55. Rename column SQL Server 2008
  56. SQL Error: ORA-00942 table or view does not exist
  57. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  58. ORA-00984: column not allowed here [duplicate]
  59. How Stuff and ‘For Xml Path’ work in SQL Server?
  60. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  61. must appear in the GROUP BY clause or be used in an aggregate function
  62. How can I return pivot table output in MySQL?
  63. The multi-part identifier could not be bound
  64. What does the following Oracle error mean: invalid column index
  65. MySQL syntax for Join Update
  66. SQLite – UPSERT *not* INSERT or REPLACE
  67. how to drop partition without dropping data in MySQL?
  68. Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
  69. Simple way to calculate median with MySQL
  70. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  71. Error 1046 No database Selected, how to resolve?
  72. Oracle SQL query for Date format
  73. What is the Oracle equivalent of SQL Server’s IsNull() function?
  74. How to SUM and SUBTRACT using SQL?
  75. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  76. Postgresql tables exists, but getting “relation does not exist” when querying
  77. Postgres Error: More than one row returned by a subquery used as an expression
  78. SQL Parentheses use in an OR clause
  79. Is it possible to GROUP BY multiple columns using MySQL?
  80. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  81. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  82. Best way to test if a row exists in a MySQL table
  83. Is it possible to specify condition in Count()?
  84. SQL Server: Make all UPPER case to Proper Case/Title Case
  85. using sql count in a case statement
  86. Temporary table in SQL server causing ‘ There is already an object named’ error
  87. MySQL OPTIMIZE all tables?
  88. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  89. How do I count unique items in field in Access query?
  90. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  91. What is a postgres superuser
  92. prepare() not working
  93. How do I move a WordPress site to another server?
  94. WP Optimization: Removing Orphaned wp_options (especially the autoload ones)
  95. Auto-update tables from database
  96. dbDelta not creating table (yes, once more)
  97. How to export 2 week’s worth of posts
  98. blank page after update my theme
  99. wpdb prepare without placeholder
  100. Want to delete woocommerce coupon in bulk from phpmyadmin based on published date

Leave a Comment